PDF to spreadsheet: common problems and how to fix them
Resolve a number lands in the wrong column and a scan produces no useful rows. Understand the limits before retrying.
Open PDF to spreadsheet →Follow these steps
- Choose the supported source file or files from your device.
- Use a PDF with selectable text rows; run OCR first for scans.
- Export the XLSX and check every column and numeric value.
A number lands in the wrong column
Inspect spacing and wrapped lines in the original. Realign the rows manually or use a source spreadsheet if one is available.
A scan produces no useful rows
Run OCR first and review recognized characters. Even correct OCR words do not guarantee correct spreadsheet columns.
Check whether this is the right operation
The extraction is heuristic text grouping. It does not recover the original spreadsheet, formulas, merged cells or table semantics from a PDF.
A more useful retry
For a review spreadsheet, compare totals and decimal values with the original page. Do not apply formulas to extracted numbers until you have checked column alignment, separators and missing cells.
A checked example you can try
Output package contains its document content part.
Settings used in this engine check
- quality
- compact
- angle
- 90
- margin
- 20
- start
- 1
- columns
- 2
Check the result
Extraction uses heuristics. It does not guarantee original tables, formulas or column alignment.
Keep the original. When this task produces a file, reopen the download in the application where you will use it and inspect the affected pages. An illustration explains the operation; it is not a recorded processing test.
Practical tips
- Check headers, numeric columns, minus signs, decimal separators and wrapped descriptions. Validate totals using the source rather than assuming the extracted cells are authoritative.
- Inspect spacing and wrapped lines in the original. Realign the rows manually or use a source spreadsheet if one is available.
- Run OCR first and review recognized characters. Even correct OCR words do not guarantee correct spreadsheet columns.
Questions
A number lands in the wrong column?
Inspect spacing and wrapped lines in the original. Realign the rows manually or use a source spreadsheet if one is available.
A scan produces no useful rows?
Run OCR first and review recognized characters. Even correct OCR words do not guarantee correct spreadsheet columns.
What is this tool useful for?
Move simple text rows into a spreadsheet.
What should I check in the result?
Extraction uses heuristics. It does not guarantee original tables, formulas or column alignment.