Two different ways a value can change
The code 00123 can become 123 when Excel interprets it as a number. A long identifier such as 12345678901234567890 can lose digits because Excel numeric cells support 15 significant digits. Widening the column changes the display, not the stored value. These are separate problems and both matter when a product code or tracking reference must match another system exactly.
Try the synthetic example
Our example contains two product codes with leading zeros, two long identifiers, prices with trailing zeros and formula-like text. Choose Codes & long numbers in CSV Safe Open. The report identifies the relevant cells; the original values remain visible in the preview. Download the original sample too if you want to compare how your own spreadsheet import settings behave.
Protect values before opening
- Start with the CSV exported from the source system, before any spreadsheet edits.
- Review the delimiter and the table preview. The header is treated as row 1.
- Download the protected XLSX. Every cell, including prices and dates, is stored as text.
- Open that workbook in Excel. Compare a code with leading zeros and the final digits of a long identifier against the CSV source.
The tool reads its generated workbook back and compares every cell with the parsed CSV before offering a download. This checks the exported data; it does not guarantee that a later edit or another importer will preserve it.
When you need arithmetic
A text-only workbook prioritizes exact values. Excel may show a green triangle for a number stored as text, and some numeric operations will need an explicit conversion. After protecting your identifiers, convert only the columns that truly represent quantities or amounts. Leave postal codes, account references and product codes as text.
What cannot be recovered
If you already saved a rounded identifier over the only copy of your CSV, the missing digits cannot be inferred reliably. Re-export from the original system or restore a backup. Adding zeros to a damaged number is not recovery.
Microsoft documents leading-zero removal, 15-digit precision and importing columns as text. Excel versions with Automatic Data Conversions settings offer another route; an explicitly typed workbook is useful when you need to send a protected copy to someone else.