We all use barcodes regularly. When we need a new barcode we don’t need any complicated software to create them. We can use Microsoft Excel or Google Sheets to create a barcode

Using a spreadsheet we can convert a long list of product numbers into barcodes with a few clicks.

What types of Barcodes are there?

Barcode 128

Primarily used for inventory management and package delivery. Can store numbers and letters

Barcode 39

Barcode 128’s predecessor, only able to store numbers.

UPC / EAN13

Seen on nearly every product in every shop

Online Barcode Generators

Online barcode generators will only produce one barcode at a time, using a spreadsheet we can create multiple instantaneous. Though often the online generators give us a larger choice to create. It is worth using them to test what works with your system.

Barcode Generator

Free online barcode generator | Shopify

Free Online Barcode Generator | Zoho Inventory

Download a Barcode Font

We will be using a Barcode Font for this recipe.

Download your require font “Libre Barcode” 39, 39 Text, 128, 128 Text, or EAN13, font file from Google Fonts

QR Barcode

Have a read of our complete guide to QR codes for the latest info on all things QR

Create a barcode in Excel & Sheets

Create a barcode using Excel or Sheets

Print Tutorial Pin Tutorial

Computer Time 15

Total Time 15

Equipment

Microsoft Excel OR
Google Sheets

Ingredients

Spreadsheet Of Products

Spreadsheet Of Products

Instructions

In our spreadsheet of product names and numbers create a new column for our barcodes
Spreadsheet Of Products
In the top cell of our product list enter =”*”&B2&”*”
Replace B2 with the cell of our first product number
Copy this down the table
Select our data then change the barcode column font to Libre Barcode 128