Convert a PDF table to Excel
Copying a table out of a PDF usually gives you one long column of text, or numbers glued to the wrong rows. Page headers and footers get mixed into the data, and every amount arrives as text.
Drop the PDF here instead. The table is rebuilt from the position of each word, pages are joined into one table, repeated headers and page numbers are taken out, and dates and amounts become real values you can sort and sum.
Drop files here
or browse your files
XLSX, XLS, CSV, TXT, PDF · up to 25 MB · 1 file without an account
Or try a sample:
Example: before and after
A four-page sales report without borders: the title lines are set aside, and “$7,794.00” becomes the number 7,794 in a Revenue column.
Monthly Sales Report - Q1 2026 Riverbend Coffee Roasters · all regions Date Region Rep Product Units Revenue 01/03/2026 South J. Rivera Gel pen set (10) 600 $7,794.00 01/04/2026 Midwest S. Patel Ceramic coffee mug 12 oz 706 $9,884.00 01/04/2026 South A. Morgan Canvas tote bag 396 $7,128.00 01/06/2026 West K. O'Brien LED desk lamp 29 $1,218.00 01/08/2026 Midwest K. O'Brien Green tea 3.5 oz 342 $2,479.50
| Date | Region | Rep | Product | Units | Revenue |
|---|---|---|---|---|---|
| 01/03/2026 | South | J. Rivera | Gel pen set (10) | 600 | 7,794.00 |
| 01/04/2026 | Midwest | S. Patel | Ceramic coffee mug 12 oz | 706 | 9,884.00 |
| 01/04/2026 | South | A. Morgan | Canvas tote bag | 396 | 7,128.00 |
| 01/06/2026 | West | K. O'Brien | LED desk lamp | 29 | 1,218.00 |
| 01/08/2026 | Midwest | K. O'Brien | Green tea 3.5 oz | 342 | 2,479.50 |
How to do it
- 1Drop the PDF (up to 20 pages on the free plan; scanned pages are read with OCR).
- 2Check the table and the list of steps on the right — each one can be switched off.
- 3Download XLSX, or copy the table and paste it into Excel or Google Sheets.
Questions
Does it work with scanned PDFs?
Yes. Pages without a text layer are read with OCR. If a scan is too blurry to read reliably, you’ll be told which pages, and on plans with AI pages you can have them read by AI instead.
What about tables that continue over several pages?
Pages with the same columns are joined into one table, and the header repeated at the top of each page is removed. Totals at the bottom are used to check the rows and kept out of the data.
Can I convert a PDF bank statement?
Yes. Statements are recognised as one table with dates, descriptions and amounts; descriptions that wrap onto a second line are joined back together, and the running balance is checked.
Related tasks
- Extract invoice data to ExcelFields and line items from US, UK and EU invoices, with the arithmetic checked.
- Combine many PDFs into one tableA batch of PDFs into one table with a Source file column, grouped by layout.
- Fix numbers stored as textAmounts with $, £, €, commas, brackets or trailing minus become real numbers.