How to Print Labels From Excel: Step-by-Step Guide

Learning how to print labels from excel takes about ten minutes once the right steps are clear. Excel's built-in mail merge feature pairs with Microsoft Word to turn any spreadsheet into perfectly formatted labels — no fancy software needed. Whether the goal is mailing holiday cards, organizing inventory, or shipping products with a dedicated label printer, the process follows the same basic workflow every time.

The trick is setting up the spreadsheet correctly before touching Word. A clean, well-organized Excel file prevents 90% of label printing headaches. This guide covers the full process from spreadsheet prep to final print, plus troubleshooting tips for the issues that trip most people up.

Already have contacts stored elsewhere? Check out this guide on how to print address labels from Google Contacts for an alternative starting point.

When Printing Labels From Excel Makes Sense

Not every label job needs a spreadsheet. But once the count goes past a dozen, Excel becomes the fastest path. The mail merge feature was built specifically for this kind of repetitive printing task.

Address and Mailing Labels

Address labels are the most common use case. Think holiday cards, wedding invitations, business mailers, and nonprofit fundraising campaigns. Excel handles the contact list while Word handles the layout.

• Holiday card mailings (50–500 addresses)
• Small business customer outreach
• Event invitations and RSVPs
• Return address labels for personal use

For businesses shipping products daily, a dedicated label printer may save more money than running sheet labels through a standard printer.

Product and Inventory Labels

Excel also works well for product labeling. Home businesses, craft sellers, and small warehouses often maintain inventory in spreadsheets already. Printing labels directly from that data eliminates double entry.

• Jar and container labels for homemade products
• Warehouse bin and shelf labels
• Asset tags for office equipment
• Price tags for retail displays

Need barcodes on those labels? That requires a slightly different approach — here's how to print barcodes on a label printer.

How to Print Labels From Excel Step by Step

This section walks through the complete process of how to print labels from excel using Microsoft Word's mail merge. The steps work in Microsoft 365, Office 2021, and Office 2019.

Step 1: Prepare the Spreadsheet

The spreadsheet is the foundation. Getting it right here saves frustration later.

1. Open Excel and create a new workbook (or open an existing contact list).
2. Put column headers in Row 1 — First Name, Last Name, Street Address, City, State, ZIP Code.
3. Enter one record per row starting in Row 2. No blank rows between entries.
4. Format the ZIP Code column as Text (right-click → Format Cells → Text). This preserves leading zeros for states like Connecticut (06XXX).
5. Save the file as .xlsx format. Close it before starting the merge.

Pro Tip: Always close the Excel file before connecting it to Word's mail merge. An open file can cause connection errors or lock the data source.

Keep column headers simple and consistent. Avoid spaces before or after text, merged cells, or multiple header rows. Word reads only the first row as field names.

Step 2: Set Up Mail Merge in Word

1. Open a blank document in Microsoft Word.
2. Go to Mailings → Start Mail Merge → Labels.
3. In the Label Options dialog, select the label vendor (Avery US Letter is most common).
4. Choose the product number matching the label sheets. Avery 5160 (1" × 2.625") is the standard for address labels.
5. Click OK. The document now shows a grid of label cells.
6. Click Select Recipients → Use an Existing List.
7. Navigate to the saved Excel file. Select the correct sheet (usually Sheet1).

Step 3: Insert Merge Fields and Format

With the data connected, it's time to place fields on the label.

1. Click inside the first label cell (top-left).
2. Go to Mailings → Insert Merge Field.
3. Insert fields in the desired layout. A typical address label looks like this:

«First_Name» «Last_Name»
«Street_Address»
«City», «State» «ZIP_Code»

4. Format the text — set font, size, and alignment. Arial or Calibri at 10–11pt works well for most address labels.
5. Click Update Labels in the Mailings tab. This copies the layout to every label on the page.

Step 4: Preview and Print

1. Click Preview Results in the Mailings tab. Real data replaces the merge field codes.
2. Scroll through to check for formatting issues — long addresses wrapping oddly, missing data, etc.
3. Click Finish & Merge → Print Documents.
4. Print a test page on regular paper first. Hold it behind a label sheet against a light source to check alignment.
5. Load label sheets into the printer tray (face up for most inkjets, face down for most lasers — check the manual).
6. Print the final batch.

