How to print warehouse labels from Google Sheets or Excel

Aisles, bins, SKUs. The spreadsheet you already keep.

← Back to Blog

How to print warehouse labels from Google Sheets or Excel

Published: · 7 min read · How-to
Sit down and try it: app.mylabelmaker.com. No account. Make one label tonight, or print a whole list from Excel or Google Sheets when you need it.

Open warehouse inventory template

You can print warehouse labels from Google Sheets or Excel with one design and a label for every row. Open the free label maker, click bin or sku onto the label, load the sheet, and print. CSV is the same idea. You don't retype locations, and you don't buy extra software to use a spreadsheet.

Good to know: Publish a Google Sheet as CSV. A regular share link won't load. We don't connect to your warehouse system. The sheet is the list. We print it.

How to print warehouse bin labels from a spreadsheet

  1. Set the label to the bin tag size and the printer DPI.
  2. In the free label maker, click column names onto text and a barcode.
  3. Paste a published Google Sheet URL, or upload Excel or CSV.
  4. Preview a short location and a long one. Check the rows. Print, or Print this for one reprint.

If you already keep the warehouse in a sheet, you're not missing a special database. You're missing a way to print it. mylabelmaker is that: you load the sheet and print the labels.

Keep warehouse labels in Google Sheets or Excel

Locations live in a sheet. Cycle counts live in a sheet. Receiving lives in a sheet. Three people may still be editing Google Sheets while you print. Excel is what someone emailed. CSV is what almost every export already is. Load whichever you have. The first row has to be column names, not data.

Print only aisle B without reprinting the whole warehouse

Open Edit row. Search. Check aisle B. Leave the rest unchecked. You only flip through the rows you checked, so what you see is what prints. Unchecked rows stay loaded for later. Print this still reprints one torn tag even if that row isn't in the big run. If bins fall off and you need two of each, type 2 for copies.

Make warehouse barcodes that actually scan

Use a real barcode, not an Excel font. CODE128 for internal codes. Leave a little quiet space around the bars. Match DPI. Print one test and scan it before you use a whole roll. Data Matrix if the tag is tiny. QR if a phone should open a location page.

Add serial numbers or dates on top of the spreadsheet

If the sheet has no serial column, add numbers with the Number tool. Each row gets the next value. After a Zebra print works, the start number moves forward so the next run doesn't repeat. Dates from the Date tool stamp today or use-by on every copy of that run. If the sheet already has packed or expiry columns, put those names on the label instead.

Save the design so night shift opens the same label, checks a different aisle, and prints. They shouldn't rebuild the barcode.

ZPL when the warehouse has another print program

Copy ZPL for the current label, or download files if a queue wants them. Paste an old job in the ZPL viewer to see it, then print that job to the Zebra. Design and code stay in one app so nobody is hopping between three websites at 2 a.m.

ZebraDesigner 3 won't take a live Google Sheet. Essentials won't print from Excel. If the warehouse list is a spreadsheet, this is a straightforward way to get tags. More: use Google Sheets with ZebraDesigner 3 · free industrial labels from Excel.

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.

Print the warehouse sheet

Bins and SKUs. One row each.

Open free label maker