How to Print Labels from Excel (No Mail Merge Needed)
Learn how to print labels directly from an Excel spreadsheet — no Word mail merge required. The fastest way to turn your data into print-ready labels.
If you have a spreadsheet full of names, addresses, or product data and need to print labels from it, you've probably run into the classic headache: Word's mail merge wizard.
It asks you to link files, match fields, preview records, and deal with formatting that breaks for no obvious reason. For most people, it takes 30 minutes and still doesn't print right.
This guide shows you a faster way — and a way to do it directly, without touching Word at all.
Option 1 — The Traditional Way: Excel + Word Mail Merge#
This is what most guides tell you to do. Here's the short version:
Step 1 — Set up your Excel file
Make sure your spreadsheet has column headers in the first row. Each column should have one piece of information — one column for name, one for street address, one for city, and so on. No merged cells, no blank rows at the top.
Step 2 — Open Word and start a mail merge
Open a blank document in Word. Go to Mailings → Start Mail Merge → Labels. Choose your label size (like Avery 5160 for standard address labels).
Step 3 — Connect your Excel file
Click Select Recipients → Use an Existing List, then find your Excel file. Word will ask which sheet to use.
Step 4 — Insert merge fields
Click inside the first label cell and use Insert Merge Field to add your columns — First Name, Street Address, City, etc. Then click Update Labels to copy the layout to all label cells.
Step 5 — Preview and print
Click Preview Results to check how it looks, then Finish & Merge → Print Documents.
This works, but it has real problems:
- It's fiddly — one wrong click and the formatting breaks
- If your Excel file changes, you have to redo the merge
- Doesn't generate barcodes or QR codes
- Windows-only (Avery Design & Print, at least)
Option 2 — The Faster Way: Paste Your Data Directly#
Labeliy lets you paste your spreadsheet data directly — no file linking, no merge wizard.
Here's how it works:
Step 1 — Copy your data from Excel
Select your header row and all your data rows in Excel. Press Ctrl+C (or Cmd+C on Mac).
Step 2 — Open Labeliy and pick a template
Go to labeliy.com/label-maker. Choose a label template — address label, shipping label, price tag, or any other.
Step 3 — Paste into the data table
In the Data Source section, click the table and paste. Your columns appear automatically. Each row becomes one label.
Step 4 — Match columns to label fields
Tick the Dynamic checkbox next to each element in your label design. That element will pull data from the matching column for each label.
Step 5 — Choose your sheet and print
Select your label sheet (Avery 5160, custom size, or any other), download the PDF, and print.
The whole process takes about 3 minutes once your data is ready.
Which Columns Does Excel Need?#
For address labels, a standard setup looks like this:
| Name | Street | City | State | Zip |
|---|---|---|---|---|
| John Smith | 123 Main St | Austin | TX | 78701 |
| Sarah Lee | 45 Oak Ave | Boston | MA | 02101 |
For product labels or price tags:
| Product | SKU | Price | Barcode |
|---|---|---|---|
| Blue T-Shirt | TS-001 | $24.99 | 8901234567890 |
| Red Cap | CP-002 | $14.99 | 8901234567891 |
Any spreadsheet with headers in the first row works. No special formatting needed.
What About Barcodes from Excel?#
If your spreadsheet has a column with barcode numbers (SKU, EAN, UPC, or tracking number), Labeliy converts that column into a scannable barcode on the label automatically. You don't need a separate barcode generator.
Just add a barcode element to your label design and set it as dynamic — it reads the value from whichever column you point it to.
Common Problems When Printing Labels from Excel#
Labels are cut off or misaligned — Make sure you've selected the correct label sheet size. Even a 1mm difference causes misalignment.
My sheet isn't in the list — Enter the measurements manually. You need: label width, label height, top margin, left margin, horizontal gap, and vertical gap. These are printed on the label sheet packaging.
Some rows print fine, others are blank — Check for empty cells in your Excel data. A blank cell in a required column will leave that field blank on the label.
I have 500 rows — will it print all 500? — Yes. Each row becomes one label. If your sheet has 30 labels per page, 500 rows = 17 pages (with a partial last page).
Printing labels from Excel doesn't have to mean fighting with mail merge. Paste your data, pick a template, choose your sheet, and print — that's the whole process.
Related guides: