CSV Workaround: Excel 'E+12' Error in Barcodes or SKUs

Introduction

If you encounter issues with missing zeroes (0) in your Excel sheet when wanting to upload barcodes to your BackOffice, do refer to our workaround below.

Step 1.
Open 'TextEdit' on (MacOS) or open 'Notepad' (Microsoft Windows).

Step 2.
Open the CSV file in TextEdit / Notepad.

Step 3.
Press CTRL + A to select all, CTRL + C to copy the raw text to Google Sheets.

Step 4.
Open Google Sheets. Paste the data at Column A1.

Step 5.
Go to Format > Number > Change the entire sheet to Plain Text.



Step 6.
Highlight the 1st column (Column A), go to Data > Split Text to Column. After that, all leading zeroes will appear in the barcode column.

Step 7.
Finally, apply a Filter or Pivot Table to find out which barcode has the leading zero.