Hi. How can we help?

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

Truncated numbers can occur when using Excel to edit CSV files if your organization uses a SKU format that consists of 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



Was this article helpful?