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.
Table of Contents
What types of Barcodes are there?
Barcode 128
Primarily used for inventory management and package delivery. Can store numbers and letters
![](https://itrecipes.co.uk/wp-content/uploads/2022/10/Example-Code128.webp)
Barcode 39
Barcode 128’s predecessor, only able to store numbers.
![](https://itrecipes.co.uk/wp-content/uploads/2022/10/Example-Code-39.webp)
Barcode 39 Example
UPC / EAN13
Seen on nearly every product in every shop
![](https://itrecipes.co.uk/wp-content/uploads/2022/10/Example-EAN13.webp)
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.
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
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 barcodesSpreadsheet 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
Struggling with the above recipe? Hire a chef to do it for you