Help! My CSV is dropping the '0' off the front of SKU's or displaying as 1.11E+11

This article has moved to a new home. View the updated version

Spreadsheet programs have different cell types like General / Standard, Text, Number, Currency and Dates. Since the program does not know what type of data is in each cell, it tries to guess. In most cases it assigns the General or Standard cell type to each cell.

This cell type makes changes to numbers that are being imported. For example:

  1. 028263 will be imported as 28263 – dropping the leading zero. This is an issue when 028263 is the SKU for a product.

  2. 111222333444 will be imported as 1.11E+11 – converting the number into scientific notation. Scientific notation is used by scientists to display very small or large numbers.

To avoid the program converting the numbers, the CSV file will need to be imported rather than opened.


If you are using Microsoft Excel, check out this article:
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba

If you are using Open Office, check out this article:
http://openoffice.blogs.com/openoffice/2006/02/opening_csv_or_.html

If you are using LibreOffice, check out this article:
https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files

If you are using Google Sheets, it does not give the option to change the cell format when importing:
https://support.google.com/docs/answer/40608?hl=en


  • Last Modified: 28/09/2017 Neto Version: 6.6