PDF to Excel
PDF to Excel
Extract tables and data from PDF into Excel spreadsheets
- Runs in your browser
- Nothing uploaded
- No sign-up
- Free, no daily limits
- 1Add your file
- 2Choose settings
- 3Download
100% Private: All processing happens in your browser. Your files never leave your device.
Last updated
Extracting tables from a digital PDF into a Microsoft Excel (.xlsx) spreadsheet runs entirely within your browser tab. Instead of guessing column boundaries for each row in isolation, our layout engine clusters horizontal text coordinates across all lines on a page. This establishes consistent column anchors across the document: empty cells remain legitimately blank rather than pulling subsequent numbers into incorrect adjacent columns.
Cell values are typed intelligently during export. Currency amounts, percentages, and numeric quantities are saved as real numeric cells rather than text strings, allowing formulas like SUM and AVERAGE to work immediately without manual formatting. Account numbers, tracking IDs, and leading-zero strings are preserved as text to prevent Excel from truncating or altering sensitive codes.
To compare output structures, selectable text capabilities, and upload caps across our document converters, visit our document conversion fidelity matrix.
How it works
1. Upload your PDF document
Select or drop your text-based PDF file into the upload area, up to 100 MB. Processing executes locally without uploading bytes to remote cloud infrastructure.
2. Configure numeric typing preferences
Keep the typed numbers option enabled to format monetary values and percentages as real Excel numbers. Disable it only if you prefer every entry preserved as raw plain text.
3. Run table extraction
Click Convert to Excel. The tool inspects text streams, groups lines into baseline rows, maps cell text to nearest column anchors, and builds worksheet objects for each page.
4. Download the Excel spreadsheet
Review the on-screen table preview to check row counts and column alignment, then click Download Excel (.xlsx) to save your spreadsheet.
When you'd use it
Extracting transaction rows from bank statements
Bank and credit card statements feature repeating date, description, withdrawal, and deposit columns. Page-wide column clustering extracts multi-page statement records into a clean spreadsheet for personal budgeting.
Auditing figures from vendor PDF invoices
Converting supplier invoices and itemized billing sheets to Excel allows accounting teams to insert SUM formulas beneath quantity and total columns to verify billing calculations.
Importing examination marksheets and scorecards
Academic grade sheets and admission lists published in PDF format can be converted into Excel to calculate grade point averages, sort candidate ranks, or filter qualification cutoffs.
Organizing vendor price sheets and rate cards
Wholesale product catalogs and contractor rate lists distributed as PDF documents convert into structured spreadsheets that can be filtered, sorted, or merged into procurement models.
How does the layout engine detect spreadsheet columns?
In PDF format, tables do not exist as structured grids: they are collections of independent text strings positioned at Cartesian X and Y coordinates. The extractor reads positioned text items through pdf.js, calculates baseline coordinates, and groups items into visual rows.
To establish column boundaries, the engine clusters horizontal start coordinates across all rows on the page to define global column anchors. Individual text runs are mapped to the nearest column index. If a row lacks an entry for a specific column, a blank cell is placed there, preserving field alignment across all subsequent data rows.
What breaks column alignment: merged cells and rotated text
While standard tables extract with high precision, two document layout patterns disrupt geometric clustering: complex merged cells and rotated vertical text.
When a header cell spans multiple columns, its single horizontal coordinate maps to only one anchor, leaving neighboring columns empty rather than creating a true merged cell. Similarly, vertical text headers oriented at 90 degrees break horizontal line grouping, scattering words into separate spurious rows. In such cases, checking the preview table helps identify rows that need quick adjustment.
Measured benchmark results: mock report table test
In our test run, we converted a 2-page mock operational report (sample-report.pdf, 2,499 bytes) containing an audit table with department targets and actual performance metrics. The converter generated a 16,189-byte Excel workbook (output-pdf-to-excel.xlsx).
Inspecting the resulting sheet confirmed that percentage values (85.0% and 91.4%) were saved as typed numeric entries (0.85 and 0.914), enabling immediate arithmetic calculations. Testing a 921-byte scanned document (sample-scanned.pdf) produced 0 text characters, prompting the user with the real error message to run PDF OCR first.
Frequently asked questions
Why do formulas like SUM return zero on my converted sheet?
This happens when numbers are stored as text strings instead of numeric values. With our typed numbers setting enabled, currency and decimal amounts are written as true Excel numbers, allowing SUM, AVERAGE, and pivot tables to calculate properly.
Can I convert scanned receipts or statements to Excel?
Yes. When you upload a scanned statement or receipt, TryDocsy detects pages lacking selectable text and offers built-in OCR. It reads word positions and numbers, clustering them into properly aligned Excel rows and columns.
What happens to multi-page PDF documents?
Each page in the PDF document is processed independently and placed into its own worksheet tab inside the resulting Excel workbook, preventing data from different pages from colliding.
Are merged table headers preserved exactly?
Spanning header rows map their text to the nearest single column anchor. Multi-column merged spans may require a quick merge-and-center adjustment in Excel after downloading.
What is the maximum file size for PDF to Excel?
The tool accepts PDF documents up to 100 MB. Large multi-page statements are processed sequentially in browser memory without sending data to external servers.
Are account numbers with leading zeros preserved?
Yes. Strings containing alphanumeric codes, hyphens, or long sequences of digits like bank account numbers are preserved as text to prevent Excel from dropping leading zeros.