How to extract tabular data from a document with the Table Snip

With the Table Snip, you can easily extract tabular data from PDF's to Excel.

 

About Table Snip

With the ‘Table Snip’, you can easily extract tabular data from PDFs into Excel. Multi-page table extraction allows you to analyze large PDF reports.

 

Choose your DataSnipper version to learn more about Table Snip:

👉 DataSnipper version 4.0

👉 DataSnipper version 4.1 and later
Or
👉 Visit most FAQs on the Table Snip

DataSnipper version 4.0

Video Tutorial 

Table Snip

  1. Press the Table Snip button on the DataSnipper ribbon.
  2. Draw a rectangle around the table you want to extract.
  3. After placing the Table Snip, you can adjust the table by stretching the edges.
  4. You can add columns by using the plus button or remove a column with the minus button.
  5. By clicking on options, you can edit rows. You can add rows by using the plus button or remove a row with the minus button.

💡 When you have large tables spanning over multiple pages, you can repeat the table snip for other pages by clicking on the options button. 

DataSnipper version 4.1 and later 

What's new in version 4.1?

In version 4.1, DataSnipper automatically provides suggestions to Table Snip when it detects tables in the documents. No need to drag and draw rectangles to snip tables. With a single click of a button, the tables are extracted into your Excel workbook.

Video Tutorial 


Auto Table Snip 

  1. Press the Table Snip button on the DataSnipper ribbon.
  2. Using the Document Viewer on the right-side, identify a table in your documents.
  3. You will see a blue rectangle around the table as a suggestion.
  4. Click on "Snip Table" and the table will be extracted into your Excel workbook.
    auto table snip
  5. After the placement of the Table Snip, you can adjust the table by stretching the edges.
  6. You can add columns by using the plus button or remove a column with the minus button.
  7. By clicking on options, you can edit rows. You can add rows by using the plus button or remove a row with the minus button.

💡 When you have large tables spanning over multiple pages, DataSnipper automatically detects it and repeats the table snip for other pages.

FAQs

  1. Can Table Snip be used in the text which is in a paragraph format? If yes, can the tool help us in changing the structure of the paragraphs (eg splitting or merging them)?
    Yes, you can use Table Snip in this case and you can edit the rows in order to change the structure of the paragraphs accordingly (eg add rows in order to split paragraphs or remove rows in order to merge them).

    If using this method, it is important to avoid having any column breaks in your Table Snip - these can be removed with the minus button at the bottom of the Table Snip.
  2. If there is no header on a table I want to snip, will Table Snip still work?
    You don't need a header to be able to snip the information that is in tabular format. DataSnipper will still recognize the table and you should be able to snip it using the Table Snip.

    Additionally, in Version 4.1, the “Table Snip Suggestions” feature doesn’t take out table headings by default, therefore you should always snip headers of tables using a manual table snip once.