Get the tables out of a PDF and into Excel to add up a bank statement, check an invoice or analyse a price list without copying figure by figure. You get an .xlsx workbook with one sheet per page, the tables in cells and the numbers saved as numbers, ready for formulas and charts. No sign-up and no watermarks.
How to convert PDF to Excel
- Select your PDF files (up to 3 at once).
- Click “Convert to Excel” and wait a few seconds while we read each page.
- Download the Excel file or, if you converted several PDFs, the ZIP with one for each.
How the tables get into the cells
- Tables with lines (borders around the cells) go into Excel cell by cell, exactly as they are in the PDF.
- Tables without lines, very common in statements and price lists, are rebuilt by lining up the text: words that sit in the same column of the page go into the same column of the sheet, with the numbers aligned to the right as usual.
- Text outside the tables (titles, paragraphs) goes into the first column, one line per row, in the same order as on the page.
- Each page of the PDF becomes a sheet of the workbook, named 1, 2, 3…
Numbers you can calculate with
Amounts, quantities and percentages are saved as Excel numbers, not as text, so you can add them up, sort them or chart them straight away. A currency symbol (€, $, £) or a percentage sign is kept as the cell’s format.
Some numbers can be read two ways: “1.234” is one thousand two hundred and thirty-four in some languages and one point two three four in others. We read them with the decimal separator of the language of this page (here, a full stop). If your PDF uses the other convention, convert it from the page in a language that does.
What doesn’t carry over
- Formulas: a PDF only stores the results, so the cells hold values, not the formulas that produced them.
- Colours, fonts and borders: the workbook keeps the data, not the look of the PDF.
- Scanned PDFs: if the pages are images, there is no text to place in cells. We check this first and tell you, because it would need text recognition (OCR), which we don’t offer.
- A heading that touches the next one in the PDF can end up in a single cell; adjusting it takes a second.
Limitations
- Up to 3 PDFs at once, 50 MB each, 100 MB in total and 100 pages per PDF.
- PDFs protected with a password can’t be converted.
Frequently asked questions
Can I add up the numbers once they are in Excel?
Yes. Amounts, quantities and percentages are saved as real numbers, with their currency or percentage as the format, so SUM, sorting and charts work on them straight away.
Does it work with tables that have no lines?
Yes. Most statements and price lists have none, so we line up the text by its position on the page: what sits in the same column in the PDF goes into the same column in Excel.
Will I get back the formulas of the original spreadsheet?
No. When an Excel file is turned into a PDF, only the results of its formulas are kept, so the cells you get hold values. If you have the original Excel file, use that instead.
What happens to the text that isn’t in a table?
It goes into the first column, one line per row and in the same order as on the page, so titles and notes stay next to the tables they belong to.