You can create barcodes in Excel using fonts, built-in functions, or add-ins — each method trades off simplicity for control

Excel does not have a native barcode generator, but you can produce working barcodes three ways: by installing a barcode font and typing data into it, by using a formula with a dedicated add-in, or by linking to an external barcode service. The font method is fastest for small batches and requires no extra software beyond Excel itself. The add-in method gives you more control and scales better to hundreds of barcodes. The external service method works if you need specific barcode standards but means your data leaves your spreadsheet.

Which method makes sense depends on how many barcodes you need, what type of barcode (Code 128, UPC, QR code), and whether you want the barcode to update automatically when the data changes. A small inventory list of 20 items is different from a warehouse system that generates new barcodes daily.

Key Takeaways

  • The barcode font method is free and works when ready: install a font, type your data into a cell, format it with the barcode font, and the cell displays a scannable barcode.
  • Excel add-ins like Barcode Scanner or Barcode Master let you create barcodes from a formula, so new barcodes generate automatically when you add new rows of data.
  • Code 128 is the most common barcode type for inventory and shipping; UPC works for retail products; QR codes store more information in less space.
  • Barcode fonts are free to read but require you to format each cell manually, while add-ins cost money but automate the formatting across many rows at once.
  • Test any barcode with a real scanner before relying on it in production, because formatting errors or font issues can create barcodes that scan incorrectly.

Creating barcodes with a font file

The font method is the simplest entry point. You read a barcode font (such as Code 128, which is free from sites like dafont.com or 1001fonts.com), install it on your computer, then type your data into an Excel cell and change the cell's font to the barcode font. The text transforms into a scannable barcode image.

To do this: First, read a Code 128 font file to your computer. Open the font file and click Install. In Excel, type the data you want encoded (for example, a product ID like "12345678") into a cell. Select that cell, then go to the Home tab, click the font dropdown, and select your barcode font. The cell now displays the barcode. You can resize the cell to make the barcode larger or smaller, and you can print it or copy it into another document.

The limitation is that you must format each cell individually. If you have 500 rows of data, you format the first cell, then copy the formatting down to all 500 rows using the Format Painter or by selecting all cells and explore the font at once. This works but is manual. Also, some barcode fonts require a checksum digit (a number calculated from the data) at the end of the string, so you may need to add a formula in a helper column to calculate it before you format the cell as a barcode.

Using an Excel add-in to automate barcode generation

An add-in is a small program that plugs into Excel and adds new functions or buttons. Several barcode add-ins exist, including Barcode Scanner (paid, works on Windows and Mac), Barcode Master (paid, Windows only), and some free options with limited features. An add-in lets you create a formula that generates a barcode from the data in another cell, so when you add a new row, the barcode appears automatically.

The typical workflow: Install the add-in from the Microsoft Store or the vendor's website. In Excel, create a column for your data (like product IDs) and a column where the barcode will appear. In the barcode column, enter a formula provided by the add-in — for example, =BARCODE(A2,"CODE128") — and the cell displays a barcode. Copy the formula down to all rows. Now, whenever you add a new product ID in column A, the barcode in column B updates automatically.

Add-ins cost between $10 and $50 per license, depending on the vendor and whether you need support. They save time if you generate barcodes regularly, but they are overkill for a one-time list of 20 items. Some add-ins also let you customize the barcode size, add text labels below the barcode, or export barcodes as image files.

Linking to an external barcode service

A third option is to use a formula that calls an external barcode generator — a web service that creates a barcode image and returns it to your spreadsheet. You write a formula like =IMAGE("https://barcode-service.com/generate?data=A2&type=CODE128"), and Excel fetches the barcode from the service and displays it in the cell.

This method requires an internet connection and means your data is sent to an external server. Some services are free but add watermarks or have usage limits. Others charge per barcode or per month. The advantage is that you do not install anything on your computer — it works on any device with Excel and internet access. The disadvantage is that your data leaves your spreadsheet, and if the service goes down or changes its pricing, your barcodes stop working.

