Use the Table Snip in DataSnipper Excel Online to extract tabular data from source documents into your workbook. Multi-page table extraction lets you handle large reports with extensive tabular data.
Prerequisites
Microsoft Excel Online
Microsoft email account
User-level Licensing enabled in Admin panel
How-to video
What the video covers: pressing the Table Snip button, drawing a rectangle around the target table, adjusting columns and rows using the plus and minus buttons, and using the multi-page feature to extend the same snip across multiple pages.
Step-by-step guide
Press the Table Snip button on the DataSnipper ribbon.
Draw a rectangle around the table you want to extract.
After placing the Table Snip, adjust the table by stretching the edges on the Document Viewer.
Add columns with the plus button or remove a column with the minus button.
Click "Options" to edit rows. Add rows with the plus button or remove a row with the minus button.
Table Snip across multiple pages
For large PDF reports where a table spans multiple pages, you can create table snips across all relevant pages in one step.
Draw a rectangle around the data (excluding headers) to create your first Table Snip.
Click "..." and choose which additional pages should receive table snips at the same position.