Creating a barcode in Excel requires a font, not a plugin
You can create a barcode in Excel using a barcode font — a typeface that converts numbers into scannable bars. Excel itself cannot generate barcodes natively, but it can display them once you install the right font and format your data correctly. The process takes about ten minutes and works in Excel for Windows and Mac.
The most common approach is to download a free barcode font, install it on your computer, and then apply it to a column of numbers in your spreadsheet. When you type a product code or inventory number and format it with the barcode font, Excel displays it as a visual barcode that a scanner can read. No macros, no add-ins, no subscriptions.
Key Takeaways
- Barcode fonts are free downloads that you install once on your computer, then use in any program including Excel.
- Code128 is the most widely compatible barcode format and works with standard retail and inventory scanners.
- You paste your numbers into Excel, apply the barcode font to that column, and the numbers display as scannable bars.
- The barcode will only display correctly on computers that have the font installed — sharing the file with someone else requires them to install the font too.
Download and install a barcode font
Start by downloading a barcode font to your computer. Code128 is the most reliable choice because it works with nearly all barcode scanners. Search for "Code128 barcode font free download" and look for sites like FontSpace or DaFont, which host fonts that are safe to use.
Once you download the font file (usually a .ttf or .otf file), install it by right-clicking the file and selecting "Install font" on Windows, or double-clicking it and clicking "Install Font" on Mac. After installation, restart Excel so it recognizes the new font. You only need to do this once — the font stays on your computer and is available in Excel and every other program.
Set up your data in Excel
Open Excel and create a simple spreadsheet with your barcode numbers in one column. Put each number on its own row. For example, if you are creating barcodes for product inventory, put the product codes in column A, starting at A1. Keep the numbers as plain text — no extra spaces, no dashes, no letters unless your barcode format requires them.
If you are using Code128, the numbers can be digits only, or a mix of digits and letters depending on what you are encoding. Check the documentation for your specific barcode font to see what characters it accepts. Most retail barcodes are 12 or 13 digits, but your font may support longer or shorter codes.
Apply the barcode font to your column
Select the entire column of numbers by clicking the column header (for example, click "A" to select all of column A). Right-click and choose "Format Cells," or press Ctrl+1 on Windows or Command+1 on Mac. The Format Cells dialog opens.
Go to the Font tab and scroll down the font list until you find the barcode font you installed (for example, "Code128"). Click it to select it, then click OK. Excel immediately converts the numbers in that column to barcode format — you should see horizontal bars instead of digits.
Adjust the size and appearance
Barcode fonts work best at larger sizes. Select your barcode column again and increase the font size to at least 24 or 36 points so scanners can read them reliably. Smaller barcodes may not scan, especially if the scanner is older or the barcode is printed at low resolution.
You can also adjust the row height to make the barcodes taller. Select the rows containing barcodes, right-click, and choose "Row Height." A taller barcode is easier to scan. If you want to print the barcodes, make sure your printer can handle the resolution — most modern printers work fine, but very old printers may produce barcodes that scanners cannot read.
Test your barcode before printing or sharing
Before you print or distribute your spreadsheet, test one barcode with an actual scanner if you have access to one. Scan the barcode on your screen or print a test copy and scan the printout. If the scanner reads the number correctly, your setup is working. If it does not, the most common causes are the wrong font, incorrect number format, or a size that is too small.
If you plan to share this spreadsheet with someone else, remember that they will need the same barcode font installed on their computer to see the barcodes correctly. If they do not have the font, the column will display as regular text or symbols instead of bars. You can send them the font file along with the spreadsheet, or direct them to where you downloaded it.
Common problems and fixes
If your barcodes look like random symbols instead of bars, you likely have the wrong font selected or the font did not install correctly. Double-check that the font name in the Format Cells dialog matches the barcode font you downloaded. Restart Excel and try again.
If a scanner cannot read your barcode, the issue is usually size — make the font larger. Code128 fonts typically need to be at least 24 points to scan reliably. Also check that your numbers do not have leading spaces or trailing spaces, which can break the barcode. Select the column, go to Find & Replace (Ctrl+H), and search for spaces to remove them if needed.
If you printed the barcode and it still will not scan, try printing at a higher quality setting or on a different printer. Some printers compress the image too much, which makes the bars too thin to scan. Increasing the font size before printing usually solves this.
Frequently Asked Questions
Can I create a QR code in Excel the same way?
No. QR codes require a different approach because they are two-dimensional and more complex than linear barcodes. Some barcode fonts include QR code support, but most do not. Excel 365 has a built-in QR code feature under Insert > Add-ins > Get Add-ins, but for older versions you would need a third-party tool or a QR code generator website.
What barcode format should I use?
Code128 is the best choice for most uses because it is widely supported and works with nearly all scanners. If you are creating retail barcodes, check whether your retailer requires a specific format like UPC or EAN. For internal inventory, Code128 is reliable and flexible.
Will the barcode work if I email the Excel file to someone?
Only if they have the same barcode font installed. If they do not, the column will show symbols or text instead of bars. Include the font file with your email or give them a link to download it, and ask them to install it before opening your spreadsheet.
Can I print barcodes directly from Excel?
Yes. Once your barcodes are formatted in Excel, you can print them normally. Make sure the font size is large enough (at least 24 points) and test one barcode with a scanner before printing a large batch. Print quality matters — use a standard printer and avoid very low-quality or draft settings.
What if I need to create hundreds of barcodes?
The process is the same. Enter all your numbers in column A, select the entire column, apply the barcode font, and adjust the size. Excel handles large columns without any problem. If you need to generate the numbers themselves (like sequential codes), you can use Excel's fill feature to auto-generate a series.