Generating Barcodes for your SKUs in MS Excel [ A step by step guide]

Editor | Sep 10, 2020

When you are just starting your e-commerce business it is very important for you to be hands on with your approach and micro-manage everything. But as time passes and your business starts scaling well, these earlier approaches can limit you and your operations.

barcode

Barcodes are critical for every online seller to streamline their operation. They help your identify, locate and troubleshoot queries about your products when it comes to product categorization, SKUs for inventory stock taking, order IDs, package tracking with AWB numbers. These codes can be scanned by machines easily and thus result in less stress for you as a seller. These barcode machines are relatively inexpensive and are a very good investment for an online seller. USB Barcode guns can also be used like a normal keyboard to make entries into an excel file.

You may be thinking about how you will go ahead and generate these barcodes! Actually the process is really simple. All you need is a PC with Windows 7 and Microsoft Excel installed.

We want to help you out with this process and make you see how this simple trick can ease your life as a seller. Here is a step by step way to generate Barcodes in Excel.

1. Installing the Barcode Font.

The barcode font is a crucial element in this guide. You will have to install it on your computer to get the whole process working.

a. Download the font from here: Download Excel barcode font

b. In Windows 7, go to the ‘Start’ button on the lower left of the screen and enter ‘Fonts’ in the search bar.

c. At this point, the search will display the ‘Fonts’ file. Click on it and copy paste the downloaded font file into this folder. The font file is in a .TTF format. There is no need to unpack it. You can copy the same folder into the fonts section.

d. That’s it! The barcode font is installed.

2. Creating Barcode in Excel.

a. Now fire up Microsoft Excel and create a New Excel File.

b. Make two columns and title them ‘Text to be converted to Barcode’ and ‘Barcode’ respectively.

excel1

c. Fill the first column with your codes. It supports all only numbers or alpha numerical characters.

d. Now copy past the data in column “Text to be converted to Barcode” to “Barcode” Column but add asterick (*) at the beginning and end of the codes.

f. This can be easily done by using following formula in excel ( =”*”&A2&”*” )

excel2

h. Select all the cells in the barcode column which have the codes and select the font “3 of 9 Barcode”. This is the font that you installed earlier.

i. Press Enter once this done and your barcodes will be generated.

That’s how easy the process is. Now, you will need a barcode scanner to make sense of these codes and enter them in your inventory system. You can see some options we have linked here on Ebay India and Shopclues. Their price ranges between Rs.2200 to Rs.2500.

We hope this has been helpful. Feel free to ask any questions that you may have, in the comments section.

Happy Selling!


About Author

Editor

Editor


Leave a Comment


About Us Contact US Advertise with Us

© Copyright 2020 IndianOnlineSeller.com | All rights reserved.

"Amazon, Amazon Prime, the Amazon logo and Amazon Prime logo are trademarks of Amazon.com, Inc. or its affiliates". AS AN AMAZON ASSOCIATE, WE EARN AFFILIATE COMMISSIONS FROM QUALIFYING PURCHASES.