Get PDF tables into a spreadsheet
Copying a table from a PDF usually gives you one long line of text. Bank statements, price lists, invoices and reports are much more useful in Excel, where you can sort, filter and add up the numbers.
This converter looks at where text sits on each page and works out the columns from the white space between them, so left-aligned names and right-aligned amounts land in the right cells. Values such as 12,400, $1,250.00, (300) and 45% are turned into real numbers with matching formatting. You can keep one sheet per page or put every page on a single sheet.
How to convert PDF to Excel
- 1
Select the PDF
Choose a PDF with tables. Password-protected files ask for the password.
- 2
Choose the layout
Keep one sheet per page, or tick Put all pages on one sheet for statements that continue across pages.
- 3
Convert
Press Convert to Excel.
- 4
Check and use
Open the .xlsx in Excel, Google Sheets or LibreOffice and tidy any merged cells.
Key features
Column detection
Works out columns from the layout, not just from spaces.
Numbers stay numbers
Thousands separators, currency symbols, negatives in brackets and percentages are converted.
Sheet options
One sheet per page or all pages combined.
Column widths
Columns are sized to fit their content.
Private
Conversion runs in your browser; statements never leave your device.
Common uses
- Bank statements: Categorise spending or reconcile accounts in a spreadsheet.
- Price lists and quotes: Compare suppliers side by side.
- Reports: Reuse published figures in your own charts.
Tips and good to know
- Works on PDFs with real text. Scanned tables are images and need OCR first.
- Cells that span several columns in the PDF may land in the first column — a quick check after converting fixes this.
- Just need the text, not a table? PDF to Word is a better fit.