Spreadsheets are where product data lives, so it is natural to want barcodes right next to it. Excel offers a few ways to do this, each with trade-offs. Here are three reliable methods, from the quickest font trick to a clean batch workflow.
Method 1: Barcode fonts (best for Code 39)
A barcode font turns text into bars. Code 39 is the easiest because each character maps to a fixed pattern — you just need to add start/stop asterisks.
- 1 Download and install a free Code 39 font (e.g. from IDAutomation or Grandzebu), then restart Excel.
- 2 Put your raw data in cell A1 (uppercase letters and digits).
- 3 In B1, enter the formula below to wrap the data in start/stop characters.
- 4 Select B1 and change its font to the Code 39 font.
- 5 Increase the font size (36–48pt) for a taller, scannable symbol.
="*" & UPPER(A1) & "*"Fonts are great for quick internal labels, but they cannot compute check digits, so they are unsuitable for EAN/UPC or Code 128 without an encoder add-in.
Method 2: Online generator + insert image
For retail codes or anything needing a check digit, generate the symbol with a dedicated tool and drop the image into Excel.
- 1 Open the BarcodeForge generator and choose your symbology (EAN-13, UPC, Code 128, QR…).
- 2 Enter the data; the check digit is computed automatically.
- 3 Download a PNG (for screen) or SVG (for crisp print).
- 4 In Excel, use Insert → Pictures and place the image next to your data.
Method 3: Batch generation from your sheet
When you have hundreds of rows, inserting images one by one is impractical. Export the sheet as CSV and use a batch generator.
- 1 In Excel, save your data as CSV (one column for the barcode data, optional columns for names/prices).
- 2 Open BarcodeForge's Batch Generator and upload the CSV.
- 3 Map the data column, choose a symbology or a label template.
- 4 Generate, then export a print-ready PDF sheet or individual PNG/SVG files.
This produces perfectly aligned labels for a whole product list in one pass, and you can add auto-incrementing serial numbers for asset tags.
Which method should you use?
| Scenario | Best method |
|---|---|
| A few internal Code 39 labels | Font (Method 1) |
| Retail EAN/UPC or QR codes | Generator + image (Method 2) |
| Hundreds of labels from a list | Batch CSV (Method 3) |
| Print-ready label sheets | Batch CSV with a template (Method 3) |
Common pitfalls
- Forgetting start/stop asterisks with Code 39 fonts.
- Using a font for EAN/UPC — the check digit will be wrong.
- Shrinking the symbol until the bars blur; keep adequate size and quiet zone.
- Low-contrast colors; dark bars on white scan best.
Summary
Use a Code 39 font for quick internal labels, an online generator for correct retail symbols, and batch CSV export for volume. All three keep your data in Excel where it belongs while producing scannable output.
Try it yourself — free, no signup
Generate any barcode or QR code mentioned in this guide, with correct check digits and print-ready export.