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, this article will provide a workaround solution! 

Workaround for Errors in Barcodes

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.

Step 8.

And you're done! You should now be able to upload your barcodes to the BackOffice error-free. 

Need further assistance?
Contact our Customer Care Team

📧 care@storehub.com