Warning: Never run label sheets through a printer twice. The heat from the first pass can loosen adhesive, causing labels to peel off inside the printer and potentially jamming the fuser.

Common Label Printing Mistakes and How to Avoid Them

Even experienced users hit snags. These are the most frequent errors that derail a label print job.

Spreadsheet Formatting Errors

• ZIP codes losing leading zeros. Format the column as Text before entering data. Changing format after entry doesn't restore lost zeros.
• Extra spaces in cells. Use Excel's TRIM function to clean trailing spaces. Formula: =TRIM(A2).
• Blank rows in the middle of data. Word treats blank rows as valid records, producing empty labels in the batch.
• Merged cells anywhere in the data range. Unmerge all cells before connecting to Word.

Label Template Mismatches

Choosing the wrong label template causes alignment to drift progressively across the page. Every label brand has slightly different margins and gutters.

Always match the product number exactly. A 5163 and 8163 are the same size but different materials. Using the wrong template — even by one digit — can throw off margins.

Fixing Label Alignment and Print Issues

Labels printed but not lining up? This section covers the most common fixes.

Alignment Drift Across Rows

When labels start aligned but gradually shift down the page, the issue is usually page margins or label template mismatch.

• Double-check the label product number in Word's Label Options dialog.
• Go to Layout → Margins and set all four to the exact values specified on the label packaging.
• Some printers have a minimum margin they can't print within. Adjust the printer's "fit to page" or scaling to 100% (not "Fit" or "Shrink to Fit").
• Disable any "borderless printing" settings. Label sheets need precise margins.

Text Getting Cut Off

Long addresses or company names sometimes overflow the label boundary. A few quick fixes:

1. Reduce font size. Drop from 11pt to 9pt. Most label text remains readable down to 8pt.
2. Abbreviate state names. Use standard two-letter postal codes (California → CA).
3. Use a condensed font. Arial Narrow fits more text per line without shrinking the point size.
4. Switch to a larger label. If content consistently overflows, move from Avery 5160 (1") to Avery 5163 (2" tall).

For persistent alignment issues, print one sheet and measure the offset with a ruler. Then adjust Word's top and left margins by that exact amount.

Label Printing Costs: What to Expect

Printing labels from Excel through a regular printer is affordable at low volumes. Costs shift at higher quantities.

Sheet Label Costs

A pack of 750 Avery 5160 labels (25 sheets × 30 labels) runs about $12–15. That's roughly $0.016–$0.02 per label for the media alone. Add ink or toner costs and the total lands around $0.03–$0.05 per label on an inkjet, less on a laser.

• Inkjet label sheets cost slightly more than laser-compatible ones.
• Waterproof or weatherproof labels jump to $0.08–$0.15 per label.
• Generic (non-Avery) sheets cut costs by 30–50% with comparable quality.

Dedicated Label Printer Costs

Once volume exceeds a few hundred labels per month, a dedicated label printer often makes more sense. Thermal printers skip ink entirely — heat activates the label coating. The per-label cost drops to $0.01–$0.03 depending on label size.

• Entry-level thermal label printers start around $60–$80 (like the Niimbot B21).
• Mid-range options ($100–$200) handle higher volumes and wider labels.
• No ink cartridges to replace — ongoing costs are label rolls only.

The trade-off: thermal printers can't print color. For plain text and barcode labels, they're ideal. For color-coded or branded labels, stick with an inkjet or laser.

Frequently Asked Questions

Next Steps

1. Set up a test spreadsheet with 5–10 sample addresses, format the ZIP column as Text, and run through the full mail merge process on plain paper before committing to label sheets.
2. Stock up on the right label sheets — confirm the product number matches the template selected in Word, and buy sheets rated for the specific printer type (laser or inkjet).
3. Save the Word merge document alongside the Excel file. Reopening it later reconnects to the data source automatically, making future print runs a two-click process.
4. Evaluate printing volume — for batches over a few hundred labels per month, compare the per-label cost of sheet labels against a dedicated label printer to find the more economical option.