Extract Tables from PDF to Excel
Upload a PDF report, price list or data sheet and get only its tables as Excel cells. Headings, paragraphs and page numbers are left out, and a table that breaks across pages is joined back together.
- 1Upload
- 2Convert
- 3Download
PDF input, scanned or password-protected. Review the OCR result before use. Usage and download limits apply.
Is the table in a picture or screenshot? Extract a table from an image
How to extract a table from a PDF to Excel
Keep “Tables only” on to get just the tables; turn it off to keep the text around them.
- Step 1
Upload the PDF
Choose one PDF of up to 20 pages, digital or scanned. Protected PDFs ask for their password, which stays in your browser.
- Step 2
Keep “Tables only” on
Only the tables are extracted. Each table keeps its rows, columns and merged header cells, and a table split over pages is joined.
- Step 3
Download Excel or CSV
Check the row count and a few values against the PDF, then download XLSX, XLS or CSV.
Tables only, or the whole page
With “Tables only” on, the converter keeps the tables and leaves out headings, paragraphs, footnotes and page numbers. Each table keeps its rows, columns and merged header cells, and the tables of the PDF are placed one below another in the sheet.
Turn “Tables only” off when the text around a table matters, such as an invoice's header and totals. The sheet then follows the page from top to bottom, with the tables in place.
Tables split across pages
Long tables in reports and statements continue on the next page, often repeating the header row. Copying page by page leaves duplicate headers in the middle of your data. Here the rows of every page are joined in order, and a repeated header is kept only once.
Why copy and paste from a PDF breaks tables
A PDF positions each word on the page; it does not store rows and columns. Pasting into Excel therefore puts a whole row into one cell, splits wrapped text over several rows, or loses empty cells so values shift columns. Scanned PDFs have no text to copy at all. Reading the page layout, as this converter does, rebuilds the grid instead.
To convert whole pages, use the PDF to Excel converter. For scans, see scanned PDF to Excel. For bank statements, the bank statement converter joins every page of transactions into one table.
Frequently asked questions
How do I extract a table from a PDF to Excel?
Upload the PDF above with “Tables only” switched on and convert it. The tables come back as Excel cells without the surrounding text; download XLSX or CSV and check the values against the PDF.
Can I extract only one table from a PDF?
The converter returns every table in the PDF, one below the other in the sheet. Delete the ones you do not need in Excel, or upload only the pages that hold your table.
What happens to a table that continues on the next page?
It is joined into one table, and a header repeated at the top of the next page is kept only once.
Does it work on scanned PDFs?
Yes. Every PDF is read with OCR, so tables in scanned or image-only PDFs are extracted as well as tables in digital PDFs.
Can I extract tables from a PDF to CSV?
Yes. After converting, choose CSV in the download menu. CSV keeps the values but not merged cells or formatting.
Is there a page limit?
One PDF of up to 20 pages per conversion. The first pages are free once a day; converting every page uses credits per page or a one-time pack.