SnapCommitBANK CSV & TABLE CLEANUP GUIDES
Clean pasted tables for Excel
To clean a copied financial table, keep the original, choose its column separator and number format, then review formatting changes before pasting into Excel. SnapCommit handles this workflow locally in your browser.
Start with the structure, then the numbers
A table that looks aligned in a report can become one long column when copied. Tabs, commas and runs of spaces are different separators. First check that each heading and value lands in the right column. Changing number formatting cannot fix a misplaced column.
- Copy the table as text. Include its headings if available. SnapCommit does not read a PDF file or an image; copy selectable text first.
- Paste it into the free workspace. Choose tabs, CSV, semicolons or two-or-more spaces if auto-detection gets the structure wrong.
- Choose the source number format:
1,234.56or1.234,56. Use the convention in the copied report. - Set how standalone dashes should be treated. Keep them unless you know they mean zero or an empty value.
- Clean the table and review blue changes and amber warnings. Compare totals and labels with the original.
- Copy into Excel or export CSV. Use matching number and column types when importing.
A small example
This example uses the 1,234.56 number format. Currency symbols are removed from recognized numbers; their currency units are not converted.
| Copied value | Cleaned value | Meaning |
|---|---|---|
| $24,850 | 24850 | Currency symbol and grouping separator removed |
| (8,320) | -8320 | Accounting parentheses become a negative sign |
| — | — | Missing-value marker kept by default |
What to review before using the output
Check repeated headings carefully. SnapCommit can remove blank rows and identical repeated header rows when the option is enabled. A subtotal row is still data. The tool does not decide whether a row belongs in your analysis or verify the arithmetic.
Review mixed currencies, percentages and codes separately. Stripping a dollar sign does not convert dollars to euros. A percentage keeps its percent notation. Leading-zero identifiers and long numbers receive text protection, rather than being treated as ordinary amounts.
When Excel already does the job
For a repeatable file-import workflow, Excel's Text/CSV import and Power Query may be a better fit. Microsoft describes choosing column types during import in its guide to leading zeros and large numbers. SnapCommit is a small option for pasted text you want to review before importing.
Try the workflow on a small table
The web trial accepts 15 data rows with no signup. The $29 USD one-time offline edition accepts up to 2,000 source rows, 40 columns and 500,000 characters. It includes the current downloadable HTML app, with no installation or internet connection needed after download.