PDF to Excel Data Extractor

I have a collection of PDFs that follow the same, consistent layout and I need all of the embedded text and numeric values pulled into a clean Excel worksheet. The files present the information in two ways—straightforward paragraphs as well as small form-style tables—so the extractor has to recognise and handle both structures without breaking the order in which they appear.

Because the template never changes, the job is essentially to build (or configure) a repeatable script or lightweight tool that can:

• scan each structured PDF,
• capture every piece of text content and every number, and
• place them into clearly labelled columns in .xlsx, one row per document.

I’m fine with Python (pdfplumber, PyPDF2, camelot, tabula-py) or another language you prefer, provided the end result is a simple routine I can run myself for future batches. Accuracy is more important than speed; if a number fails to import the run should flag that file for review rather than silently skipping it.

Deliverable: the working code or macro, brief usage notes, and a sample Excel output generated from three of my PDFs so I can verify the mapping.