Turn PDF tables into a spreadsheet
Bank statements, invoices, price lists and reports often arrive as PDFs. PDF to Excel reads the text of each page: words on the same line become a row, and words that line up vertically become a column. Values such as 1,234.56, $45.00 and 12% become real numbers with matching formats, so SUM and other formulas work straight away.
One sheet per page, or everything in one
- One per page: each PDF page gets its own worksheet. Good for reports where each page is a different table.
- All pages in one: every row on one sheet. Best for long statements that continue over several pages.
What works best
- PDFs made on a computer (exported from a bank, an accounting program or Excel itself).
- Scanned statements have no text to read: convert them with PDF to Word using OCR, or make them searchable with OCR PDF first.
- Very tight or irregular layouts can merge or split columns. Check the result and adjust it in Excel.