Key takeaways
- PDF to Excel reads each page's text positions and groups them into rows and columns automatically.
- Each page of the PDF becomes its own sheet in the resulting .xlsx file.
- Works on PDFs with real, selectable text — scanned statements need OCR first, since there's no text layer to read positions from.
- Column detection is based on spacing, so it works best on PDFs with clearly separated columns rather than dense, tightly-packed layouts.
Pulling a table out of a PDF
With PDF to Excel:
- Drop in the PDF — a bank statement, invoice, or any document with tabular data.
- Press "Convert to Excel."
- Download the .xlsx file — open it and check the columns lined up the way you expected; dense or unusually formatted tables may need a little manual tidying.
When table extraction gets it wrong
- Scanned PDFs (photos of pages) have no text layer at all to read — run PDF OCR first, then work from the resulting text.
- Very tightly spaced columns can occasionally get merged into one cell, since the gap between them isn't much wider than a normal word space.
- Multi-line cells (a table cell with wrapped text) may split across more than one row.
For a simple, cleanly formatted table — the most common case, like a bank statement or invoice line-item list — the automatic extraction usually needs little to no cleanup.
Frequently asked questions
Can it handle a PDF with several tables across many pages?
Yes — each page's content becomes its own sheet, so a multi-page statement turns into a workbook with one sheet per page.
Does it work on scanned bank statements?
Not directly — a scan has no embedded text to read positions from. Run it through [PDF OCR](/pdf-ocr) first, then work with the extracted text.