There was a time when companies needed to purchase expensive barcode software to create barcodes for their products. But that is no longer the case, as you can easily create barcodes from product codes through Google Sheets.
This feature is especially useful for start-ups and small and medium-sized businesses operating on a limited budget and resources.
In this post, I’ll walk you through the process of creating barcodes from your product codes with the help of Google Sheets. Let us begin.
- Start a new spreadsheet in google sheet.
- Fill the first three cells with “Product name“, “Product ID“, Y “Barcode” respectively.
- Select cell C to highlight the entire Column C, press and hold Domain (Mac)gold control (Windows), then click “Barcode” to deselect that particular cell.
- With the rest of the column highlighted, click sources from the top menu and select more fonts.
- Type “Free Barcode” and then select “Free barcode 39” From the results.
- Select the first cell in Barcodewhich is C2, and enter this formula:
=IF(B2<>"","*"&B2&"*",""). What this formula does is if cell B2 is not empty, it will generate a barcode for it.
- C2 cell with one clickand so drag it down (in the lower right corner) to copy the formula to more rows.
testing the blade
Let’s put what we’ve created to the test.
Enter a product, then follow up with a product code (numbers only), and the respective product barcode should be automatically generated for you.