How to make labels from Excel for free
Open warehouse inventory template
You can make labels from Excel with no signup. Open the free label maker. There's no account. Click a column name onto the label, upload the workbook, and print one label per row. If the list is in Google Sheets or a CSV instead, same idea.
How to make labels from Excel with no signup
- Open the free label maker. You won't be asked for an email.
- Set the label size in inches. Add text or a barcode.
- Click a column name, or type {{sku}} where the value should change.
- Upload the Excel file. Preview two rows. Print this for one, or Print for the rows you checked.
That's the afternoon job: a buyer emailed a workbook, and you don't want to type fifty names by hand.
What making labels from Excel actually looks like
Say the sheet has sku, name, and bin. You design the label once. Click sku onto a barcode, name onto a line of text, bin onto a second line. Each row fills those spots. Flip through a short name and a long one so nothing runs off the edge. Then you print.
Print this is the label you're looking at, if one tore. Print is every row you checked, and it asks how many copies of each. Unchecked rows stay in the sheet. They just don't print.
Google Sheets and CSV if the list isn't Excel
Sometimes the list lives in Google Sheets. Publish it as CSV (File, Share, Publish to the web, comma-separated values) and paste the link. A normal share link isn't enough. Sometimes it's a CSV from Shopify or Square. Upload or paste that. Keep the same column names so you don't rebuild the label.
You still didn't make an account. Mac and Windows both work. If you've got a Zebra, print from the browser. If you don't, print from this computer or save a PDF at actual size.
Related: print barcode labels from a spreadsheet · how to print labels from a spreadsheet.
When you're ready to print or save
If a Zebra is plugged in, print from the browser. Set 203, 300, or 600 DPI to match the printer. On a regular printer, choose Print from this computer. You can also download a PNG, a PDF, or the ZPL code a Zebra reads. Save a JSON file if you want to open this label again later, spreadsheet included.