Skip to content

Menu

Bulk barcode generator from Excel

Paste a column or a whole table from Excel or Google Sheets, or open a CSV or .xlsx file, choose which column becomes the barcode and which become the lines above and below, and Picket lays every label out on the sheet you pick: Avery 5160 and its US siblings, Avery Zweckform and HERMA on A4, or 4×6, 2×1 and DYMO thermal labels. The Free plan makes up to 100 labels per PDF with a small credit line in the margin, no sign-up; Pro (US$5 a month) makes up to 5,000, adds ZPL for ZPL-compatible thermal printers and drops the credit line. Rows that cannot be encoded are listed and skipped, and your spreadsheet never leaves the browser.

  • Excel, CSV and Google Sheets
  • Avery, A4 and thermal
  • Nothing uploaded
Picket · Bulk barcodes from 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 bulk barcodes from Excel

  1. 01

    Paste or open your list

    Copy cells from Excel or Google Sheets and paste them, or open a CSV or .xlsx file. A header row is detected automatically.

  2. 02

    Map the columns

    Pick the barcode column and, if you like, a name above and a price or code below, a line that is the same on every label, and how many copies of each.

  3. 03

    Pick the sheet and print

    Choose your label sheet, start halfway down a used sheet if you need to, then download the PDF and print it at Actual size.

Questions

My UPCs lost their leading zero in Excel. What do I do?

Excel stores long numbers as numbers and drops leading zeros or shows them as 5.90123E+12. Format the column as Text, retype or re-import the numbers, and paste again; the tool warns you when it sees shortened numbers.

Why do my labels not line up?

Print at Actual size or 100%, not Fit to page, and pick the exact sheet number printed on the label pack. Turn on Outline each label and print one page on plain paper first to check against the sheet.

Can I print on a thermal label printer?

Yes. Choose a thermal size such as 4" × 6" or 2" × 1" and print the PDF, one label per page. Pro also downloads a ZPL file for printers that explicitly support ZPL; check your printer model before choosing this format.

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.