Codalo.

Barcodes from Excel

Import your Excel or CSV file and every row becomes a label with its barcode. No special fonts, no macros, no add-ins.

Codes

Optional: label text after a tab or “;”. You can paste two columns from Excel.

    Label sheet

    To reuse partly used sheets
    Handy for a test on plain paper
    Preview: page 1 —

    When printing, choose actual size / 100% (not “fit to page”) so it lines up with the label sheet.

    How it works

    1. Put the code in the first column of your spreadsheet. Optionally, put the text you want on the label in the second column (product name, location…).
    2. Click Import Excel / CSV and choose the file. The first sheet is read.
    3. Pick the barcode type and label template, and check the preview.
    4. Download the PDF and print at 100%.

    You can also copy both columns in Excel and paste them straight into the codes box.

    A (code)B (text, optional)
    5012345678900M6 × 20 screw
    5012345678917M6 nut
    50123456789246 mm washer

    Supported files

    Excel (.xlsx and .xls), LibreOffice (.ods) and text files (.csv, .tsv, .txt). For CSV files the separator (comma, semicolon or tab) is detected automatically.

    Why not do it in Excel itself?

    You can, but you'll need to install a barcode font and add start/stop characters, or calculate check digits with formulas or macros. Get one detail wrong and the barcode looks right but won't scan. Here every code is generated to the standard with its check digit, and you see instantly which rows aren't valid.

    Frequently asked questions

    My spreadsheet has a header row. Is that a problem?

    It's read like any other row. If the header isn't a valid code for the chosen format (EAN-13, for example), it's skipped with a warning. In Code 128 it would be valid, so delete it from the text box after importing.

    My UPC/EAN codes lose their leading zeros

    Excel treats codes as numbers and drops leading zeros. Format the column as Text before typing the codes, or save the file as CSV.

    Is my spreadsheet uploaded anywhere?

    No. The file is read inside your browser and never leaves your computer.