A Worksheet for Each Page
Each selected source page becomes a separate worksheet in the XLSX download, making page-by-page review easier.
PDF to Excel
Build an editable workbook from position-based text rows.
Choose PDF Files
Drop files here or use the button below.
Up to 100 MB total · Files stay on your device
Preview the document here. For added content, this is a placement guide; check the saved output.
Table of Content13 Sections
What Can You Recover from a PDF Table in Excel?
Build an editable workbook from PDF text arranged into rows and spacing-based columns. Each selected PDF page becomes a worksheet. This can help recover tabular text for careful cleanup and analysis.
The inference groups text fragments by vertical position and separates wide horizontal gaps into cells. It does not recognize arbitrary table semantics. Values are stored as text to preserve extracted content and avoid silently interpreting them as formulas.
PDF to Excel Features
Adjustable Column Inference
Change Column gap threshold to separate nearby values or keep a long description together.
Header and Footer Exclusion
Exclude top and bottom margins in PDF points to reduce repeated report furniture in extracted rows.
Text-Safe Cell Values
Values are stored as text. Leading zeros can remain visible, and PDF wording is not turned into executable formulas.
Why Move PDF Table Values into Excel?
A PDF statement or inventory may contain useful rows but offer no editable workbook. Extracting those rows can reduce manual retyping when you need a reconciliation sheet or a working data table. The export is a starting point for review: it infers alignment from printed positions, not from original spreadsheet definitions. Verify identifiers and amounts, assign numeric types deliberately and create any calculations yourself. Source formulas, charts, merged-cell meaning and workbook logic cannot be recovered simply because they once produced the PDF.
Who Uses PDF to Excel?
Banking Reconciliation Staff
Recover a permitted statement table for a controlled reconciliation worksheet. Verify transaction dates, debit and credit columns and totals against the PDF before calculating differences.
Warehouse Inventory Teams
Extract a stock list to prepare an editable count sheet. Keep part codes as text, check blank quantity cells and remove repeated page headers before adding count columns.
Research Assistants
Bring a published numeric table into a workbook for checked analysis. Compare decimal separators and units row by row, then document any manual corrections to inferred cells.
How Do You Convert PDF Tables to Excel?
- Choose a PDF with selectable table text. Start with one representative page rather than the full report.
- Set Pages, margin exclusions, Row alignment tolerance and Column gap threshold. Use small changes and compare the sample with the preview.
- Generate and download the XLSX, then open each worksheet in a compatible spreadsheet application.
- Verify columns and row counts, retain identifiers as text and assign number types only after checking values. Reconcile totals before using new formulas.
Choose the Source File
Select a PDF containing selectable table values.
Select the screenshot to enlarge it.
Review the Tool Settings
Choose sample pages and refine row, column and margin settings.
Select the screenshot to enlarge it.
Download and Check the Result
Download the XLSX and verify cells before calculating totals.
Select the screenshot to enlarge it.
Screenshots show this toolkit using harmless sample files. Your file name, page count and settings may differ.
A Wrapped Label Becomes an Extra Row
The last item label wraps onto a second line. The exported data keeps that continuation on its own row, so it needs review before use as a spreadsheet record.
Source: Three Items and a Total
The original table has three line items and a total of 65.00. One item label spans two lines.
Result: Actual Exported Cells
These cells were read from the downloaded file. The continuation of the last label is a separate row.
- Rows, including header
- 6
- Exported columns
- 4
- Total value
- 65.00
Settings used: Page 1; exclude 170 pt at the top and 340 pt at the bottom; row tolerance 3 pt; column gap 18 pt. CSV uses commas.
Position-based extraction does not rebuild merged records or formulas. In the Arabic sample, alignment also creates extra columns. Check each row against the PDF before calculating.
Checked on . Original harmless samples processed locally in Chromium with version 3.16.0; this is not a production hosting benchmark.
Settings and Output Checks
| Setting | What to expect |
|---|---|
| Accepted input | |
| Processing location | Your browser |
| File selection | One input file |
| Input size | 100 MB total; decoded images and pages also have pixel limits |
| Page selection | Up to 200 selected pages per job. Blank Pages means all pages only when the PDF has 200 pages or fewer; use separate ranges for a longer document. |
For scanned tables, add a reviewed OCR text layer first. Column inference then uses the recognized text positions, which can require more cleanup than a digitally created table.
Refine the Table Before Export
Start with one page that includes both short and long cell descriptions. After opening its worksheet, compare an early row, a wrapped description and the final total row with the PDF. If a page header became an extra row, exclude its top margin in PDF points; 72 points equal one inch. Increase Row alignment tolerance cautiously when a printed row splits vertically. Adjust Column gap threshold only after identifying which source boundaries should become cells. Repeat the sample export until the layout is usable, then include the remaining pages.
Separate Extracted Values from Spreadsheet Logic
A printed “Total” and its adjacent value do not become a SUM formula in the exported worksheet. After checking the relevant rows, convert amounts deliberately and write the calculation you actually need. Keep account codes, long identifiers and leading-zero values as text. Compare the newly calculated total with the source and investigate any difference before changing data. A PDF page with several unrelated tables may need to be split into separate reviewed tables manually.
Troubleshooting PDF to Excel
| Situation | What to do |
|---|---|
| Two columns became one | Lower the column-gap threshold and compare a sample row with the PDF. |
| A long description split into several cells | Increase the gap threshold. Mixed-width or multi-line tables may still need manual cleanup. |
| A total does not calculate in Excel | The source PDF has values, not reusable formulas. Convert verified numeric cells deliberately and recreate formulas if required. |
A Practical Example and Final Checks
For an invoice table, compare item descriptions, quantities, unit prices, leading-zero codes and totals row by row. Verify where blank cells occur. A workbook that opens successfully can still have a value in the wrong column; that is why table checking is part of the conversion task.
FAQs
Are Numbers and Dates Automatically Typed?
Extracted cells are written as text. Review them and apply explicit numeric or date types in the spreadsheet application.
Why Do Some Rows Have Different Column Counts?
PDF spacing does not always define real table columns. Merged headings, proportional text and irregular alignment require manual cleanup.
How Should I Check Imported Spreadsheet Data?
Compare row counts and important cells with the PDF. Treat identifiers as text, choose number types explicitly and reconcile totals before performing calculations.
Can the Converter Recover Formulas or Merge Tables Across Pages?
No. It creates a worksheet for each selected page using position-based text cells. Recreate checked formulas and combine tables deliberately after aligning their headers. Original spreadsheet formulas and merged-cell meaning are not stored in ordinary printed PDF text.
Why Does a Scanned Table Produce No Editable Cells?
A scan can contain only an image of the table. Add a checked OCR text layer first, then export a representative page. Recognition can introduce wrong digits or irregular spacing, so compare the recovered cells with the scan before calculating.
Related Tools and Guides
Continue with PDF to CSV, Excel to PDF, OCR PDF.