Skip to main content

How to extract tables from multiple pages

Use the Table Snip to extract tabular data from documents with multiple tables across pages, snip all detected tables at once, and edit rows and columns.

With the Table Snip you can extract tabular data from documents that contain multiple tables across pages, even when the tables share a similar structure. This article covers DataSnipper v6.0 or later.

Video walkthrough

What the video covers

The video shows DataSnipper detecting tables across a multi-page document, the Snip all tables banner in the Document Viewer, extracting every detected table into Excel in one click, and adjusting the resulting columns and rows by dragging them.

Snip all tables at once

When DataSnipper detects tables in your imported documents, a banner appears in the Document Viewer suggesting Snip all tables. You can extract every detected table across all pages in one click, regardless of whether the tables share the same layout.

The Snip all tables banner in the Document Viewer

Snipping all detected tables across pages in one click

Select a page range

You can choose which pages tables are extracted from by providing a page range when you snip all tables.

Selecting a page range when snipping all tables

Editing tables after extraction

You can edit a Table Snip by dragging the columns and rows to the position you want, without having to delete and reapply. Large tables spanning multiple pages are detected automatically, so you no longer need to repeat the Table Snip for each page.

Editing a Table Snip by dragging columns and rows

Auto Table Snip (v4.1 and later)

In v4.1 and later, DataSnipper suggests a Table Snip automatically when it detects a table in the Document Viewer, so you do not need to draw a rectangle. Click the suggested table and it is extracted into your Excel workbook in one click.

What the video covers: a walkthrough of the Auto Table Snip suggestion. It shows DataSnipper detecting a table in the Document Viewer, the blue suggestion rectangle around it, snipping the table into Excel in one click, and adjusting the columns and rows afterwards.

Auto Table Snip suggestion being snipped into Excel
Did this answer your question?