PDF to Excel Converter — Extract PDF Tables to Spreadsheet
Extract tabular data from PDF files and convert it to an editable Excel spreadsheet (.xlsx). Works best on text-based PDFs with clearly structured tables. No file upload, no signup, completely free.
Select or drop a PDF file
PDFs with tables or structured data — max ~50 MB recommended
What This Tool Does
Extracts tables and structured data from PDF files and converts them to Excel (.xlsx) format — processed in your browser without uploading the file anywhere.
Who This Is For
- Analysts recovering data from PDF reports when the original spreadsheet is unavailable
- Accountants pulling figures from PDF invoices, bank statements, or financial tables
- Anyone who needs to do calculations on data that's currently locked inside a PDF
- Data engineers extracting structured data from PDF exports for downstream processing
Example: Input: A PDF containing a 10-column financial table with 200 rows → Output: An .xlsx file with the extracted table data in cells, ready for formulas, pivot tables, and analysis
How PDF Table Extraction Works
PDF files store table data not as structured rows and columns, but as individual text items positioned at specific x/y coordinates on the page. Extracting a table requires detecting which text items belong to the same row (similar y-coordinate) and which belong to the same column (similar x-coordinate), then reconstructing the grid structure.
This tool uses PDF.js to extract all text items from the PDF along with their position data. It then applies a clustering algorithm to group items by row (vertical proximity) and column (horizontal alignment), producing a 2D grid that maps to spreadsheet rows and columns. The result is exported as a proper .xlsx file using the SheetJS library, which opens directly in Excel, Google Sheets, and all other spreadsheet applications.
Why Table Detection Varies in Accuracy
The accuracy of table detection depends heavily on how the PDF was created. Tables exported directly from Excel to PDF retain precise coordinate alignment — every cell's text is positioned exactly on a grid, making reconstruction highly accurate. Tables in reports created by design tools (InDesign, Illustrator) may use positioned text boxes that do not align to a grid, making column detection unreliable. PDFs created from scanned documents contain no text data at all.
When to Convert PDF to Excel
| Situation | Expected Result | Notes |
|---|---|---|
| Financial report with simple tables | Good | Rows and columns typically well-aligned in financial PDFs |
| Bank statement or invoice | Good — moderate cleanup | Line items extract well; headers may merge with data |
| Government data or statistics tables | Good | Tabular government PDFs usually have clean coordinate alignment |
| Academic paper with tables | Moderate | Two-column layouts may cause row merging across columns |
| Scanned table (image-based PDF) | Not possible | No text data to extract — requires OCR first |
| PDF with merged cells or spanning headers | Partial | Merged cells are split; spanning headers may be misaligned |
Tips for Better Extraction Results
- Verify the PDF is text-based — try selecting text in the PDF before converting. If you cannot select text, it is a scanned PDF and needs OCR first
- Use "Extract all text as rows" mode for non-table structured data like lists and reports — this produces one row per line of text
- Open the .xlsx in Excel after download — check column widths and adjust formatting as needed for your use case
- Extract one page at a time for PDFs where different pages have different table structures
- For bank statements, the date and description columns often merge — try the "Tight" column sensitivity setting, or manually split them in Excel after import
🔒 Your Financial and Business Data Stays on Your Device
PDF files being converted to Excel frequently contain sensitive financial data: bank statements, invoices, tax documents, payroll records, business reports. Uploading these files to a cloud conversion service means your financial data travels to and is stored on a third-party server — even briefly.
This converter runs entirely in your browser. Your PDF is read from local storage, the table extraction runs in your browser's JavaScript engine, and the Excel output is offered as a local download. No file data is transmitted to any server.
The only network requests this page makes are for the PDF.js and SheetJS libraries (loaded once from a CDN) and the Google Analytics tag. Your actual file content is never transmitted.
💡 For extracting the full document text rather than just tables, use PDF to Word. To work with the extracted data in JSON format, the CSV to JSON converter can transform exported data into a structured JSON array. If you need to create a PDF from an Excel spreadsheet, Excel to PDF handles the reverse.
Related Guides & Tutorials
PDF and Spreadsheet Workflow Tools
Extracting data from PDFs to Excel is part of a broader document workflow:
- Convert Excel back to PDF once you've edited and analyzed the data
- Compress the PDF first if the source file is large — smaller files process faster
- Split the PDF to isolate specific pages with the tables you need
- Convert CSV to JSON if you need the extracted data in a different format
- Format and inspect the data after exporting from Excel
Frequently Asked Questions
Related Tools
- Have data spread across multiple PDFs? Merge them first, then extract all tables at once. → merge multiple PDFs before extracting data
- Data in a PowerPoint slide deck? Convert PPTX to PDF, then extract the tables to Excel. → convert PowerPoint data slides to PDF first
- Got a web page with a data table? Convert it to PDF first, then extract to Excel. → convert a web table to PDF before extracting
- Have spreadsheet screenshots? Combine them into a PDF, then extract the data. → combine data images into a PDF for extraction