Extract PDF Tables to Excel
Extract tables to .xlsx
A PDF has no idea it contains a table; it just draws text at coordinates. Tables are recovered by finding columns of consistently aligned text, which works well on ruled or neatly aligned tables such as bank statements, invoices and system exports. Borderless tables, merged cells, cells with several lines of text, and tables continuing across a page break are where it struggles. You get a preview of every detected grid before you download, and a confidence figure per page, so you can see which one you have rather than finding out in Excel.
What is PDF to Excel Converter?
Pull tables out of a PDF into a spreadsheet, entirely in your browser. A PDF does not know it contains a table, so columns are recovered by finding text that lines up vertically. That works well on ruled or neatly aligned tables such as bank statements, invoices and system exports. You get a preview of every detected grid with a confidence figure per page, and a tolerance control to widen or narrow what counts as one column, so you can see what you are getting before it reaches Excel rather than after.
How do I use PDF to Excel Converter?
- Drop the PDF; every page is scanned for aligned columns.
- Review each detected grid and its confidence figure.
- Adjust the alignment tolerance if columns are split or merged.
- Deselect any page you do not want, then download the .xlsx or copy the CSV.
When should I use PDF to Excel Converter?
Use this for tabular data. For prose, use PDF to Word instead. If the pages are scans, run OCR first so there is text to align. To convert a spreadsheet into a PDF, use Excel to PDF.
Frequently asked questions
How does it find tables if a PDF has no table structure?
By geometry. Every piece of text has a horizontal position, and a table shows up as several rows sharing the same set of positions. Those clusters become columns, and each piece of text is assigned to the nearest one. A column is only accepted when enough rows support it, so a single stray word does not invent one.
What is the confidence figure?
How consistently the detected columns are actually filled across the rows. A fully populated grid scores high. A low score means many cells came out empty, which usually means the region is not really a table or its columns are too irregular to line up. It is there so you can judge the result rather than trust it blindly.
What does the tolerance control do?
It sets how far apart two text positions can be and still count as the same column. Raise it if one real column is being split in two; lower it if two adjacent columns are being merged. Because the preview updates as you drag it, you can tune it against your actual document.
Which tables does this struggle with?
Borderless tables with uneven spacing, merged cells, cells containing several lines of text, nested headers, and tables continuing across a page break, which come out as separate sheets. Right-aligned numeric columns sitting close to their neighbour can also merge. Ruled and consistently aligned tables are the good case.
Why is each page a separate sheet?
Because a table continuing across pages usually repeats its header, and blindly concatenating would interleave header rows into the data. Keeping pages separate makes the joins visible so you can combine them deliberately.
I only want the numbers, not a workbook.
Use Copy CSV, which puts every selected row on your clipboard in one go. That is often all anyone actually needs and it skips the spreadsheet entirely.
Is my file uploaded anywhere?
No. Everything runs in your browser. Your files never leave your device, and there is no server component for this tool.
Tools that pair well with PDF to Excel Converter
- PDF to Word Converter editable .docx output, free and in your browser.
- Excel to PDF Converter .xlsx → pdf, free and in your browser.
- Excel to CSV Converter .xlsx → csv, free and in your browser.
- TSV to CSV Converter tab-sep → comma-sep, free and in your browser.