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 Zebra and Rollo 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.
For example New, a price or your shop name.
1" × 2⅝", 30 per sheet. Address labels, Amazon FNSKU labels.
1 to 30, counting across then down. For a half-used sheet.

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.

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 that Zebra, Rollo and most thermal printers print natively.

Is my data uploaded?

No. Picket makes the barcodes and the PDF in your browser. Your numbers and your 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.