How Do I Fix My UPCs in Scientific Notation?

Created: - Updated:

When you work with Microsoft Excel or any spreadsheet software, you want to make sure that you are careful when trying to manage your Product .csv spreadsheet. By default, the spreadsheet software will open with certain settings. The UPC column in the Product .csv spreadsheet will always open with the general setting, which converts large numbers (UPCs are 12 digits) to scientific notation.

It's important to make sure that you convert the column to the number or the custom (zero) setting; otherwise, you could end up with scientific notation in the UPC. Here are some ways that you can format your Product .csv spreadsheet file in Excel to prevent this from happening

NUMBER FORMAT:

product_data__8_.png

CUSTOM  FORMAT:

Format_Cells_and_product_data__8_.png

 

If these options do not work for you or you have a zero at the front of your SKU, then you need to convert the UPC column into a text column. 

The solution is to use the Data > Text to Columns option in Excel. This will allow you to export the UPC column as a  text field. Here's how to do that: 

1) Select the UPC column in the Excel File: 

Fullscreen_2_2_18__9_57_AM.png

2) Select the "Delimited" option in Excel:

Convert_Text_to_Columns_Wizard_-_Step_1_of_3_and_product_data__8_.png

3) Click the "Comma" option:

Convert_Text_to_Columns_Wizard_-_Step_2_of_3_and_product_data__8_.png

4) Choose the "Text" Data Format:

Convert_Text_to_Columns_Wizard_-_Step_3_of_3_and_product_data__8_.png

5) After, hit the finish button, and then you should be able to see your UPCs in a text format: 

product_data__8_.png

Was this article helpful?
0 out of 0 found this helpful

Comments