PDF Table Extractor: How to Extract Tables from PDF to Excel and CSV

A PDF table extractor is a tool that finds tables inside a PDF file and converts them into an editable format such as Excel, CSV or JSON. Instead of retyping numbers from an invoice, report or bank statement, you extract the table and work with the data directly.

This guide explains why extracting tables from PDFs is harder than it looks, compares the main types of extractors, walks through the process step by step, and covers tips and fixes for the most common problems.

Why extracting tables from a PDF is hard

A PDF is built for display, not for data. It stores text and lines at fixed positions on the page, and it has no built-in idea of rows, columns or cells. An extractor has to guess where a table starts, where each column ends and which text belongs to which cell.

There are two main kinds of PDF:

Text-based PDFs contain real text. Extractors can read the characters and their positions directly, which usually gives good results.
Scanned PDFs are images of pages. They need optical character recognition (OCR) first, so accuracy depends on scan quality, fonts and layout.

Tables with merged cells, no visible borders, multi-line cells or tables that continue across pages are the hardest to extract accurately.

Types of PDF table extractors

Type	Best for	Strengths	Limits
Online PDF table extractors	Quick one-off files	No installation, easy to use	Check privacy before uploading sensitive files; file size limits may apply
Desktop PDF software	Regular office use	Export to Excel, often with OCR	Usually paid, and complex layouts may need manual fixing
Excel with Power Query (Get Data from PDF)	People who already work in Excel	Imports detected tables directly into a spreadsheet	Works best on clean, text-based PDFs
Code libraries (Tabula, Camelot, pdfplumber)	Developers and batch jobs	Scriptable, repeatable, control over settings	Needs programming skills and tuning for each layout
OCR tools	Scanned documents	Turn images into text and tables	Accuracy depends on scan quality

Features and pricing vary by tool and change over time, so check each tool's current documentation before choosing.

How to extract a table from a PDF step by step

Check the PDF type. Try selecting the text. If you can, it is text-based. If not, it is scanned and needs OCR.
Choose your tool. For one file, an online extractor or Excel may be enough. For many files, use a script or desktop software.
Select the pages or the table area. Limiting the area reduces errors from headers, footers and notes.
Run the extraction. Choose an output format such as Excel (.xlsx) or CSV.
Review the result. Compare the extracted table with the PDF, checking merged cells, numbers and column alignment.
Clean the data. Fix split cells, remove empty rows and set the correct number and date formats.
Save and reuse. Keep the settings or script if you will process similar files again.

Tips for accurate PDF table extraction

Start with the best source file. A text-based PDF exported from software is more reliable than a scan or a photo.
Improve scans before OCR. Straight, high-resolution, high-contrast pages give better results.
Extract page by page for tricky layouts. Tables that span pages often need to be joined afterwards.
Try both modes in code libraries. Libraries such as Camelot offer separate methods for tables with ruled lines and tables without them.
Validate totals. Add up a column in the extracted data and compare it with the total in the PDF.
Keep the original. Never overwrite the PDF. Work on the extracted copy.

Common problems and how to fix them

Columns merge into one. Adjust the column boundaries in the tool, or use a method designed for tables without borders.
Numbers import as text. Convert the column to a number format and remove stray spaces or symbols.
Rows split across lines. Merge multi-line cells manually or with a script after extraction.
Garbled characters or missing text. The PDF may use unusual fonts or be scanned. Try OCR with the correct language setting.
No table detected. Select the area manually, or try a different tool or mode.
Sensitive documents. For confidential files, prefer offline software or a tool whose privacy policy you have checked.

Frequently asked questions

What is a PDF table extractor? It is a tool that detects tables in a PDF and converts them into formats like Excel, CSV or JSON.

Can I extract a table from a scanned PDF? Yes, but the file needs OCR first. Accuracy depends on the scan quality and the layout.

What is the best format for extracted tables? Excel is convenient for editing and calculations. CSV is lighter and works well for importing into databases and scripts.

Is it safe to use an online PDF table extractor? For non-sensitive files it is usually fine. For confidential documents, check the privacy policy or use offline software.

Why does the extracted table look wrong? PDFs store positions, not real tables, so tools sometimes misjudge columns. Adjust the area, try another mode or clean the data afterwards.

Can I extract tables from many PDFs at once? Yes. Code libraries and some desktop software support batch processing.

Conclusion

A good PDF table extractor saves hours of manual typing. Check whether your PDF is text-based or scanned, pick a tool that fits the job, review the output against the original and clean the data before using it. For occasional files an online tool or Excel is usually enough, and for recurring jobs a script or desktop software is more reliable.