On this page
Identify the table structure
Bordered tables provide visible cell boundaries, while borderless tables rely on spacing and alignment. Merged cells, multi-line headers and footnotes can make either type ambiguous.
If the PDF contains native text and vector lines, Extract Tables can use more structure than an image-only workflow. A scan must first infer both text and layout from pixels.
Prepare and extract a representative page
Correct rotation and perspective, retain enough resolution and crop unrelated page regions only when the tool supports a deliberate selection. Choose the correct OCR language.
Test a difficult page before processing a long file. Export to a structured format only after the preview shows sensible columns.
- Check decimal separators and negative values.
- Review merged and wrapped cells.
- Confirm header rows.
- Compare row counts with the source.
Validate data, not only appearance
Open the spreadsheet and compare totals, identifiers, dates and unit labels. A visually tidy table can still place a value in the wrong column.
Keep page or table provenance when the data supports audit, finance or operational decisions. Manual correction is often necessary for complex or low-quality scans.
Put the workflow into practice
Arrange source documents, select the pages you need, and create one PDF locally in your browser. Review the result before choosing any optional next step.
Try Extract Tables from PDFFrequently asked questions
Clear answers before you merge
Can OCR preserve every table cell?
No. Merged cells, weak alignment and poor scans can produce incorrect structure.
Should I use PDF to Excel or Extract Tables?
Use Extract Tables for targeted structured data; use PDF to Excel when broader spreadsheet conversion matches the document.
Do borderless tables work?
They can, but spacing-based structure is more ambiguous and requires careful review.
How should I validate numeric tables?
Compare totals, decimals, signs, dates and column placement against the source page.