Skip to main content
← All product updates
improvement

CSV exports no longer change in Excel

Excel changes some values when it opens a CSV file: it drops leading zeros, turns long numbers into scientific notation, and treats values that start with +, =, @, or - as formulas. Exports now put a leading apostrophe on those values so Excel shows them as written. Imports remove one leading apostrophe and accept it in SKU, UPC, GTIN, HTS, PO number, warehouse, location, shipment, and tracking number columns.

Imports reject a number already in scientific notation, such as 6.00106E+13, and read two-digit years in dates, so 8/3/26 becomes 2026. Anything other than a spreadsheet that reads an export will now see the apostrophe.