Showing Posts From
csv

Excel Turned My Product Code 1E5 Into 100000 — It Was Never a Number
Don't double-click the supplier CSV. The moment a spreadsheet opens it, codes like 1E5 stop being codes — they are read as numbers, and if you save, the change is permanent. Check the file first instead: run it through the checker, download the value-preserving XLSX, and 1E5 stays the text 1E5. Try…
Why Excel Breaks Your CSV: Long Numbers, Leading Zeros and Dates
You export an order list from your shop, open the CSV in Excel, and something is off. The tracking number now reads 1.23457E+15 . The postal code 01234 has become 1234 . A product code like 3-4 turned into a date. Nothing warned you, and if you save the file now, those changes stay for good. This h…