How to extract a table from a PDF to Excel
By SumitPublished 16 Oct 20261 min readWorkflows
Short answer
If you cannot select text, run OCR PDF first. Then open PDF to Excel and export. Treat the sheet as a draft — merged cells and multi-column layouts often need cleanup.
People search “PDF table to Excel” expecting a perfect spreadsheet. Real PDFs vary: some are text tables, some are scans, some are designed pages that only look like grids.
The honest path is: ensure a text layer, export best-effort rows, then verify every important number.
Step by step
- 1
Try selecting text in the PDF. If nothing selects, run OCR PDF.
- 2
Open PDF to Excel, convert, and download the .xlsx.
- 3
Check column alignment and totals against the original page.
- 4
For one-way presentation of a sheet, use Excel to PDF after you clean the data.
What works well
Simple single-table pages with clear rows export cleanly. Invoice-style multi-block layouts often need manual fixes.
What fails
Merged cells, rotated text, and tables drawn as lines without a text layer. OCR helps scans but does not invent structure.
Limits worth knowing
- Not an AI invoice product — verify financial figures.
- Complex layouts may misalign columns.
Tools used in this guide
- PDF to ExcelExport PDF text into a .xlsx spreadsheet locally. Best-effort rows from text layout.
- OCR PDFMake scanned pages searchable with local browser OCR (Tesseract). English, Hindi, Spanish, German, or French — language packs download on first use.
- Extract textPull all text out of the PDF. Copy or download as plain text.
- Excel to PDFConvert .xlsx to PDF from a live sheet preview. Processed in your browser — file never uploaded.
- Search PDFFind every occurrence of a word or phrase across the document.
Frequently asked questions
Can I convert a scanned table to Excel?
Yes, after OCR. Accuracy depends on image quality — proofread every cell that matters.Does PDF to Excel upload my file?
No. Export runs in your browser.
Related guides
More in workflows- Compress a PDF for emailGet under the attachment limit and keep small text readable, and know when to split instead.
- Make a scanned PDF searchableWhen you need OCR, how to pick the language, and how to check what it recognised.
- PDFs for government formsFrom phone photo to a PDF that passes the portal’s size limit, plus what you can and can’t hide.
- Visa application documentsUnlock bank statements, merge by category and get each file under the upload limit.
- Scanned PDF to WordWhy a scan converts to an empty .docx, and the OCR step that fixes it.
- Compress without losing qualityKeep selectable text when you can, and only rasterize when scans force the issue.