Extract table data from PDF: to Excel, CSV or spreadsheet

2 min read·25 July 2026

Getting table data out of a PDF is a common challenge. Learn which methods work, when OCR is needed and how to get the data into Excel.

Method 1: convert PDF to text

The simplest method for PDFs with real text (not scans): use the PDF to Text tool on PDFrust. Table data is extracted as plain text. Paste the text into Excel (Paste → Import text). Use "Text to Columns" (Data → Text to Columns → Delimited by spaces or tabs). Check the column layout and adjust where needed.

Method 2: OCR for scanned tables

Is your PDF a scan? Then it contains images, not text. Use the OCR tool on PDFrust to make text recognizable. After OCR you can export the PDF to text and import into Excel. Note: OCR accuracy for tables depends heavily on scan quality and table complexity.

PDF to text

Try for free — no account needed

Try it now →

Method 3: copy from PDF viewer

In Adobe Acrobat Reader you can use the "Copy table" option: right-click a table cell → Copy as spreadsheet. This works better than plain text copy. Paste directly into Excel. This feature only works in paid Acrobat versions, not the free Reader.

Helper tools for complex tables

For complex multi-page tables or poorly structured PDFs, specialized tools work better: Tabula (free, open-source desktop app) is excellent for PDF table extraction and outputs CSV. Camelot (Python library) is ideal for automation. Adobe Acrobat Export PDF (paid) has the best accuracy for commercial use.

Manual correction after extraction

No automatic method is 100% error-free for all tables. Always plan a correction step. Most common errors: numbers with periods/commas interpreted as dates, column groups merged together, empty cells skipped, and currency symbols truncated.