CSV data quality
Why CSV Files Change Long Numbers—and How to Preserve Every Digit
A CSV stores text fields, but the spreadsheet or analytics tool opening it may infer a long digit string as a number. It can then display scientific notation, round significant digits, or save the rounded value back to the file. Scientific notation alone may be only a display format; changed digits are data loss. Preserve the untouched source, import identifier columns as text, compare values character for character, and export a new copy. If digits have already changed, recover them from the original system or another authoritative source—not by guessing.
Short answer
A CSV stores text fields, but the spreadsheet or analytics tool opening it may infer a long digit string as a number. It can then display scientific notation, round significant digits, or save the rounded value back to the file. Scientific notation alone may be only a display format; changed digits are data loss. Preserve the untouched source, import identifier columns as text, compare values character for character, and export a new copy. If digits have already changed, recover them from the original system or another authoritative source—not by guessing.
Upload
Bring the CSV you already use.
Understand
Start with the brief and evidence.
Act
Ask, edit, filter, and export.
A practical starting point
A CSV stores text fields, but the spreadsheet or analytics tool opening it may infer a long digit string as a number. It can then display scientific notation, round significant digits, or save the rounded value back to the file. Scientific notation alone may be only a display format; changed digits are data loss. Preserve the untouched source, import identifier columns as text, compare values character for character, and export a new copy. If digits have already changed, recover them from the original system or another authoritative source—not by guessing.
Concrete examples
Example 1: Scientific notation is only the display
A shipment reference 123456789012345678 appears as 1.23457E+17 in a narrow spreadsheet cell. The analyst checks the formula bar and the raw CSV before editing. If the original digits remain intact, importing the column as text corrects the presentation without reconstructing data.
Example 2: Saving the file makes the loss permanent in that copy
A spreadsheet interprets a long order ID as numeric, changes its trailing digits, and the user saves the file. The saved CSV now contains the altered value. Formatting the cell as text afterward does not restore the original; the team retrieves the ID from the untouched export.
Example 3: Rounding creates false duplicates
Two customer references differ only in their final digits. Numeric conversion makes both appear as the same rounded value, so a deduplication step collapses two legitimate customers. The team restores the source IDs, imports them as text, and reruns the duplicate review.
Example 4: An ID breaks a dashboard lookup
A sales CSV contains a digit-only product code that was rounded, while the product catalogue preserves the exact text. Revenue totals still add up, but category lookups fail and the dashboard labels the product as unknown. Character-for-character validation reveals the changed code before the report is shared.
Examples are illustrative and are not customer results.
Common questions
What is the safest way to work with this CSV problem?
A CSV stores text fields, but the spreadsheet or analytics tool opening it may infer a long digit string as a number. It can then display scientific notation, round significant digits, or save the rounded value back to the file. Scientific notation alone may be only a display format; changed digits are data loss. Preserve the untouched source, import identifier columns as text, compare values character for character, and export a new copy. If digits have already changed, recover them from the original system or another authoritative source—not by guessing.
Keep exploring
See what your own CSV is saying.
Try the browser workspace with a real file and keep the public guide open when you need help.
Start free