Pull tables out of a PDF into Excel
or drag and drop a file here
PDF · up to 50 MB
Check the result
Privacy: this tool runs in your browser. Your file is not uploaded to our servers. How we handle files
How to use PDF to Excel
Choose a PDF and the tables in it are found for you. Check them in the preview, then download an Excel workbook or a CSV file. It works on PDFs made from text; a scan is only a picture and needs OCR first.
- Choose a PDF that has selectable text, such as a bank statement, an invoice or a report.
- Look at the tables that were found. Untick any you do not want, and choose whether each goes on its own sheet, each page on a sheet, or everything on one sheet.
- Download the Excel file (.xlsx), or the CSV file if you prefer plain text, and check the numbers against the PDF.
Supported formats and limits
- Input: PDF, up to 50 MB per file.
- Up to 200 pages. Only tables made of text are found, by looking at how the text lines up in rows and columns.
- Scanned PDFs and tables that are pictures have no text to read. Run them through OCR PDF first and expect recognition mistakes.
- Merged cells, cells that run over several lines, nested tables, tables without gaps between columns, rotated text and tables drawn as images are not handled faithfully. Some cells can land in the wrong column or row.
- Text that happens to line up (a list of labels and values, a form) can be taken for a table, and a real table can be missed. That is why every table is shown and can be left out.
- A cell becomes a number only when it is clearly one: thousands separators, decimals, negatives in (brackets), percentages and a currency symbol are understood. Codes with leading zeros, dates and anything unclear stay text. Formats such as 1.234,56 are left as text.
- In the CSV, numbers have no thousands separators or currency symbol, and text that starts with = + - or @ gets a leading apostrophe so a spreadsheet does not treat it as a formula.
- Always check the result against the PDF before you use the figures.
- Password-protected PDFs are not accepted here. The tool reports them and stops; remove the password first with Unlock PDF (you must know it), then use the unlocked copy.
Frequently asked questions
Why does it say no table was found?
Either the PDF has no selectable text (a scan or a photo), or the text is not laid out in rows and columns with clear gaps. For a scan, use OCR PDF. If you only need the words, PDF to Text gives them without any table structure.
Why are some numbers left as text?
A cell is turned into a number only when it clearly is one. Dates, codes such as 007, and formats where the comma is the decimal mark (1.234,56) stay as text so no value is changed silently. You can convert a column in Excel with Text to Columns or the VALUE function.
A table that runs over several pages came out in pieces. What now?
Leave Join tables across pages ticked, which is the default: tables that continue on the next page are joined and a repeated header row is dropped. If two different tables were joined by mistake, untick it to get one table per page.
Is my PDF uploaded to find the tables?
No. The text positions are read in your browser and the Excel file is built there too, so the file and its contents stay on your device.
Which should I download, Excel or CSV?
Excel keeps several tables as separate sheets and shows numbers with the same decimals, brackets and percent signs as the PDF. CSV is plain text for importing into other software; with several sheets you get a ZIP of CSV files.
Related tools
- PDF to TextPull the text out of a PDF page by page, then copy it or save a .txt file. It runs in your browser, so your file is not uploaded. Scans need OCR first.
- OCR PDFRead the text in scanned PDFs and photos of documents. Copy it, or download a searchable PDF. Recognition runs in your browser, so nothing is uploaded.
- PDF to Word (text only)Turn the text of a PDF into an editable Word file with headings, paragraphs and page breaks. A text conversion, not layout-faithful. Runs in your browser.
- Extract PDF PagesPick the pages you want from a PDF and save them together as one new PDF, in the order you list them. Works in your browser without uploading.
Created and maintained by Jasmin Gohil. Last reviewed .