CSV BARCODE GENERATORFree browser tool · No account
LOCAL TO YOUR BROWSER

Barcode Font for Excel

Code 39 in Excel needs start and stop asterisks around uppercase input. Download a properly licensed Code 39 font, format source IDs as text and scan a paper proof before using the labels.

01 / One barcode

02 / Batch input

or import a CSV · first column: value, second: optional label

Add values to build your label sheet.

    03 / Print labels

    Print at 100% / actual size. To export a PDF, choose “Save as PDF” in the browser print dialog.

    Avery 5160: 2⅝ × 1 in labels on US Letter, 3 columns × 10 rows. Page offset shifts the sheet from the template origin; see print notes below.

    Build the formula in Excel

    1. Get a Code 39 font from a source whose license allows your intended use. The Libre Barcode 39 project is one option; downloading a font is a separate choice and this page loads no font remotely.
    2. Format column A as Text before entering IDs, particularly values such as 00042. In B2 enter ="*"&UPPER(A2)&"*" and fill down.
    3. Apply the installed Code 39 font to column B. Use uppercase letters, digits, spaces and - . $ / + % only. Print at 100% and scan a proof.

    For example, BOX-0042 becomes *BOX-0042*. The asterisks are Code 39 start and stop characters, not part of the decoded value. A bare Code 128 font will not work this way: Code 128 needs code-set selection and a calculated symbol checksum.

    Download a small CSV example. Excel may treat CSV formulas as active formulas. Open only files you trust; enter the formula yourself for untrusted data.

    Related tools