Review extracted PDF rows before using them in Excel
A report has Item and Quantity columns that must become spreadsheet rows.
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.
The document and the intended outcome
A report has Item and Quantity columns that must become spreadsheet rows. Extract XLSX, compare a small sample against the source and correct column alignment before calculations.
Make this example work for your file
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.
Choose only the settings this case needs
Check headers, numeric columns, minus signs, decimal separators and wrapped descriptions. Validate totals using the source rather than assuming the extracted cells are authoritative.
When the example needs a different approach
Run OCR first and review recognized characters. Even correct OCR words do not guarantee correct spreadsheet columns.
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.