Skip to main content

How to extract tabular data with the Table Snip

Use the Table Snip to extract tabular data from PDFs into Excel, including multi-page tables.

With the Table Snip you extract tabular data from PDFs into Excel. Multi-page table detection lets you process large PDF reports in a single Snip.

Video walkthrough

Watch this short video for an overview of Auto Table Snip in action.

What the video covers

The video demonstrates DataSnipper detecting a table inside an imported PDF, the blue suggestion rectangle that appears around it, and a single click to extract the table into the active Excel cell. It also shows adjusting columns and rows after extraction.

Using Table Snip (v6+)

When DataSnipper detects tables in your imported documents, it surfaces a banner in the Document Viewer that lets you snip every detected table across all pages in one click, regardless of whether each table has the same layout.

Step-by-step

  1. Import a PDF containing tables into your DataSnipper workbook.

  2. Open the Document Viewer. A banner labelled Snip all tables appears if tables are detected.

  3. Click Snip all tables to extract every detected table into your workbook. You can also restrict extraction to a page range.

  4. For manual control, press the Table Snip button on the DataSnipper ribbon and draw a rectangle around the table you want.

  5. After the table lands in Excel, drag column or row edges to adjust without having to delete and reapply.

Animated demonstration of Auto Table Snip detecting and extracting a table

Multi-page tables

Large tables spanning multiple pages are detected automatically. You no longer need to repeat the Table Snip for each page. If you only want a subset, use the page-range option when clicking Snip all tables.

Editing after extraction

  • Add columns with the plus button at the top of the snip; remove with the minus button.

  • Add or remove rows by clicking Options on the snip.

  • In v6+ you can drag column and row boundaries directly to the desired position.

Did this answer your question?