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.
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
Comments
Be the first to comment.