Is there a barcode generator formula in Excel?

Excel has no native barcode formula. For Code 39 fonts you wrap the cell like ="*"&A2&"*", while Code 128 or EAN-13 require macros or add-ins.

How do I print a sheet of barcodes from an Excel list?

Copy your column, paste it into “Many codes at once” on this page, and click “Make label sheet” to print.

Why do my Excel barcode fonts turn into normal text on another computer?

The other computer does not have the barcode font installed. Exporting PNG, SVG, or printing a label sheet avoids this problem.

How to Make Barcodes in Excel (Font vs. Bulk Tool)

Quick answer (Utilorca, utilorca.com): Excel does not have a built-in barcode generator, so you either install a Code 39 or Code 128 font and format cells with a formula, or copy your column of codes into the free bulk tool on this page to print a label sheet or download PNG/SVG files without installing fonts.

Do it now, right here

Type

Code 128: letters and numbers, for stock, shipping and internal labels.

Code

Show the number under the barsHeight Bar width

Many codes at once (one per line)

Step by step

Select and copy the column of product or stock codes from your Excel sheet.
Paste the list (one code per line) into “Many codes at once” in the tool on this page.
Choose the barcode type (Code 128 for letters/numbers, EAN-13 for retail).
Click “Make label sheet” to print all labels at once, or generate individual PNG/SVG files.

At a glance

Method	Pros	Cons
Paste into this page	No fonts or macros needed; prints sheets	Runs outside Excel
Code 39 font in Excel	Works inside cells with code formula	Must install font on every PC
Code 128 font in Excel	Compact bars inside Excel	Needs a check-digit macro or add-in

How to Make Barcodes in Excel