A table snip copies a table from a document into a block of cells in Excel, with each cell linked to its place on the page. Use it for bank statements, ledgers, aged balances and any list of rows and columns.
Snip a table
- Click the cell in Excel where the top-left corner of the table should go.
- Open the document in the viewer.
- Choose Table Snip on the ribbon, or press Ctrl+M (Cmd+M on Mac).
- Drag a frame around the table, header included.
Blast Audit detects the rows and columns, draws them as dividers on the document and writes the table into Excel.
Adjust rows and columns
| To | Do this |
|---|---|
| Add a column | Click the dashed strip above the table where the boundary is missing. |
| Add a row | Click Edit rows in the snip's toolbar, then click the dashed strip on the left. |
| Move a divider | Drag it. |
| Remove a divider | Double-click it. |
| Start again from automatic detection | Click the reset button (↺) in the toolbar. |
Tables over several pages
- Snip the table on the first page and check it.
- Click the repeat button in the snip's toolbar (Repeat table snip for other pages).
- Confirm Duplicate table to the next pages?.
Blast Audit applies the same frame to the following pages and writes each page's rows in Excel. Check the pages where the layout moves.
Detected tables
With Auto table suggestions on, the viewer highlights the tables it finds on the page. Click one (Click to extract table) to snip it without drawing a frame. Turn suggestions on or off with Auto Table Suggestion on the ribbon or in the viewer's ⋯ menu.
What Excel receives
- Dates keep the day and month you see on the page: 9 Jan stays 9 January.
- Words stay in the order you read them, including text that wraps inside a cell.
- If the destination cells already have a currency or percent format, Blast Audit keeps it.
Table snips cannot write into a protected sheet. Remove the protection with Review > Unprotect Sheet first.