Extract tables from PDF to Excel spreadsheet
Turn tables locked inside a PDF into a spreadsheet you can actually calculate with. Upload your document, download a spreadsheet file, and open it in Excel, Google Sheets, or LibreOffice Calc. Free, no software to install, and no watermark.
Financial data has a habit of arriving as a PDF. Bank statements, invoices, supplier price lists, published financial reports, government statistics, and system exports are all routinely distributed in a format designed for reading rather than calculating.
The numbers are all there and perfectly visible, but you cannot sum a column, sort by value, filter for a date range, or feed the figures into a model. The default response — retyping everything into a spreadsheet by hand — is slow and introduces exactly the kind of transcription errors that are hardest to spot afterwards.
Tables with visible ruled borders are the best case. The lines give the converter unambiguous boundaries, so columns and rows map across accurately.
Consistently aligned columns convert well even without borders, as long as the spacing is regular down the whole table.
Tables separated only by white space are harder. The converter has to guess where columns divide based on gaps, and a column of short values next to a column of long ones can confuse that judgement.
Merged cells, multi-line rows, and nested headers frequently need manual repair, because there is no clean spreadsheet equivalent for some of the layouts a PDF can display.
Scanned tables cannot be converted meaningfully at all without OCR first.
This surprises people, so it is worth explaining properly. When a spreadsheet is exported to PDF, every formula is evaluated and only the resulting value is written into the file. A cell that contained =SUM(B2:B15) becomes the number 4,832 and nothing else. The formula is not hidden somewhere in the PDF — it genuinely no longer exists in the document.
Converting back therefore recovers the numbers but not the calculations. If you need the working model rather than the results, ask whoever produced the PDF for the original spreadsheet.
Accountants and bookkeepers pull transaction data out of PDF bank statements for reconciliation. Analysts extract figures from published financial reports to build their own models. Procurement teams convert supplier price lists so they can compare across vendors. Researchers lift statistical tables out of published papers and government reports. Anyone facing a long table in a PDF who would otherwise be retyping it.
Upload your PDF by dragging it onto the box or clicking to browse. The conversion runs automatically and your spreadsheet file downloads when ready. Open it and compare it against the original document before working with the data.
This is the single most valuable habit when converting tabular data. Add up a column in your new spreadsheet and check it against the total printed in the PDF. If the figures match, the rows and columns aligned correctly. If they do not, something was misread — usually a merged cell, a row that split in two, or a header absorbed into the data.
Checking one or two totals takes thirty seconds and catches structural errors that would otherwise propagate silently through everything you build on the data. Numbers that are subtly wrong are considerably more dangerous than numbers that are obviously missing.
A common annoyance after conversion is a column of figures that Excel refuses to sum. This happens when currency symbols, thousands separators, or trailing spaces come across with the value, causing the spreadsheet to treat it as text. Excel's Text to Columns feature converts a whole column in one operation, and a find-and-replace to strip symbols usually handles the rest.
If your PDF is a scan, there is no text to extract — only an image of a table. Extract Text (OCR) recognises the characters and gives you text to work with, though it recovers the words rather than the table structure, so scanned tables generally need arranging by hand afterwards.
Your document is processed in memory and discarded the instant your download completes. Nothing is written to disk, nothing is logged, and no copy is retained — worth knowing when the tables are bank statements or financial records.