Showing Posts From

Excel & CSV

Excel Turned My Product Code 1E5 Into 100000 — It Was Never a Number

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…

Excel Filter Only Shows the First Row of a Merged Group? Unmerge and Fill Down First

Excel Filter Only Shows the First Row of a Merged Group? Unmerge and Fill Down First

Your filter isn't broken, and you don't need to unmerge everything by hand and retype the missing labels. Fix the file before you filter: run the XLSX through the Unmerge & Fill tool, pick the two merged columns, and download a copy where every row carries its own team and date. Then filter and piv…

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…