How to Convert PDF to a Single Excel Sheet
Convert a PDF table into one Excel sheet instead of a tab per page: the most reliable extraction method, combining pages, and checking the numbers.
Getting a PDF table into one Excel sheet is really two problems: extracting the table at all, and stopping the converter putting each page on its own tab. The second surprises people more than the first.
Why you get one sheet per page
A PDF has no tables. It has lines drawn on a page and text positioned near them, and nothing in the file marks a group of text as a table, a row or a cell. Converters infer that structure from geometry — and because they work page by page, they usually emit one worksheet per page and let you reassemble it.
That inference is also why a table split across a page break commonly loses its header on the second half.
The most reliable approach
Tabula is free, open source, runs locally, and is built for exactly this. You draw a box around the table, and it extracts what is inside — which sidesteps most of the guessing. It can process several pages with the same selection and output a single CSV, which opens as one sheet.
Adobe Acrobat exports to Excel directly and handles multi-page tables better than most, though it still tends toward one sheet per page on complex documents.
Power Query in Excel (Data → Get Data → From File → From PDF) is underused and often the best answer for a repeating job: it lists the tables it finds, you pick them, and Append Queries combines them into one sheet. Once set up it re-runs on next month's file.
camelot and pdfplumber are Python libraries worth knowing if this is recurring — both give real control over how tables are detected, and both output straight to a single DataFrame.
Combining afterwards
If your converter has already produced one sheet per page, the fastest fixes are Power Query's Append, or a small script. Copying and pasting by hand is where errors enter — particularly when a repeated header row gets pasted into the middle of the data.
Check the numbers before you trust the sheet
Extraction confuses columns when cells are empty, merges numbers when spacing is tight, and silently drops digits when a value straddles a detected boundary. Spot-check totals against the PDF. This is the step people skip, and it is where the expensive mistakes live.
For bank statements specifically, bank statement to Excel is built around that format rather than inferring it generically.
Frequently asked questions
Why does my table lose its header on later pages? The converter treats each page independently, so a header printed once is only attached to the first page's table.
Can I convert a scanned table? Not until OCR gives it a text layer. Even then, accuracy on numbers is worth checking carefully.
Which is most accurate? Tabula when you can draw the selection yourself, because it removes the detection guesswork. Acrobat is strongest fully automatic.
How do I stop one sheet per page? Use a tool that outputs CSV, or append the sheets afterwards with Power Query.
