Lanternbench

LabelQuick

How to print price labels from Excel on A4 or US Letter sheets

LabelQuick turns a product list into price and barcode labels on adhesive label sheets. It is free, and your file stays on your computer.

Updated

What you need

  • An Excel (.xlsx, .xls) or CSV file with one product per row. The useful columns are name, price, barcode and quantity. Quantity is the number of labels each product gets.
  • One of the three label sheets LabelQuick supports. They are listed in step 4.
  • A printer and the free LabelQuick extension. The install links are at the end of this page.
  • No file yet? Try the steps with the sample file, linked at the end of this page.

Print your labels in seven steps

  1. Install LabelQuick and open it with its toolbar button.
  2. Import your file: drop it on the page, or use the Choose file button.
  3. Check the column matching. LabelQuick guesses which columns hold the product name, price, barcode and quantity. Change a wrong guess in its menu, then choose Continue. If your Excel file has several sheets, pick the one with your products next to Sheet:.
  4. Choose the label sheet. Under Label sheet, pick Avery L7160 (A4, 21 labels per sheet), Avery L7651 (A4, 65 mini labels per sheet) or Avery 5160 (US Letter, 30 labels per sheet). Only these three sheets are supported today. Under Show on label, tick Product name, Price and Barcode as you need them.
  5. Preview the first sheet. The First sheet preview shows how the labels will print. Check the names and prices.
  6. Using a partly used sheet? Set Start at label to the first free position. Labels are counted from left to right, then top to bottom.
  7. Print. Choose Continue to print, then Print labels. In the print window, pick your printer, or pick the PDF option to save a file instead.

Print settings that keep labels aligned

  • Print the calibration page first, on plain paper. On the Print step, choose Print a calibration page. With a ruler, the horizontal line must measure 100 mm. Hold the page against a label sheet to check the first label.
  • Scale: "Default" or 100%. Never "Fit to printable area" and never "Fit to paper".
  • Paper size: the same as your sheet, A4 or US Letter. Choose it yourself, because a different size shrinks every label.
  • Margins: Default or None, not Minimum.
  • Headers and footers: off.

If something looks wrong

  • Barcodes show 2.01E+12, or lose a leading zero. Excel stored the barcodes as numbers, and a CSV file saved from Excel keeps only the short form Excel shows. LabelQuick warns you before printing. Keep every barcode digit in Excel shows how to open the file safely and what to do when digits are already lost.
  • A price is wrong. LabelQuick reads 12,50 and 12.50 as the same price. If a price still prints differently from your file, set Price display to As in spreadsheet. The price then prints exactly as the file shows it.
  • Labels are shifted. Print the calibration page and go through the print settings above. Then check that the sheet you chose in LabelQuick is the sheet in your printer.

Get LabelQuick

Install the free extension for Chrome, Edge or Firefox.

These sizes match Avery® L7160, L7651 and 5160 or 8160 sheets. LabelQuick is independent and not made, sponsored or endorsed by Avery Products Corporation. Print a test page on plain paper before you use label stock.