How do I Retain Leading Zeros when Saving a CSV?

Overview

Some manufacturers have leading zeros in their UPC (or other number fields) and unless you format the column correctly the leading zero(s) will be dropped when you save a copy of your XLS file in CSV format.

Solution

Please read this Microsoft Excel help page for options. Most of the time the easiest solution is to right click on the column you need to format in Excel and then format the cells as "Text" before saving a copy of your data file as a CSV. No need to open your CSV to double check, the CSV will retain the leading zeros and you can directly upload your file to your Shotfarm account.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request