Using Excel to edit CSV files - truncated numbers/scientific notation

If your organisation uses a SKU format which is either long digit numbers, or numbers with a leading 0, such as in the image below


When you export your Retail POS products to a CSV, and open this directly into Microsoft Excel, it treats the SKU column as a number field and tries to remove the leading zero and 'truncate' the SKU, so that it looks like the image below.


If this happens, when you then save the re-import the file, Retail POS may treat this as a new SKU code, and add a duplicate or incorrect product.

The easiest way to work with such SKU numbers is to edit CSV files Open Office  (a free alternative to MS Office), which does not truncate number fields.

But it is possible to work with Excel, without truncating SKU codes, following the steps below.

1) Export your products to a CSV file  and save it to your computer

2) Open a new Microsoft Excel spreadsheet

3) Select Data > From Text and navigate to the saved product export CSV file


4) Microsoft will prompt you to select what type of data file it is. At Step 1 , select Delimited, then click Next


5) At Step 2 select Comma and then click Next


6) At Step 3 navigate to and highlight the SKU column, change the Column data format  to Text and then click Finish (You may wish to apply this to the 'handle' column if you use the same naming convention)


7) Check the SKU code in Excel, it should now be in the correct format



Did this answer your question?
Have more questions? Contact us so that we can help you out.