SnapCommitBANK CSV & TABLE CLEANUP GUIDES
Keep leading zeros and long IDs when pasting into Excel
Treat identifiers as text before importing or pasting them. A code such as 00123 is not the same identifier as 123, even though both look numeric.
Decide which columns contain amounts and which contain IDs
Amounts are usually meant for arithmetic. Account codes, product codes, postal codes and reference numbers usually are not. A table can contain both. Decide which columns are identifiers before applying a numeric transformation to the whole range.
Microsoft documents that Excel can remove leading zeros and limit numeric precision to 15 digits. Its guide to preserving leading zeros and large numbers describes text import and automatic conversion settings. Options vary by Excel version.
What SnapCommit does
SnapCommit flags leading-zero numbers and long numeric strings for text handling. It also protects text that resembles a spreadsheet formula. During copy or CSV export, protected text gets a leading apostrophe.
| Source | Exported text | Reason to review |
|---|---|---|
| 00123 | '00123 | Preserve the leading zeros |
| 12345678901234567 | '12345678901234567 | Preserve a long identifier as text |
| =1+1 | '=1+1 | Keep formula-like text literal |
The apostrophe may remain visible depending on the spreadsheet and import settings. Review a small sample first. The tool cannot force every spreadsheet's CSV importer to handle text in the same way.
A careful import workflow
- Keep the untouched source and identify the ID columns.
- Clean the pasted table and inspect the warnings for those columns.
- Download CSV if the table contains multiline cells or needs explicit import settings.
- In Excel's Text/CSV import workflow, set identifier columns to Text before loading. Check the preview.
- Compare an ID with leading zeros and a long ID character by character against the source.
- Only then reuse the table in your workbook.
What cleanup cannot repair
If Excel or another tool already removed digits before you copied the table, SnapCommit does not know the missing characters. It cannot reconstruct an original identifier from a rounded or truncated value. Return to the original source when that happens.
A custom number display format can make a value look padded with zeros, but display formatting is different from storing the original identifier as text. Choose the method that preserves the actual code you need to export or match.
Start with the free trial
Try a public or anonymized sample of up to 15 data rows. Table processing stays in your browser. For larger pasted tables, the current offline edition costs $29 USD once plus applicable tax and handles up to 2,000 source rows.