Home / Recipes / Microsoft Excel
Label recipe · Easy

How to Print Labels from Excel (No Mail Merge)

Your labels are already rows in Excel: addresses, SKUs, barcode values in tidy columns. So there is no reason to rebuild them in a Word mail merge or an Avery template. Drop the spreadsheet straight into PaperReady, match the columns once, and every row prints at full size on whatever label printer you own.

  1. Tidy the sheet: one row per label, a plain header row (name, address, sku, barcode), and no blank rows between the data. Empty rows print empty labels.
  2. Install the free Print Bridge from /download/. It auto-detects your Zebra, DYMO, Rollo, Brother or MUNBYN over USB or the network, so there is no driver hunt.
  3. Open the app, choose Batch print, and drop your .xlsx (or .csv) straight in. No exporting, no Word. PaperReady reads the header row and lists your columns.
  4. Map each column to a field on the label. PaperReady auto-matches by header name, so an address column lands in the address field and a SKU column can drive a scannable barcode.
  5. Pick your output and print: a thermal roll, one label per row, or an Avery-style sheet, many per page. Every label comes out at true size, 4×6 edge to edge, never scaled onto a letter page.

Print address & mailing labels from Excel

The classic mail-merge job, a column of names and addresses, without Word or a laser sheet. Map your name and address columns and every row prints ready to stick, on a 4×6 thermal roll or an Avery sheet. The dedicated address-label recipe has the layout tips.

Print product, price & barcode labels from Excel

Point the barcode field at your SKU or UPC column and PaperReady turns each value into a scannable Code 128, UPC or QR, no add-on. Format those columns as text in Excel first so leading zeros survive. Need a one-off code that is not in a column? Generate a barcode or QR free at Ohillo and drop it on the label.

Excel, Google Sheets, CSV, or just paste

PaperReady reads .xlsx and .csv files, and you can paste rows straight from a sheet too. Working in Google Sheets? Download as .xlsx, or follow the Google recipe. Same flow, same result.

Why skip Word mail merge and Avery templates

Word's mail merge was built to fill an Avery grid on a letter-size laser printer, so it fights every 4×6 thermal and DYMO: wrong template, content off the label, everything scaled down. Reading the spreadsheet directly and printing at the label's real size sidesteps all of it. Coming from Word? Here is printing labels from Word the clean way.

PaperReady prints straight to your label printer at true size, with no PDF-export-then-reprint step, unlimited labels, and no per-label fees, on Zebra, DYMO, Rollo, Brother and MUNBYN across Windows, Mac and Linux.

Frequently asked

How do I print address labels from Excel?
Drop the spreadsheet into PaperReady's batch printer, map your name and address columns to the label, and print. There is no Word mail merge and no Avery template, and every row prints at true size on a thermal roll or an Avery-style sheet.
How do I print mailing labels from Excel without Word?
Word's mail merge only exists to fill an Avery grid on a laser printer. PaperReady reads your Excel rows directly, so you skip Word entirely and send each row straight to the label printer.
Does it read .xlsx, or do I have to export to CSV first?
It reads .xlsx directly, so you can drop the workbook in as-is with no exporting. A .csv works too. PaperReady reads the header row and lists your columns to map.
Can a SKU or UPC column become a scannable barcode?
Yes. Point the barcode field at that column and every label gets a barcode built from the row's value. Format the column as text in Excel first so leading zeros are not dropped.
Can I print Avery sheets from Excel, not just thermal rolls?
Yes. Choose a sheet layout such as Avery 5160 (30-up) and PaperReady tiles your rows across the page as a print-ready PDF that lands on the die-cuts. Same spreadsheet, either output.
Does the 4×6 print full size or shrink to fit a page?
Full size. The app sends the job straight to the printer and skips the browser print dialog, which is the thing that usually rescales a 4×6 down onto letter paper.
Is printing labels from Excel free?
Designing a label and printing to a local printer is free with no account. Printing a whole spreadsheet in one batch, including the Excel import, is a Pro feature; the free tier covers designing and local printing.

Related recipes