How to Create a Barcode In Google Sheets & Microsoft Excel 

A sample barcode label on a box

Say you have an online store and are looking for a quick and easy way to create, organize, and print barcode labels for your business. Before purchasing an expensive barcode software, you can try creating your company’s barcodes in a Google Sheets program or Microsoft Excel. 

Let’s take a look at how to access these features and use them to your advantage.

Google Sheets 

Below is a step by step look at how to create a barcode in Google Sheets for your online business.

1. Open Google Sheets and start a new spreadsheet

2. Organize your business information into columns (i.e. product name/number, code numbers, customer names, barcodes, etc.)

3. Add your products into the spreadsheet

4. Give each product its own unique identification number

5. In the barcode column, add in the formula =”*”&B2&”*” (the letter B corresponds with the column letter and the number 2 corresponds with the row)

6. Change your font to Libre Barcode – either Code 39 or Code 128 (For this article, we chose Libre Code 39)

At this point you can click and drag the formula down as many columns as you need to create multiple, unique barcodes.

Microsoft Excel 

Below is a step by step look at how to create a barcode in Microsoft Excel for your online business. You will want to make sure you have a barcode font downloaded for this to work properly.

1. Open Microsoft Excel and start a new spreadsheet

2. Organize your business information into columns (i.e. product name/number, code numbers, customer names, barcodes, etc.)

3. Add your products into the spreadsheet

4. Give each product its own unique identification number

5. In your barcode column, add in the formula =”*”&B2&”*”

6. Change your font to Libre Barcode – either Code 39 or Code 128 (For this article, we chose Libre Code 39)

Hopefully these quick and easy steps can help you organize and print your barcode labels in an efficient manner.