Skip to content
Free tool - no sign-up

Item label maker: paste your items, print barcode or QR labels.

Paste a list of items and print labels on Avery 5160 or 5167 sheets, each with a QR code or a Code 128 barcode, the item name, and the shelf or bin printed as text. It runs in your browser: nothing is uploaded.

1. Your items
Order: Name, SKU or barcode value, Shelf or bin. Only the value is needed: a line with one entry is used as the value. Paste straight from a spreadsheet or type with commas.
6 items, 6 labels on 1 sheet
2. The labels
The code holds the value only. The shelf or bin is printed as text.
US Letter sheets. Labels sold as 5160 or 5167 compatible use the same layout.
Labels fill left to right, then top to bottom.

Print at 100% or Actual size, not Fit to page. Print one page on plain paper first and hold it over a label sheet against a window to check that it lines up.

Nothing is uploaded. The labels are drawn in this browser tab, and it keeps nothing when you close it.

Preview at actual size (this is what prints)
Birch plywood 3/4 inPLY-B34Rack A
Soft-close hinge 35 mmHNG-35SCBin 12
White edge banding 22 mmEB-W22Shelf 3
Wood screw #8 x 1-1/4 inSCR-8114Bin 4
Drawer slide 18 inDS-18FXRack B
Contact cement 1 galADH-CC1Cabinet 2

How to print labels that line up

  1. Use the right sheet. US Letter label sheets in the 5160 or 5167 layout, chosen in the Label sheet box above.
  2. Print at 100%. In the print window, set the scale to 100% or Actual size, not Fit to page or Shrink to fit, and the paper to Letter. A scaled page drifts a little more on every row.
  3. Test on plain paper first. Print one page, hold it over a label sheet against a window, and check that every code sits inside its label.
  4. Scan a test label with the phone or scanner you will use, before printing the rest. The tool warns you when a code is very fine at the label size you picked.
  5. Reuse a part-used sheet. Enter how many labels are already gone from the first sheet, and printing starts at the next one.

What goes in the code, and what goes on the label

The code holds one thing: the item's own value. Use its SKU, or the barcode the maker already printed on it, such as a UPC. The item name and the shelf or bin are printed beside the code as text, for people to read.

Keep the shelf or bin out of the code. Items move: a code that holds a shelf is wrong the day the item moves, and every label for it has to be reprinted. A code that holds only the item's value stays right wherever the item is kept.

Short values print larger and scan more easily, which matters most on the small 5167 labels.

QR code or Code 128

  • QR code: most phone cameras read one, it fits in a small square, and it scans from any angle. Choose it if your team scans with phones.
  • Code 128: the long, thin barcode that laser barcode scanners read. It needs width, so a long value on a small label prints fine bars that can be hard to scan.
  • Both: a camera or a 2D imager scanner reads either one.

Make QR codes in bulk, one label per line

Paste the whole list at once. Every line becomes one label with its own code, so a list of 300 items prints on 10 sheets of 5160 labels, or 4 sheets of 5167.

  1. Copy the columns from your spreadsheet. Put the name, SKU and shelf or bin columns side by side, in that order, then copy them and paste into the box above. Excel and Google Sheets paste each row as one line. Only the SKU column is needed.
  2. Check the count. The line under the box says how many items, labels and sheets the list makes. A first row of headings such as Name, SKU is skipped.
  3. Pick the code and the sheet. The same list makes QR code labels for phones or Code 128 barcode labels for barcode scanners.
  4. Print, or keep a PDF. Most browsers' print window can save the sheets as a PDF instead of printing them.

Each code is drawn from the value on its line: a SKU, a part number or a barcode number you already have. The tool does not make up numbers, and it does not issue UPC, EAN or GS1 numbers; those come from GS1. No SKUs yet? The SKU generator turns item names into SKUs for your list.

It prints label sheets; it does not save each code as a separate image file. One batch holds up to 2,400 labels, copies included, so print a longer list in two batches.

If you would rather print labels from your items

  • Print labels: on the web, select items on the Items page and choose Print labels. It prints a label for each selected item that has a barcode, in a 4 x 6 in or a 2 x 1 in size.
  • Scanning: scan an item with the iPhone or Android app to open it. Scanning is on every plan.
  • Get the list in: import it from a spreadsheet with the CSV import on the web. CSV import is on every plan.

Flat monthly plans from $19/mo, with no per-user fees. Every plan starts with a 7-day free trial, and you won't be charged for 7 days. On the web you pick a plan and enter a card.

Frequently asked questions

Is the item label maker free?

Yes. There is no sign-up and no email is asked for. The labels are drawn in your browser, and the list you paste is not sent to InventoryQuick or stored.

Which label sheets does it print on?

US Letter sheets in the Avery 5160 layout (30 labels of 1 x 2-5/8 in) and the Avery 5167 layout (80 labels of 1/2 x 1-3/4 in). Labels sold as 5160 or 5167 compatible use the same layout.

Why do my labels not line up with the sheet?

Almost always because the page was scaled when it printed. Print at 100% or Actual size, not Fit to page or Shrink to fit, on US Letter paper. Print one page on plain paper first and hold it over a label sheet against a window to check.

What should the code on an item label hold?

The item's own value: its SKU, or the barcode the maker already printed on it, such as a UPC. Put the name and the shelf or bin on the label as text. Items move, and a code that holds a shelf is wrong the day the item moves.

Should I use a QR code or a Code 128 barcode?

Use a QR code if you will scan with phones: most phone cameras read one, and it fits in a small square. Use Code 128 if you have a laser barcode scanner, which reads Code 128 but not QR codes. A camera or a 2D imager scanner reads both.

What happens to an item whose code cannot be made?

It is left off the sheet and listed above the preview with the reason, so no label prints without its code. Code 128 takes only letters, digits and common symbols, with no accents. A QR code on a label holds about 200 letters and digits.

Can I print several copies, or start partway down a used sheet?

Yes. Set the number of copies of each label, up to 30, and the number of labels already used on the first sheet. Labels fill left to right, then top to bottom.

Can I make QR codes in bulk from a spreadsheet?

Yes. Paste the list with one item per line, straight from Excel or Google Sheets, and each line becomes a label with its own QR code or Code 128 barcode, up to 2,400 labels in one batch. Each code holds the value on its line, such as a SKU you already use. The tool does not make up numbers or issue UPC, EAN or GS1 numbers. It prints label sheets rather than saving image files.

More free tools: SKU generator, inventory spreadsheet template, inventory count sheet, reorder point calculator.