⚙️ Extraction Settings
📂 Upload PDF File
Drag & Drop PDF file here
or click to browse — never uploaded to any server
✅ PDF Files OnlyAutomatically extract tables from any PDF and export to a real Excel XLSX file. Coordinate-based column detection, auto number/date recognition, multi-sheet workbooks — all in your browser.
Upload your PDF, configure extraction settings, preview the detected table data, and download your Excel file.
Drag & Drop PDF file here
or click to browse — never uploaded to any server
✅ PDF Files OnlyNo PDF loaded yet
Upload a PDF above and click "Load PDF & Extract Tables"
Extract PDF table data to real Excel XLSX workbooks entirely in your browser — with smart column detection and number recognition.
From PDF upload to an editable Excel workbook in under a minute.
A quick primer on the Excel workbook format — what it actually is, and why proper XLSX output beats CSV every time.
XLSX is the modern Excel workbook format introduced with Microsoft Office 2007 and standardized as part of Office Open XML (ISO/IEC 29500). Under the hood, an .xlsx file is a ZIP archive containing structured XML documents that describe sheets, cells, styles, formulas and metadata. The crucial difference from CSV is that XLSX preserves cell types — numbers stay numbers, dates stay dates, and formulas stay formulas — so when you open the file in Excel, SUM and AVERAGE work immediately without any "convert to number" step. This tool builds a real XLSX file in the browser using SheetJS (xlsx.js), reading every text item from your PDF with PDF.js, reconstructing the table geometry from text-item coordinates, classifying each value as number, date or string, and writing the workbook with proper Excel cell typing and auto-sized columns.
Need to convert PDF to other data or document formats? Try our other tools.
From bookkeepers to data analysts, here's where extracting PDF tables into Excel saves real time every day.
All four are common spreadsheet formats — but they have very different capabilities. This table shows when each is the right choice.
| Feature | 📊 XLSX | 📋 CSV | 📑 XLS (legacy) | 📗 ODS |
|---|---|---|---|---|
| Cell types preserved | Yes | No — strings only | Yes | Yes |
| Multi-sheet support | Yes | No | Yes | Yes |
| Formulas | Yes | No | Yes | Yes |
| Formatting & styles | Yes | No | Yes | Yes |
| Open standard | ISO/IEC 29500 | RFC 4180 | Proprietary binary | ISO/IEC 26300 |
| Year introduced | 2007 | 1972 (informal) | 1987 | 2005 |
| Row limit per sheet | 1,048,576 | Unlimited (line by line) | 65,536 | 1,048,576 |
| File size | Compressed | Very small | Medium | Compressed |
| Excel native | Yes | Imported | Yes (legacy) | Read-only often |
| Google Sheets | Native import | Native import | Native import | Native import |
| LibreOffice / Calc | Native | Native | Native | Native |
| Best for | Modern workbook delivery | Data interchange | Legacy compatibility | OpenDocument workflows |
Wherever decision-makers need numbers in spreadsheets — and the data starts life in a PDF — this conversion is the bridge.
Extract transaction histories, statement detail and trading records from PDF statements into Excel for reconciliation, reporting and analysis.
Pull invoice lines, expense reports and GL exports from PDFs into Excel for accounts payable processing, audit trails and journal entries.
Convert published PDF reports — government stats, market research, industry surveys — into Excel for further modeling, visualization and reporting.
Extract lab results, patient billing and pharmacy reports from PDFs into Excel for clinical analytics, billing audits and outcomes tracking.
Convert published PDF datasets, budget tables and audit reports into Excel for policy analysis, FOIA responses and downstream publishing.
Pull holdings tables, dividend schedules and 10-K extracts from broker PDFs into Excel for portfolio analysis and tax preparation.
Convert supplier catalog PDFs, wholesale price sheets and supplier invoices into Excel for product onboarding and price-comparison engines.
Extract bills of materials, schedules of values and rent rolls from PDFs into Excel for project costing, draws and asset modeling.
Convert exhibit schedules, deposition logs and witness lists from case PDFs into Excel for matter management and discovery tracking.
Extract grant award tables, enrollment data and survey results from PDFs into Excel for institutional research and statistical analysis.
Convert shipping manifests, customs declarations and bills of lading from PDFs into Excel for tracking, reporting and trade compliance.
Pull payroll detail, benefits enrollments and headcount summaries from vendor PDFs into Excel for budget, audit and compensation review.
A complete reference for every control in the converter — what it does, what to pick, and how it affects the resulting Excel workbook.
The string here becomes the downloaded filename, with non-alphanumeric characters stripped and spaces converted to dashes. Sales Q3 becomes sales-q3.xlsx. The filename has no effect on internal sheet names — those are controlled by the Sheet Name Format setting.
Auto-detect table columns uses X-coordinate gap clustering to find column boundaries — the right choice for any tabular PDF (invoices, statements, reports). All text lines as rows puts every line into one cell — useful for prose-heavy PDFs where you just want the text in spreadsheet form for review or sorting.
One sheet per PDF page creates a separate worksheet tab for each page — good for multi-page reports where each page is a distinct dataset. All pages merged combines every page's rows into a single sheet, with a blank row between pages, ideal for continuous data spread across many pages.
Text items within this Y-distance (in PDF points) are grouped into the same row. Strict (2pt) for dense tables where rows are very close. Normal (4pt) is correct for most PDFs. Relaxed (8pt) for tables with larger fonts. Loose (14pt) for mixed layouts where row baselines aren't perfectly aligned.
If two text items are separated by more than this many points horizontally, they go in different columns. Small (8pt) for tight, narrow columns. Normal (16pt) is the standard. Large (28pt) for tables with wide column spacing. Very Large (40pt) for sparse layouts. Adjust if columns merge incorrectly (raise) or split incorrectly (lower).
When Yes, the first row of each sheet is styled bold with a green background fill — matching standard Excel table-header conventions. When No, all rows are styled identically as data rows. Disable for raw data dumps where there's no real header row.
When Yes, values like 1,234.56, $12.00, 45% are parsed as JavaScript floats and written as proper Excel number cells (with % formatted as percentage). SUM and AVERAGE work immediately. When No, everything stays as text — useful if you need to preserve formatting exactly.
When Yes, common date patterns (2024-01-15, 15/01/2024, Jan 15 2024) are recognized and stored as Excel date serial values formatted as dd/mm/yyyy. Excel's date functions then work immediately. When No, dates stay as text strings.
Page 1, Page 2… gives clear, full names. P1, P2… is compact for many-page workbooks. Sheet1, Sheet2… matches default Excel naming. Sheet names are capped at 31 characters (Excel limit) and stripped of invalid characters like / \ : * ?.
A few small adjustments will make your converted XLSX cleaner, more accurate and easier to work with in Excel.
This tool reads PDF text streams, not pixels. If you can't select text in your PDF reader, it's a scanned image and needs OCR first — extraction won't work.
The HTML preview shows numbers in green, dates in purple, text in gray. If a column you expect to be numbers shows gray, your detection settings may need tuning.
If two logical columns are appearing as one merged column in the preview, raise the Column Gap Threshold and re-process. Decrease it if one column splits in two.
If table cells contain wrapped text (two lines per row), increase row tolerance to "Relaxed" or "Loose" so both lines are grouped into the same row.
If your PDF has no real header line — just data from row 1 — turn off "First Row as Header" so the first row isn't styled bold and isn't treated specially.
If auto-detect produces weird columns, switch to "All text lines as rows" — this gives you one cell per line, which is easier to clean up manually in Excel.
If your table spans many pages with the same column structure, choose "All pages merged" so you get one continuous sheet instead of dozens of tabs.
Many PDFs have cover pages, dividers and blank pages that produce no rows. Click "With Data Only" to auto-select only pages that contain actual tabular data.
If your "numbers" are really IDs (account numbers, ZIPs, etc.), turn off auto number detection so leading zeros and exact strings are preserved as text.
Encrypted PDFs can't be parsed. Open the PDF in your reader, save a copy without password, then convert that file here.
For unfamiliar PDFs, load the file, deselect everything but page 1, download and inspect — much faster than processing 200 pages then discovering your settings are wrong.
Always open the downloaded XLSX in Excel or Google Sheets before forwarding. Spot-check 2-3 rows against the source PDF to verify numbers and dates extracted correctly.
Most online PDF-to-Excel converters upload your file to a server, where your financial, medical or business data sits in someone else's storage. This one runs entirely in your browser.
Every step — parsing the PDF, extracting text items, reconstructing columns, detecting numbers and dates, building the XLSX workbook — runs in your browser's own JavaScript engine. No PDF content, no extracted rows, no XLSX bytes are ever transmitted over the network.
Everything you need to know about converting PDF tables to Excel — covering accuracy, file types, cell typing, privacy and tuning the detection.
YYYY-MM-DD, DD/MM/YYYY, Mon DD YYYY, etc. Matched values are parsed via JavaScript's Date constructor and written as Excel date cells with dd/mm/yyyy formatting.00123 becomes the number 123. To preserve leading zeros (account numbers, ZIPs), turn off number detection — all values stay as text strings.Key terms used in PDF-to-Excel conversion and on this page, explained simply.
Drop your PDF in the tool above, pick your pages, and get a real .xlsx workbook with proper numbers and dates in seconds — no signup, no upload, no limits.
📊 Open the Converter ↑