Barcode Generator for Excel: Adding Barcodes to Spreadsheets

Yes, you can create a barcode in Excel. But it's not built in as a native feature.

Excel handles numbers, formulas, and data really well. It was never designed as a design or graphics tool. Barcodes fall into that second category, which is why there's no direct button for them.

That said, plenty of businesses run their entire inventory system through Excel. Adding barcodes to that workflow is a common need. It just takes one extra step compared to typing a formula into a cell.

A barcode isn't just a picture of some lines. It's a precise visual encoding of data, following strict rules for spacing, width, and structure.

Different barcode formats, like Code 39, Code 128, and UPC, all follow their own encoding rules. Getting this right requires either a specially designed font or a dedicated generator that knows those rules.

Excel's formula engine can handle text and numbers. It wasn't built to handle that kind of visual encoding. So Microsoft never added it as a core feature.

There are two practical routes people use. The first is installing a barcode font and typing your data with a formula. The second is generating the barcode as an image somewhere else, then inserting that image into your spreadsheet.

Both work. But they work differently, and they come with different tradeoffs. The rest of this guide breaks down each one.

A barcode font is a specialized font. When you type certain characters, the font renders them as a barcode pattern instead of regular letters.

This has been a popular method for years, especially for basic inventory sheets. It doesn't require any add-in or internet connection once it's installed.

First, you download and install a barcode font on your computer. Many free barcode fonts exist for formats like Code 39.

Next, you type your data into a cell, often with a formula that adds required start and stop characters around it. Then you select that cell and change its font to the barcode font you installed.

The text transforms visually into a barcode. Anyone scanning it with a compatible barcode scanner should be able to read the encoded data back out.

Code 39 is the easiest barcode format to create with a font alone. It only requires wrapping your text in asterisks, like *ABC123*, and the font handles the rest.

Code 128 is more complicated. It requires a calculated checksum character based on the exact data you're encoding. A simple font swap won't get this right on its own.

If you need Code 128, you'll usually need a formula or macro that calculates this checksum for you before the font can render it correctly. This is one of the biggest points of confusion for people trying the font method for the first time.

The font method works, but it has real limitations. If the font isn't installed on every computer that opens the file, the barcode won't display correctly.

Printing can also cause problems. Some printers or PDF exports don't render fonts pixel-perfect, which can break a barcode's scannability even if it looks fine on screen.

Fonts also only cover a handful of barcode formats well. If you need a QR code or a more complex 2D barcode, a font alone won't get you there.

The second method skips fonts entirely. Instead, you generate the barcode as an image using a barcode generator, then place that image into your spreadsheet.

This is generally the more reliable option, especially for anyone who isn't comfortable with fonts, formulas, or checksums.

You enter your data into an online barcode generator. The tool creates a barcode image based on the format you choose, whether that's Code 39, Code 128, UPC, or a QR code.

You download that image, then insert it into your Excel spreadsheet using Excel's normal image insert function. From there, it behaves like any other picture in your file.

An online barcode generator online handles all the encoding rules for you. You don't need to worry about checksums, start characters, or which font supports which format.

The image also displays the same way on every computer, since it's not dependent on a font being installed. This matters a lot if you're sharing the spreadsheet with other people or printing it for warehouse use.

It also opens up formats a barcode font simply can't handle well, like QR codes, which are increasingly common on product packaging and shipping labels.

Seeing how different businesses actually use barcodes in Excel makes the method choice easier to apply to your own situation.

A small boutique selling around 200 products keeps its entire inventory in Excel. Each product needs a scannable barcode for checkout at the register.

Since the shop uses standard UPC codes assigned to each product, the owner uses an online barcode generator to create each barcode image individually. With only 200 products, generating and inserting images one at a time is manageable, and it avoids any font compatibility issues on the shop's older point-of-sale computer.

A distribution warehouse tracks several thousand SKUs across multiple storage locations. Generating that many barcode images individually would take far too long.

Here, the barcode font method makes more sense. The warehouse team sets up a formula that automatically adds the correct start and stop characters to each SKU, then applies the barcode font across the entire column at once. Because the font is installed on every relevant computer in the warehouse network, display consistency isn't a concern.

A freelance seller occasionally needs a single QR code for a shipping label or a small batch of product tags. Installing a barcode font for such infrequent use isn't worth the setup time.

Instead, they use a free online barcode generator whenever a new code is needed, download the image, and paste it directly into a label template in Excel. Since the volume is low, the extra step of generating each image individually isn't a real burden.

Across all three examples, the deciding factor is the same: volume and consistency needs point toward the font method, while occasional or varied barcode formats point toward an online generator.

Here's the full process for using a barcode generator in Excel, from data entry to a finished, scannable barcode in your spreadsheet.

1. List your data in Excel first. Set up a column with the product codes, SKUs, or reference numbers you want turned into barcodes.

2. Open a barcode generator. Use an online barcode generator that supports the format you need, whether that's Code 128 for general inventory or UPC for retail products.

3. Enter your first code into the generator. Type or paste the exact value from your Excel cell into the tool.

4. Choose your barcode format. Select Code 39 for simple alphanumeric data, Code 128 for a wider range of characters, or UPC if you're working with retail product codes.

5. Generate and download the barcode image. Most tools let you save this as a PNG or SVG file.

6. Insert the image into Excel. Go to the Insert tab, choose Pictures, and select your downloaded barcode image.

7. Resize and position the image. Drag it into the correct cell or row, and resize it so it fits cleanly without stretching or distorting.

8. Repeat for each code. For a small list, repeat this process for each entry. For larger lists, consider using the barcode font method instead, since generating dozens of images one at a time can get slow.

9. Test your barcode before relying on it. Scan it with an actual barcode scanner or a scanning app to confirm it reads back the correct value.

If you're managing hundreds of barcodes and need them tied directly to editable Excel data, the font method is usually faster once it's set up correctly. If you need a handful of accurate, reliable barcodes without touching formulas, an online barcode generator is the simpler path.

Test every barcode before printing in bulk. A barcode that looks correct on screen can still fail to scan. Always test with a real scanner first.

Keep a consistent format across your spreadsheet. Mixing barcode formats in the same sheet makes scanning and troubleshooting harder than it needs to be.

Avoid resizing barcode images by dragging corners freely. This can distort the width of the bars, which affects scannability. Resize proportionally whenever possible.

Keep your source data in a separate column. Even when using the font method, keep the plain text value next to the barcode itself. This makes it easy to search, sort, or troubleshoot later.

Choose the right format for your use case. Code 128 handles more character types than Code 39. UPC is required for most retail products. Pick the format based on what you're actually encoding, not just what's easiest to set up.

• Using Code 39 without the required asterisks. This format needs start and stop characters, or the barcode won't render correctly, even with the font installed.

• Forgetting the font isn't installed on a shared computer. A barcode that looks perfect on your machine can turn into gibberish text on someone else's if the font is missing.

• Trying to use Code 128 with a font alone, no checksum. Without the correct checksum character, a Code 128 barcode may not scan correctly, even though it looks fine visually.

• Stretching barcode images to fit a cell. This distorts the bar widths and can make the barcode unreadable to a scanner, even though it still looks like a barcode to the eye.

• Never testing with an actual scanner. A barcode that looks visually correct isn't proof that it works. Testing with a real scanner catches problems before they reach a printed label.

• Using a low-resolution image from an online barcode generator. A blurry or pixelated barcode image can fail to scan, especially at smaller print sizes.