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."
- Check the box that says, "My data has headers" and click "Next."
- In the Delimiters box, deselect "Tab" and check the box that says "Comma" and then click "Next."
- In the Data preview section, select any column with numbers (SKU, UPC, etc.) and change the Column data format to "Text" and then click "Finish."
- In the Import Data box that pops up, ensure the Existing worksheet button is selected and that the text box below says “=$A$1” and then click “OK.”
This will open the file without altering the columns that you switched to “Text” in step 5 above.
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.