Table extraction from PDFs and images: how it works and which method to use

Table extraction is the process of finding a table in a PDF, scan or image, working out its rows, columns and cells, and returning the contents as structured data such as CSV, Excel or JSON. It runs in two stages, table detection and table structure recognition, with OCR first when the page is an image. This guide covers how it works, the methods, the free tools, and how to test and check the output.

What is table extraction?#

Invoices, bank statements, rent rolls and claim forms keep their most useful data in tables: line items, transactions, units, charges. A PDF only stores instructions such as "put this text here, draw this line there"; it has no idea what a row or a cell is. Table extraction rebuilds that structure, so tabular data locked in a PDF comes out as rows and columns with each value in the right cell.

Table detection finds where each table sits on the page. Table structure recognition then finds the rows, columns and cells inside it, including headers and merged cells. What you start from changes the first step:

• Native PDFs

  Made by software, with a text layer, so tools read the characters and their positions directly.

• Scanned PDFs

  A picture of a page with no text layer. OCR reads the characters first, and its errors carry into the table.

• Images and photos

  Screenshots, phone photos and faxes: a scan, plus skew, shadows and uneven light to correct.

How table extraction works#

Whatever the method, the pipeline is the same: get the text, find the table, rebuild its grid, then clean and check the result.

Tools differ most in the last two stages: dropping subtotals and repeated headers, joining tables across pages, mapping columns to your fields and checking totals.

Why tables are hard to extract#

Five things break simple extractors:

• Merged cells and nested headers

  A header that spans sub-columns, or a small table inside a cell, throws simple parsers off by a column or more.

• Tables that span pages

  Page-by-page tools cut the rows on page 2 off from the header on page 1.

• Borderless layouts

  Spacing replaces ruling lines, so tight columns run together.

• Scan quality

  Blur, skew, rotated pages and low resolution cause OCR misreads that every later step inherits.

• A different layout from every sender

  One vendor's invoice has 5 columns, the next has 8, and templates break as senders multiply.

Table extraction techniques#

There are four broad ways to do it, each built on the limits of the last:

• Rules and templates

  Ruling lines, spacing and header words such as Qty and Amount mark out the table; every new layout needs new rules.

• Machine learning

  A classifier learns which regions are tables from features an engineer designs, such as edges, text density and alignment.

• Deep learning

  Networks learn the features themselves: CascadeTabNet (2020) finds tables and their cells in one model, and Microsoft's Table Transformer learned from nearly one million tables in scientific articles.

• LLMs and vision-language models

  They read a table in context and can infer a missing header, but cost more and can return values that aren't on the page.

In production they're often combined, with confidence scores and validation rules deciding which cells a person checks.

How to extract a table from a PDF#

For a one-off, Excel's Data > Get Data > From File > From PDF lists the tables in a PDF that has a text layer. In code, free Python libraries read that text layer well; scanned PDFs need OCR first, except where noted.

With a library, you build the multi-page joining, header mapping, validation and review yourself. For a worked pdfplumber example, see how to extract data from PDF.

How to extract a table from an image#

A photo or screenshot has no text layer, so OCR comes first. Pick the route that fits how often you do it:

1. One table, nowExcel's Data > From Picture turns an image or a screenshot into cells and asks you to review them before inserting: that's where to catch misreads.
2. A script you controlThe Python library img2table finds tables in images and PDFs, borderless ones included, with an OCR engine such as Tesseract, PaddleOCR or EasyOCR.
3. Many images, every dayA document AI platform corrects skew, reads the table, scores each cell and sends the uncertain ones to a person.

Whatever the route, straighten the image, crop to the table and use the highest resolution you have.

How to validate extracted table data#

Extraction is half the job; validation is what makes the data safe to use.

• Rows add up to the totalLine items that sum to 10,050 against an extracted total of 10,500 send the record to review before it reaches the ERP.
• Balances reconcileOn a bank statement, the opening balance plus credits minus debits equals the closing balance.
• Documents agreeInvoice lines match the purchase order; rent roll totals match the operating statement.
• Every page is therePage counts and running totals confirm that a multi-page table isn't missing rows.
• Uncertain cells go to a personHigh-confidence rows go through; the rest go to review.

How to choose table extraction software#

Before you commit, test the tool on your own files:

1. Use your worst filesMerged headers, borderless tables, tables across three or more pages, rotated pages and poor scans. Clean samples make every tool look good.
2. Score cells, not documentsCount right values and missed cells: a tool can find every table and still drop rows.
3. Score the structureA right value in the wrong column is still wrong. The TEDS score compares the extracted table's structure and content with the original.
4. Count rows on long tablesExtra rows mean repeated headers were kept; missing rows mean a page wasn't joined.
5. Count the fixesHow many cells a person had to correct is the number that matters in production. More in how to measure OCR accuracy.

How Docsumo extracts tables#

Docsumo's Document AI extracts every line item and transaction row from documents such as invoices and bank statements, scans and handwritten text included. Tables that run across pages are joined into one table, with the headers mapped, and values the model is unsure about go to a reviewer, who can click each one to see its source line on the page. The rows reach your systems through the API and webhooks or an Excel export. It's built for business documents at volume, so for a single table from a research paper, a free library or Excel will do.

Play video: Extracting complex tables with Docsumo's AI Table Assist

• 99%99%field-level accuracy across 250+ document types
• 95%+95%+of documents processed straight through, without manual review

The bottom line#

Table extraction is detection plus structure recognition, with OCR first for scans and images. Free libraries handle native PDFs you control; at volume, confidence scores, validation and review make the output safe to post. Test on your messiest documents before you choose.

Book a demo with a few of your own documents, or start a free trial.

Frequently asked questions#