How to convert a PDF to Excel
- Drop a PDF that contains tables onto the box above.
- Wait a few seconds while each page's tables are detected.
- Open the downloaded .xlsx file. Each PDF page becomes its own sheet, and amounts are stored as numbers.
How tables are detected
- Tables with ruled lines (grids drawn around cells) are read cell by cell using the lines.
- Tables without lines, common in bank statements, are rebuilt from how text lines up in columns.
- Pages with no table still have their text placed in rows, so nothing is lost.
Table detection uses Tabula, the open-source engine created for journalists to extract data from PDF reports.
Tips
- Check that you can select text in the PDF. If you can't, it's a scan, so use Image to Text (OCR).
- Only need a few pages? Extract them first with Split PDF for a cleaner spreadsheet.
Frequently asked questions
Drop your PDF onto the box above. The tables on each page are detected and written to an .xlsx spreadsheet, one sheet per page, which downloads automatically.
Yes, if the PDF was created digitally (you can select the text in a PDF reader). Rows and columns are rebuilt from the position of each piece of text, and amounts become real numbers you can add up, including negative numbers in brackets.
Scanned PDFs are pictures and contain no text, so there are no cells to extract. Run them through Image to Text (OCR) first. Tables without clear columns, or text in several columns, may need tidying in Excel.
No. The PDF is sent over an encrypted connection, processed in memory and in a temporary folder, and deleted when the spreadsheet is ready. We don't keep copies.
Yes. The .xlsx format opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc.