How to Generate a barcode in a Google sheet?

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

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

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."

Step 4: Now choose the “QR Code Generator”

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

Step 6: Now, click “continue”

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

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

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

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."    

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

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.    

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.

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

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

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

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