Batch Extract PDF Tables to Excel

I have a PDF packed with several tables of purely numerical data, and every one of those tables follows the exact same column layout. I need all of them moved into a single, tidy Excel workbook so I can immediately start running calculations and analyses.

Here’s what the finished file must look like:
• One sheet with the column headers reproduced once, followed by every row from every table in the order they appear in the PDF.
• Values preserved as numbers rather than text, ready for formulas and pivot tables.
• No stray characters, merged cells, or alignment issues—data should sit in a clean grid that mirrors the source.

Feel free to use any extraction approach you trust—Python (camelot, tabula-py, pdfplumber), Power Query, Adobe tools, or a hybrid of automation and manual checks—as long as the end result is 100 % accurate. If you script the job, including the code (or a brief outline of the steps) will be appreciated so I can repeat the process when the document is updated.

Send back the .xlsx file and, if applicable, your script or method note, and I’ll take it from there.