Generate barcodes in google sheet

In this tutorial, we will see how we can create barcodes in Google Sheet.

 

Anyhow, here you can see that I have a very basic product info table consist on four columns named” Product Code” “Product Name” and two others columns are “Barcodes” because I will show two ways of creating barcodes.

Instructional Tutorial:

 

Well, in the Product code column, I have product codes based on numbers and combination of alphabet and numbers. And, I have changed the formatting of the product code column by selecting it and changing the formatting to “Plain Text” under format tab.

Now, the first method of creating barcode is to use a font to convert a “Product code” into a barcode. Now, write a formula by adding the parenthesis and selecting the concerned cell where you have written your product code, and hit enter. Now our product code has been added here and all we need is to just change the font to turn it into a barcode and here you can see that I don’t have a concerned font to change it into a barcode. So, search “barcode” by going to “More Fonts”.

Here you can see that many options have shown-up and for the sake of example, I am selecting this one, and then click on “OK” and here you can see that the product code has been converted into a barcode. And if you don’t want to use parenthesis, you can just remove them. and since I haven’t locked the formula by adding the dollar signs, i can just drag the formula down to create all.

And, the second way of creating barcode is to use online services. So, search “free online barcode generator” on your search engine and use the one of your choice and for the purpose of example, I am using this one. Now, just copy your product code and paste it here and then click on “Generate Barcode” button to create it. Now, click here and copy this link,

then, go back to your sheet and create a formula named “Image” and here you can see that we need to put the link into inverted commas. So, paste the link by adding inverted commas and then hit enter and here you can see that the barcode has been generated.

Well, since the barcode has been created by hardcoding the product code value in the link, we can make it dynamic by replacing it with the “Cell Address”.

So, just find the value and add the product code cell address using the quotation marks and & and then hit enter after deleting the hardcoded value and then drag the formula down to create all barcodes.

Moreover, the barcodes are fully dynamic, which means, if you make any change in the product code, it will automatically update the barcode too.

Anyhow, this is how you can create barcodes in google sheets and I hope this will be helpful for someone out there and thanks for watching.