In this blog, you will learn how to generate bulk barcodes in Google Sheets. Below is given Step-by-Step Guide to Generating Barcodes in Google Sheets.
Open Google Sheets and Set Up Your Data
Start by opening Google Sheets and prepare your data to generate barcodes in Google Sheets. You will need a column for the data you want to encode in the barcode (e.g., product IDs, asset numbers, etc.). You can see below image, Product IDs are in column C.
Apply formula to another column
Use formula in next column, here in D column. Formula is =”*”&C2&”*”. Product Ids between asterisk (*) starting and closing. Then drag or copy paste your formula till your data.
If you want to do dynamic or want apply formula to whole column then you can use this formula. =IF(C2=””,””,”*”&C2&”*”)
Then apply this formula to the whole column in D where you want to generate barcodes in your Google Sheets.
Search barcode font
To search barcode font go to Font and Click there. and Click on More fonts. You can see in below image.
Now type barcode in Search box there and you will get (as of now there are 6 different types) of font Names. You can check them by clicking on them each. Then click on ok.
Applying Barcode fonts.
You can see there are 6 different barcode fonts but main are 3 fonts.
- Libre Barcode 39
- Libre Barcode 128
- Libre Barcode EAN13 Text
Now select your range where do you want generate barcodes in your Google Sheets. Here Selecting D2:D15 and again click on font and all selected font in previous steps are appearing in fonts and Click any one of them which you want to apply in Barcodes Columns to generate barcodes in Google Sheets.
Here selecting Libre Barcode 39 and all barcodes generated instantly.
Now you can increase barcode font size or final touch so that you can print your barcodes.
Now, you have a quick and efficient method for generating barcodes, perfect for inventory management, asset tracking, and more. Enjoy the convenience and functionality of Google Sheets for all your barcode needs!
Thank You!
You can watch youtube video by clicking below button.