How to Generate a barcode in a Google sheet?

Published June 16, 2022

Nowadays, Google Sheets has a built-in "Generate barcodes" feature that enables you to create barcodes automatically. The Barcode is a very important tool in several business fields like retail, where the unique features of a product can be tagged and identified easily. In this article, we will learn how to generate barcodes in Google sheets.

How to Generate a barcode in a Google Sheet

Here is a step-by-step guide to creating a barcode in Google Sheets:

Step 1: Open a new or an existing Google Sheets spreadsheet

Generate a barcode in a Google Sheet, QR Code Generator

 

Step 2: List your product list data in your spreadsheets and create a column for adding barcodes for each product.    

Generate a barcode in a Google Sheet, QR Code Generator2

 

When you add the product ID, you should ensure that every product has a unique ID.

 

Step 3: To generate the Barcode, we will have to install the QR code Generator into our Google sheets. To do so, click on "Extensions," hover over the "Add-ons," and then click "Get add-ons."

Generate a barcode in a Google Sheet, QR Code Generator3

 

Step 4: Now choose the “QR Code Generator”

Generate a barcode in a Google Sheet, QR Code Generator4

 

Step 5: Click on the blue “Install” button to install the QR Code generator.

Generate a barcode in a Google Sheet, QR Code Generator5

 

Step 6: Now, click “continue”

Generate a barcode in a Google Sheet, QR Code Generator6

 

Step 7: You will now need to choose an account to install your QR Code Generator.

Generate a barcode in a Google Sheet, QR Code Generator7

 

Step 8: Now click “Allow” to grant the “QR Code generator” permissions.

Generate a barcode in a Google Sheet, QR Code Generator8

 

The QR Code Generator will be installed in your Google sheets, and you will see the following on your screen:

Generate a barcode in a Google Sheet, QR Code Generator9

 

Step 9: To launch the QR Code Generator, click on the "Extension" button in Google Sheets, then hover over "QR Code Generator" and click "Open."    

Generate a barcode in a Google Sheet, QR Code Generator10

 

Once you have opened the "QR Code Generator," a QR Code Generator will be opened on the right side of your Google sheet spreadsheet.

Generate a barcode in a Google Sheet, QR Code Generator11

 

Step 10:  Now, let's generate barcodes. Enter the formula =" *"&B2&"*" in the barcode column. As you can see, this corresponds to the Product ID for the first product.    

Generate a barcode in a Google Sheet, QR Code Generator12

 

Step 11: Now, change the font to Libre Barcode. You can choose between the codes 128 and 39. In this case, we are going to work with Libre code 39.

Generate a barcode in a Google Sheet, QR Code Generator13

 

 

 

Generate a barcode in a Google Sheet, QR Code Generator14

 

 Now, select the "Libre Barcode 39 Extended Text" to continue.

Step 12: Press Enter on your keyboard, and a barcode will be generated.

Generate a barcode in a Google Sheet, QR Code Generator15

Step 13: Using the fill handle feature, click and drag down to copy and paste Barcode to the other cells.

Generate a barcode in a Google Sheet, QR Code Generator16

 

Our barcodes have now been generated.

 

Conclusion

In this article, we have learned how to generate Barcodes. In addition, we have also learned how to install Google sheets from the Google Ad-on

 

Keywords: Google Docs, Google Sheet, Generate a barcode in a Google Sheet, QR Code Generator

 

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

95 Views