How to print labels from Excel
You can print labels from Excel without mail merge in Word. Upload the workbook in the free label maker, click the column names onto the label, and print the rows you checked. The file stays in this browser. No signup.
How to print labels from Excel
- Open https://app.mylabelmaker.com. No signup.
- Set the size. For shelf tags, a 2 x 1 label is enough. For addresses, open a 30252 or a 5160.
- Upload the .xlsx. The first row must be the column names.
- Click Item onto the big line, Price under it, and SKU onto a barcode.
- Check the rows. Print sends those labels. Print this reprints the one on screen.
A hardware counter has 60 bins to retag. The workbook is already named Item, Price, and SKU. You are not rebuilding it. You are putting those three words on a label that is the size of the stock in the printer.
| Item | Price | SKU |
|---|---|---|
| 3/8 hex bolt | 0.42 | SKU-1042 |
| 1/2 hex bolt | 0.58 | SKU-1043 |
| Lock washer | 0.18 | SKU-1101 |
The workbook never has to leave this computer
Upload it. There is no account to save it into. If a cell has a comma, Excel already handled that when you saved the file. Click a column and it lands on the label. You can also type the column in curly braces, like {{Price}}, if you would rather place it by hand.
Check a short name and a long name before you print the stack, so a 40-character bolt name does not run off a 2 inch label. Then check the 60 rows and print.
DYMO and Brother use Print from this computer, with the driver set to that size and scaling off. A 4x6 DYMO label needs a LabelWriter 4XL. A Zebra printer uses Zebra Browser Print, once, and a full browser restart after you install it.
The shorter page is print from Excel. A CSV export of the same sheet is print labels from a CSV.
Questions people ask
How do I print labels from Excel?
Open the free label maker, upload the workbook, click a column name onto the label, check the rows, and print. One row becomes one label. No signup.
Does Excel have to be installed?
You upload the .xlsx file. The labels are made in the browser. You do not need Word, and you do not need Excel to be open while you print.
Can one Excel row fill a whole Avery sheet?
Each row prints as its own label. Open the 5160 sheet template when you want to design the letter page itself.