PDF to Excel

Client-Side PDF Table Coordinate Extraction and Spreadsheet Export

Copying financial statements, price lists, and transaction logs out of a PDF into a spreadsheet by hand frequently breaks column alignment and scrambles row values. PDF to Excel extracts selectable text streams from PDF pages directly inside your web browser and compiles them into Microsoft Excel (`.xlsx`) workbooks or comma-separated values (`.csv`) files without uploading documents to external servers.

To reconstruct tabular structure from unindexed PDF content streams, the engine inspects the 2D transformation matrix (`X` and `Y` point coordinates) of every text run on each page. Text items within a 4-point vertical `Y` tolerance are grouped into horizontal rows sorted from top to bottom, while distinct column anchors are identified across a 15-point horizontal `X` tolerance and binned (`colX - 10` to `nextColX - 10`) from left to right.

You can export multi-page PDFs with each page assigned to its own worksheet tab (`Page_1`, `Page_2`) or enable `Merge All Pages into Single Sheet` to stack all pages onto a single `Extracted_Data` worksheet separated by page marker rows. Before downloading `<filename>_tables.xlsx` or `<filename>_tables.csv`, the `Extracted Tabular Preview` panel displays the total row and sheet counts alongside a 10-row sample grid for every parsed page.

Core Tool Capabilities

• 2D Geometric Row and Column Clustering: Analyzes horizontal (`X`) and vertical (`Y`) glyph coordinates across each PDF page, grouping text runs within a 4-point vertical tolerance into rows and partitioning columns using a 15-point horizontal threshold. Multiple text fragments falling within the same column boundary are joined with spaces, and trailing empty cells are trimmed automatically.
• Excel (.xlsx) and UTF-8 CSV Export: Switch between `Excel (.xlsx)` to generate a standard OpenXML spreadsheet workbook or `CSV (.csv)` to export a UTF-8 comma-separated text file. Because CSV files represent a single flat table, CSV export serializes the first worksheet in the workbook. Enabling `Merge All Pages into Single Sheet` ensures multi-page PDFs export all pages into one CSV file.
• Per-Page Tabs or Unified Single-Sheet Merging: By default, each PDF page containing text is written to a dedicated worksheet tab named `Page_1`, `Page_2`, and so on. Checking `Merge All Pages into Single Sheet` concatenates all extracted page rows sequentially onto a single `Extracted_Data` sheet separated by a blank line and a `Page N` divider row.
• Extracted Tabular Preview Grid: Inspect extracted table structure directly in the workspace before downloading. The preview header reports total extracted rows and sheet count, and renders up to the first 10 rows per page (with a `+ N more rows included in full download` indicator for longer tables and `-` placeholders for empty cells).
• Exact Text Value Preservation: Writes extracted cell strings directly into worksheet arrays without altering leading zeros, account identifiers, currency symbols, or formatted date strings. If a PDF contains no selectable text on any page, the workbook outputs a single `Extracted_Data` sheet stating `No tabular text detected in PDF`.
• Built-In Sample Balance Sheet: Test the coordinate extraction pipeline immediately using the `Try Sample Document` button, which generates a two-page sample financial document in local memory. You can replace the active file or reset the workspace at any time.