Hi. How can we help?

How to add zeros to the start of your SKUs via a CSV file


Add leading zeros to the beginning of SKUs through a CSV file. 


  • Retail POS for Mac or PC
  • OpenOffice 


  1. Export your product list to a CSV file
  2. Create an extra column next to the SKU column

  3. Enter the following formula: ="prefix"&C2

  4. Populate the new column with this formula

  5. Delete the original SKU column

  6. Change the heading of the newly created column to sku

The "prefix" is any text you would like to add in front of the cell contents. C2 is the original cell.

Additional Information

How to format CSV files in OpenOffice

Was this article helpful?