Skip to content

Menu

Barcodes from Excel, without a barcode font

Copy the column from Excel and paste it into the tool above, or open the .xlsx or CSV file, choose the barcode type, and Picket turns every cell into a barcode you can print on label sheets or thermal labels. There is nothing to install, no barcode font and no formula: the check characters of Code 128, UPC and EAN, which a font alone cannot add, are worked out for you. The Free plan prints up to 100 labels per PDF with no sign-up, and Pro (US$5 a month) goes to 5,000 with ZPL for thermal printers. The barcodes come out as a PDF for printing, not inside the workbook; for one barcode in a cell, download it as a PNG from Single barcode and insert the picture.

  • No font or add-in
  • Check digits worked out
  • Nothing uploaded
Picket · Barcodes in Excel
Paste a column or a table from Excel or Google Sheets, or type one value per line.

Turn off for address, name and file labels with text only.

For example New, a price or your shop name.
Quantity column: whole numbers 0–1000; 0 skips the row, blank uses the default.
1" × 2⅝", 30 per sheet. Also 5260, 5520, 5660, 8460, 18160 and the other 5160-family numbers. Address labels and Amazon FNSKU labels (30-up).
1 to 30, counting across then down. For a half-used sheet.

Leaves 0.25" on the sides and 0.125" above and below the barcode and text, as Seller Central asks for item labels.

Print one sheet on plain paper first and hold it against a label sheet to check the fit.

Sample data · 0 labels on 1 page
Loading the barcode engine…

Print at Actual size (100%), not Fit to page, so the labels line up. Free PDFs carry a small credit line in the bottom margin.

Made in your browser with bwip-js and fflate; nothing you enter is uploaded. Open-source licenses

How to use the barcodes in Excel

  1. 01

    Copy the column in Excel

    Select the cells, with the header row if there is one, and copy them; or open the .xlsx or CSV file here.

  2. 02

    Paste and pick the type

    Code 128 for SKUs and serial numbers, UPC-A or EAN-13 for retail numbers. Other columns can go above or below each barcode.

  3. 03

    Print the PDF

    Pick your label sheet or thermal label, download the PDF and print it at Actual size.

Questions

Why does my barcode font not scan?

Code 128 and the retail barcodes need start and stop characters and a check character that a font cannot calculate, so text typed in a Code 128 font usually does not scan without a formula or macro. Code 39 fonts scan only with an asterisk at each end. Pasting the column here does all of that for you.

My numbers show as 5.90123E+12 or lost their leading zero.

Excel stores long numbers as numbers. Format the column as Text, retype or re-import the numbers, and copy again; the tool warns you when it sees shortened numbers.

Does it work with Google Sheets or Numbers?

Yes. Copy the cells and paste them, or export the sheet as .xlsx or CSV and open it here.

Is my data uploaded?

No. Picket makes the barcodes, labels and the PDF in your browser. Your numbers, addresses and spreadsheet never leave your computer.

Do I need an account?

No. Everything on the Free plan works without signing up. You only need an account, with a verified email address, to subscribe to Pro (US$5 a month).

Barcodes and label sheets from a spreadsheet, made in your browser

The Free plan makes single barcodes and up to 100 labels per PDF, with a small credit line in the page margin. Pro is US$5 a month.