Barcode label generator: print labels from Excel
Turn a spreadsheet into ready-to-print label sheets: one barcode per row with its name and price, as many copies as each row needs, on the label sheet you already have.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: runs in your browser
No file at hand? .
Layout and text
Printer alignment
Print the PDF at 100% (“Actual size”), not “Fit to page”.
| Row | Problem | Content |
|---|
How to print barcode labels from Excel
- Add your list. Choose an Excel or CSV file, or paste the values. Each row becomes a label.
- Say what goes on the label. Pick the column for the barcode and up to three text lines, such as the product name and the price.
- Choose your label sheet. Avery, A4 or roll labels, or your own measurements. The preview shows the first sheet as it will print.
- Create the PDF and print it at 100%. Rows with a wrong check digit or an unsupported character are listed by row number instead of being printed wrong.
What it is used for
- Shop shelves and price tagsProduct name, price and EAN or internal code on every label.
- Stock and warehouseOne Code 128 label per SKU, bin or pallet, with the number of copies taken from your stock column.
- Handmade and small-batch productsLabels for jars, clothing or boxes without buying label software.
- Libraries, schools and officesInventory numbers for books, laptops and furniture.
Label sheets included
- US Letter (Avery)5160/8160 (30 per sheet), 5161 (20), 5162 (14), 5163 (10), 5164 (6) and 5167 (80).
- A4 (Avery)L7651 (65 per sheet), L7159 (24), L7160 (21), L7161 (18), L7162 (16), L7163 (14), L7173 (10) and L7165 (8).
- A4, edge to edgeThe sizes sold by APLI, Herma and store brands: 70 × 37 mm (24), 70 × 35, 70 × 42.4, 105 × 37, 105 × 57, 105 × 148, 52.5 × 29.7, 48.5 × 25.4, 38 × 21.2 and more.
- Label printersOne label per PDF page for thermal and roll printers: 40 × 30, 50 × 30, 58 × 40, 100 × 50 and 100 × 150 mm, 2.25 × 1.25 in and 4 × 6 in.
- Anything elseType the measurements printed on your box: label size, columns, rows, margins and gaps.
Print a test page first
Set your printer dialog to 100% or “Actual size”. “Fit to page” shrinks the sheet by a few percent, and by the last row the print is off by several millimetres.
Print the first page on plain paper with “Print the outline of each label” turned on, and hold it against a label sheet in front of a window. If the whole grid is shifted, enter the difference in “Shift right” and “Shift down”; negative numbers move it left or up. Then turn the outlines off and print on the real sheet.
Checked before you print
Every value is validated for the barcode type you chose: characters, length and check digit. The page also measures how wide the narrowest bar will be on your label. If a long code would need bars thinner than scanners reliably read, the row is flagged so you can choose a larger label or a shorter code.
Private by design
Price lists, stock counts and supplier references stay on your device. Your browser reads the spreadsheet and builds the PDF in a background worker, with no server involved.
Known limits
- Barcodes are validated (characters, length, check digit) and their bar width is checked against the label size, but they are not scanned back. Test one printed label with your scanner before printing the batch.
- EAN and UPC codes are drawn with even-height bars and the digits centred underneath, rather than the traditional layout with longer guard bars. Scanners read them the same way.
- Generating a barcode does not register its number with GS1.
- The templates follow the measurements published for each sheet; they have not been checked against every physical product. Printers also shift by a millimetre or two, so print a test page first.
- Most desktop printers cannot print on the outer 3–5 mm of the paper. On edge-to-edge sheets, the labels on the border keep their content inside a small inner margin, but check your first print.
- Roll formats give a PDF with one label per page. Your label printer’s driver must be set to the same label size; this has not been tested on every printer model.
- Text lines use a standard Western European font. Other alphabets print as “?” in the text, although the QR codes themselves can contain any character.
- The whole PDF is built in memory. A million labels is the hard ceiling for one file, and very large batches depend on the memory of your device.
- Password-protected workbooks must be unlocked first.
Frequently asked questions
Is it really free?
Yes. It is 100% free, with no usage limits, no account, no sign-up, no watermark and no paid plan. There is no cap on rows or labels.
Is my spreadsheet uploaded?
No. Your spreadsheet is read inside your browser and the PDF is built on your own device; nothing leaves it. The page only downloads its own code from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never your files, their names or the contents of your labels.
How do I print barcode labels from Excel?
Choose your Excel file, pick the column with the code and the columns for the text lines, choose your label sheet (for example Avery 5160) and press “Create the label PDF”. Open the PDF and print it at 100% on your label sheet.
Which Avery templates are supported?
US Letter: 5160/8160, 5161, 5162, 5163, 5164 and 5167. A4: L7651, L7159, L7160, L7161, L7162, L7163, L7173 and L7165. For any other sheet, choose “Custom size” and type the measurements printed on the box.
Can I print a different number of labels for each product?
Yes. Add a column with the quantity and choose it under “Copies of each label”. A row with 0 is left out. You can also print the same number of copies of every row.
The print does not line up with my labels. What can I do?
Print at 100% or “Actual size”, never “Fit to page”: scaling is the usual cause. Then print one test page on plain paper with the outlines option on, and hold it against a label sheet in front of a light. If everything is shifted by the same amount, correct it with the horizontal and vertical offsets, in millimetres.
Can I use a sheet that already has some labels peeled off?
Yes. Under “Printer alignment”, set the position of the first label to use, counting from left to right and top to bottom. The preview shows the skipped positions in grey.
Which barcode type should I use?
Code 128 for your own SKUs, stock and shipping labels: it accepts letters and digits and is compact. EAN-13 or UPC-A when the product already has a retail number. Code 39 only if older equipment needs it.
Does it work with a Zebra, Brother or Dymo label printer?
Choose one of the “one label per page” sizes or enter your own: the PDF then has one page per label. Set the same label size in the printer driver and print at 100%. It has not been tested on every model, so try a few labels first.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives your files, your text or the contents of your codes. You can change your choice at any time with “Cookie settings” at the bottom of the page.