The instructions below are for how you should open .CSV files to ensure Excel doesn’t remove leading zeros on numbers. For example, if you have SKU 012345, Excel will automatically change this to 12345 for your convenience. This will cause issues when you attempt to import this file back in since the SKU number has been changed.
The steps outlined below will ensure that numbers won’t be altered when you open them in Excel.
- You'll first open up a new Excel sheet.
- In the Data tab, you'll click "From Text" button. Locate the .CSV file and click "Import."
- In the Delimiters drop down select "Comma", in the Data Type Detection drop down select "Do not detect data types".
- Click "Load".
This will open the file without altering the columns.
If you have any questions about this process or run into any issues, reach out to the Support team by emailing firstname.lastname@example.org or calling 800.654.3123 ext. 1 for assistance.