Barcode Fonts for Excel & Word
Barcode fonts turn text into scannable symbols right inside your spreadsheet or document. Learn the Code 39 method, the critical start/stop rule, and where to get free fonts — plus when a generator is the safer choice.
Code 39 font simulator
See exactly what a Code 39 font produces — including the start/stop asterisks.
What the font must encode
*BARCODE*The leading and trailing * are Code 39 start/stop characters — a font needs them or the symbol will not scan.
Excel formula
="*" & UPPER(A1) & "*"Put your data in A1, apply this formula in B1, then set B1's font to a Code 39 font.
How barcode fonts work
A barcode font replaces ordinary letter glyphs with patterns of bars. Type a character and the font draws its barcode element instead of a letter. String enough characters together and you get a complete symbol — no graphics software required.
Code 39 is the easiest to use as a font because every character maps to a fixed, self-contained pattern. You only need to wrap the data in start/stop asterisks: *YOUR-DATA*.
Code 128, EAN and UPC are harder: they require computed check digits, guard patterns and (for Code 128) code-set switching. A plain font cannot do that maths, so those symbologies need an encoder add-in — or a dedicated generator like ours.
Code 39 in Excel — 5 steps
- 01
Install the font
Download a Code 39 TTF from a trusted source, right-click and Install (Windows) or double-click and Install Font (macOS). Restart Excel/Word.
- 02
Prepare your data
Put the raw value in A1. Code 39 uses uppercase letters, digits and - . $ / + % space.
- 03
Add start/stop characters
In B1 enter ="*" & UPPER(A1) & "*" so the value becomes *DATA*. Without the asterisks the symbol will not scan.
- 04
Apply the font
Select B1 and choose the Code 39 font. Increase the font size (e.g. 36–48pt) for a taller, more scannable symbol.
- 05
Test-print & scan
Print a sample and scan it with a phone or scanner. Keep white space around the code and avoid shrinking it.
Which should you use?
| Feature | Barcode font | BarcodeForge generator |
|---|---|---|
| Setup effort | Install font + formula | None — type & download |
| Check digits | Manual / add-in needed | Computed automatically |
| Code 128 / EAN / UPC | Requires encoder add-in | Fully supported |
| QR & 2D codes | Not possible | Fully supported |
| Output formats | Whatever the app prints | PNG, SVG, JPG, PDF |
| Best for | Quick internal Code 39 labels | Retail, logistics & print-ready labels |
Trusted free Code 39 fonts
Always download from the official source and check the license before commercial use. After installing, restart Office so the font appears in the list.
IDAutomation Free Code 39
Widely used free Code 39 font with clear licensing for the free variant.
Grandzebu Code 39
A long-standing free Code 39 font and encoder reference.
Barcodes Inc Free Fonts
Free Code 39 and other linear barcode fonts for personal use.
External links open in a new tab. BarcodeForge is not affiliated with these providers; fonts are subject to their own licenses.
Frequently asked questions
What is a barcode font?
A barcode font is a typeface whose glyphs are bar patterns instead of letters. When you apply it to text, each character renders as part of a barcode. Code 39 fonts are the simplest because each character maps directly to a fixed pattern.
How do I use a Code 39 font in Excel?
Install a Code 39 font, put your data in a cell (e.g. A1), then in another cell use ="*" & UPPER(A1) & "*" to add the required start/stop asterisks, and set that cell's font to the Code 39 font. Increase the font size for a taller symbol.
Why does my Code 39 font barcode not scan?
The most common cause is missing start/stop asterisks (*) — the data must be wrapped as *DATA*. Also ensure the text is uppercase, the font size is large enough, and there is white space (quiet zone) around the symbol.
Can I use a font for Code 128 or EAN/UPC?
Not directly. Code 128 needs a computed checksum and code-set switching, and EAN/UPC need check digits and guard patterns — a plain font cannot calculate these. Use a font with a matching encoder add-in, or generate the symbol with our free generator instead.
Are barcode fonts better than a generator?
Fonts are convenient for quick internal Code 39 labels inside Excel or Word. For retail GTINs, Code 128, QR or print-ready output, a dedicated generator is more reliable because it computes check digits and renders to specification.
Where can I get a free Code 39 font?
Reputable free sources include IDAutomation's free Code 39 font and Grandzebu's Code 39 font. Always download fonts from the official site, install the TTF, and restart Office so the font appears in the font list.
Skip the font hassle
Generate Code 39, Code 128, EAN, UPC and QR codes with correct check digits and crisp export — no install, no formulas.