Why is my PDF showing no table?

Either the PDF is a scan, a picture of the page with no text in it, or the table is laid out in a way the detection did not recognise. For a scan there is no text to read. For anything else, drag the blue box over the table and double-click inside it to add a column line between each pair of columns.

Will the numbers work in Excel formulas?

Yes. Anything that reads as an amount, including 1,234.56, 1.234,56, (12.00) and 12.00-, is saved as a number, and the decimal separator is worked out from the whole document. Dates and codes are left as they are printed.

Can it convert a whole PDF, with its text and layout, to Excel?

It converts the tables: the rows and columns of data, which is what a spreadsheet is for. Headings, paragraphs and pictures outside the table are left out. To turn a whole PDF into an editable document, a PDF to Word converter is the better tool.

What about bank statements?

Switch to Bank statement, or use the Bank Statement Converter. It reads the table as transactions, joins descriptions that wrap onto a second line, checks every running balance, and saves Excel, CSV, OFX or QIF.

Does the PDF leave my computer?

No. It is read in your browser on your computer, which matters for the documents people most often need tables from: statements, payslips, invoices and reports.

Stays on your computer How this works

PDF to Excel

Turn the tables in a PDF into an Excel spreadsheet or CSV: price lists, reports, invoices and statements, with every cell in its column. Free, and the PDF never leaves your computer.

Drag & drop a PDF here, or browse

Any PDF with tables in it · nothing is uploaded

About converting PDF tables to Excel

A table in a PDF is not really a table: the file only says where each word sits on the page. Copy and paste it and the columns collapse into one jumbled column. This tool rebuilds the table. It reads the position of every piece of text on each page, groups the text into rows, and finds the columns from the lines drawn between them, or, where there are none, from the gaps that run straight down the page. The table found is shown on the page, so you can see exactly what will go into the spreadsheet and move a column line that is in the wrong place.

Numbers come through as numbers Excel can add up, not as text, whichever way the PDF writes them. Each page can go on its own sheet, or all of them onto one, with the column headings repeated at the top of each page left out. Everything happens in your browser: the PDF is never uploaded. It is free to use, with no account and no upload limit, and it runs entirely in your browser: nothing is uploaded, and while the page stays open, a feature you have already used keeps working offline.

What you can do

Convert tables in a PDF to Excel (.xlsx) or CSV
Find columns from ruled lines, or from the gaps between columns when there are no lines
See the table and its columns drawn on the page, and drag a column line, add one or remove one
Choose the table's top and bottom, to leave out titles and totals
Use the same columns on every page of a long report
Put all pages on one sheet, or each page on its own
Read a bank statement as transactions, and save it for accounting software
Open a password-protected PDF with its password

How to convert a PDF table to Excel

Drop the PDF onto the page, or click to choose it.
Check the blue box and the column lines on each page. Drag a line that splits or merges a column, and drag the box's edges to take in the right rows.
Look over the preview, then press Excel or CSV.

Questions

Why is my PDF showing no table?: Either the PDF is a scan, a picture of the page with no text in it, or the table is laid out in a way the detection did not recognise. For a scan there is no text to read. For anything else, drag the blue box over the table and double-click inside it to add a column line between each pair of columns.
Will the numbers work in Excel formulas?: Yes. Anything that reads as an amount, including 1,234.56, 1.234,56, (12.00) and 12.00-, is saved as a number, and the decimal separator is worked out from the whole document. Dates and codes are left as they are printed.
Can it convert a whole PDF, with its text and layout, to Excel?: It converts the tables: the rows and columns of data, which is what a spreadsheet is for. Headings, paragraphs and pictures outside the table are left out. To turn a whole PDF into an editable document, a PDF to Word converter is the better tool.
What about bank statements?: Switch to Bank statement, or use the Bank Statement Converter. It reads the table as transactions, joins descriptions that wrap onto a second line, checks every running balance, and saves Excel, CSV, OFX or QIF.
Does the PDF leave my computer?: No. It is read in your browser on your computer, which matters for the documents people most often need tables from: statements, payslips, invoices and reports.

Built by John McMillan, a senior full-stack engineer. Open to remote roles: hire me.

Report a problem or suggest a feature