FREE WEB TOOL

Check CSV Damage from Excel Dates, Zeros, and Scientific Notation

Find lost leading zeros, date coercion, scientific notation, and other Excel changes.

Check CSV

＋Choose a CSV file

Files are processed in your browser and are not sent to our server.

How to use it

After editing CSV in Excel, scan for visible signs that identifiers or date-like values may have been reinterpreted: scientific notation, date-looking strings, 16+ digit integers, and leading-zero values. The checker reviews up to the first 1,000 data rows.

Choose the CSV saved after the Excel edit.
Compare flagged rows/columns with the original file for scientific notation, dates, long integers, and leading-zero values.
If information was changed, reload from the original rather than guessing what the lost characters were.

The key limitation: lost information cannot be reconstructed from the damaged CSV

If 00123 was saved as 123, the edited CSV no longer tells you how many zeros were there. This tool can highlight warning patterns, but it cannot recover information that was already removed.

Integers longer than 15 digits deserve special attention

Excel numeric precision is a serious issue for 16+ digit identifiers. Order numbers and membership IDs are identifiers, not quantities; keeping them as text avoids accidental digit changes.

Scientific notation can be a clue that an identifier was treated as a number

A value such as 1.23457E+15 may indicate numeric interpretation. Display formatting alone does not always mean the stored value was damaged, so compare the saved CSV with the original.

A date-looking value may be valid—or it may be a code

Values like 1-2 or 2026-09-12 are flagged as date-like patterns, not declared wrong. Only your data contract can tell whether the field was supposed to be a date.

A practical example

Run the saved file before uploading a catalog or order CSV. Reviewing only the flagged rows is much faster than manually scanning every identifier and date column.

If you want the deeper picture