Opening a file in Excel made the leading zeros disappear

Built!

Check CSV and Excel data for values spreadsheet apps might change, then export an XLSX that preserves them.

Current workflow

You open a mailing-list CSV and find the text garbled, the ZIP code "01234" turned into "1234," and a long member number displayed as something like "1.23E+15." This happens because Excel interprets the values as numbers. The real problem is that once you save the file in that state, the original values are hard to get back. If you save without noticing the damage, you keep using the corrupted values unless you can get hold of the original file again.

Solution

Prevent Excel Data Loss

How to use

1. Add your CSV or XLSX file. 2. In the inspection result, check the count and cell locations for each risk type. Cells with suspected encoding problems, numeric-looking strings with a leading zero, long numbers Excel can lose precision on, and strings that can be mistaken for dates are shown separately. 3. Download the value-preserving XLSX, where risky values from the CSV are stored as text with a text format. In an XLSX you added, cells already suspected of damage are only flagged. Your original file is not overwritten.

Example

- Input: a table of 5 orders × 7 columns (Order ID, Customer, Phone, ZIP Code, Item Code, Order Date, Amount) - Result: of 35 cells inspected, 19 have problems — 5 with 16-digit precision loss, 4 with a lost leading zero, 5 misread as scientific notation, 5 auto-converted to dates (16 cells fine). Five different order IDs (1102345678901234 through 1102345678901238) all collapse into the single value 1102345678901230 in Excel; ZIP code 04524 becomes 4524; item code 1E5 becomes 100000; order date 1-2 becomes January 2. Each corrected value simply keeps the original value stored as text.

Open tool
View details
Limits
- A value already saved by Excel as a number — leading zero deleted, or the last digits of a number over 15 digits already changed to 0 — may be impossible to restore, because the original information is gone. The same goes for values already converted to dates and saved. - CSV and XLSX are supported; XLS is not. Each file can be up to 10MB or 50,000 rows, and only the first sheet is checked and exported.
Cost type
Free

This tool prevents damage before it happens. A file that has already been saved in its corrupted state cannot be restored to the original values by this tool either. Values suspected of damage are flagged in the results — they are never marked as recovered. And a clean inspection result means only that no risk was found in the types this tool checks (encoding, leading zeros, long numbers, date misreads). Typos or simply wrong data in the values themselves are not inspected.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in