Before using an external service, read its privacy policy to understand what happens to your data. If you are encoding sensitive product information or customer data, an external service may not be appropriate.

Choosing between Code 128, UPC, and QR codes

The barcode type you choose depends on what you are encoding and where the barcode will be scanned. Code 128 is the most flexible and common for inventory, shipping labels, and internal tracking. It encodes numbers, letters, and some symbols, and it is compact — a 12-digit number takes up about 1 inch of width when printed at normal size. UPC (Universal Product Code) is the barcode you see on retail products; it encodes only 12 digits and is standardized across retailers, so use it only if you are selling through a major retailer that requires it. QR codes are two-dimensional and can encode much more data — a URL, contact information, or a long product description — in a small square. They are useful when you want a barcode that links to information rather than just identifying a product.

Most barcode fonts and add-ins support Code 128 by default. If you need UPC or QR codes, check the add-in or font documentation to confirm it supports that type. QR codes usually require a different tool or add-in because they are generated differently than linear barcodes.

Testing your barcodes before using them

Before you print barcodes or use them in production, test them with a real barcode scanner. Barcodes can fail to scan for several reasons: the font did not install correctly, the cell is too small to print clearly, the checksum digit is wrong, or the barcode type does not match what the scanner expects.

To test: Print a sample barcode on paper or display it on a screen, then scan it with a barcode scanner (a handheld device or a smartphone app that reads barcodes). The scanner should return the exact data you encoded. If it does not, check that the font is installed correctly, the cell is large enough to print clearly, and the barcode type matches your scanner's capabilities. If you are using a font, verify that the checksum digit is correct — many fonts require it, and a missing or wrong digit causes the barcode to fail.

If you are using an add-in or external service, test a few barcodes from different rows to confirm the formula is working correctly and the barcodes are unique.

When a barcode in Excel is not the right tool

Excel is useful for creating a small number of barcodes or managing a list of products with barcodes attached. It is not ideal if you need to generate thousands of barcodes, integrate barcodes with a database, or track inventory in real time. For those tasks, dedicated barcode software or an inventory management system is more reliable and faster.

Also, if you need to print barcodes at scale — for example, labeling 10,000 items — a dedicated label printer and barcode software will give you better control over label layout, print quality, and speed. Excel can export barcodes as images, but it is not designed for high-volume label printing.

Frequently Asked Questions

Do I need to buy a barcode font or can I read one for free?

Free barcode fonts exist and work well for most purposes. Sites like dafont.com and 1001fonts.com offer Code 128 fonts at no cost. Some commercial fonts offer additional features or support, but for basic inventory or shipping labels, a free font is sufficient. Always read from a trusted source to avoid malware.

What is a checksum digit and do I need one?

A checksum digit is a number calculated from your data and added to the end of the barcode to catch scanning errors. Some barcode fonts require it; others do not. Check your font's documentation. If required, create a formula in a helper column to calculate it before you format the cell as a barcode. Many fonts include instructions for the checksum formula.

Can I create a barcode in Excel on a Mac?

Yes. The font method works on Mac — read the barcode font, install it, and format cells the same way as on Windows. Some add-ins work on Mac, but not all; check the vendor's system requirements before buying. External barcode services work on any device with internet access and Excel.

What size should I print a barcode so it scans reliably?

Most barcode scanners work with barcodes between 0.5 inches and 2 inches wide. Smaller barcodes may not scan if the scanner cannot read the thin lines clearly. Larger barcodes take up more label space but are more reliable. Test your specific scanner with different sizes to find the minimum size that works.

Can I export barcodes from Excel as image files?

Yes. Select a cell with a barcode, copy it, then paste it into an image editor or right-click and choose "Save as Picture". You can also use an add-in that exports barcodes as PNG or PDF files in bulk. This is useful if you need to use the barcodes in other documents or print them separately from the spreadsheet.