How To Print Labels From Excel: Step-By-Step Mail Merge Guide

I spent years wrestling with misaligned labels until I discovered this method. Printing directly from Excel saves hours of manual work and eliminates those frustrating formatting errors.

The secret is using Word’s mail merge with Excel as your data source. It sounds complex, but the workflow is foolproof once you see it in action. I’ve tested this across Excel 2016, 2019, and 365 versions.

You’ll get perfectly aligned labels every time, whether you’re printing 10 or 10,000. The process handles different label sizes, fonts, and even custom designs without breaking a sweat.

Works with any standard label template or custom dimensions. Here’s how to set it up properly from the start.

What Youll Need

Instructions

Here’s the mail merge process I use for perfect label printing every time.

Open your Excel workbook and ensure your data is organized in a clean table format. Each column should represent a field (like Name, Address, City), and each row should contain a complete record. Remove any empty rows or columns to prevent errors during the merge.

Save the file in a location you can easily access. I recommend using .xlsx format for compatibility. Verify that all entries are consistent—no mixed formats in the same column (e.g., ZIP codes as both 12345 and 12345-6789).

Launch Microsoft Word and create a new blank document. Navigate to the Mailings tab, then click Start Mail Merge and select Labels. In the dialog box, choose your label vendor and product number (e.g., Avery 5160). Click OK to confirm.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel file, select the appropriate worksheet, and click OK. You’ll see a prompt to confirm the data range—ensure it matches your table and click OK again.

In the Mailings tab, click Insert Merge Field and add the fields you need (e.g., Name, Address) to the first label. Format the text as desired—font, size, alignment. Word will automatically populate all labels with the same layout.

Use the Preview Results button to check how your labels will appear. If you see misaligned text or missing data, adjust the field placement or return to your Excel file to fix inconsistencies. This step saves time and avoids wasted label sheets.

Click Finish & Merge in the Mailings tab, then select Print Documents. In the print dialog, choose the correct printer and ensure the label sheets are loaded properly. Print a test page on plain paper first to verify alignment.

If the test print looks correct, load your label sheets and print the full batch. For large jobs, print in smaller batches to avoid jams. Always keep a few extra label sheets on hand in case of misfeeds—it happens to everyone.

Tips and Common Mistakes

Small details make the difference between perfect labels and wasted sheets.

Data Cleanup First: In Step 1, don’t overlook the importance of removing empty rows and columns from your Excel file. I’ve seen merges fail because a single blank row in the middle of data caused Word to miscount records. Also, double-check for consistent formatting—mixed ZIP code formats like 12345 and 12345-6789 will create alignment issues in your final print.

Preview Before Printing: The Preview Results button in Step 3 is your best friend. I always catch at least one misaligned field or missing data point during this stage. If you see text running off the label edges, adjust your field placement or font size before printing—this saves both time and expensive label sheets.

Test Print Always: Never skip the test page on plain paper in Step 4. I learned this the hard way after wasting an entire sheet of Avery 5160 labels because my printer’s alignment was slightly off. Even if you’ve printed labels a hundred times before, printers can develop slight shifts over time.

Batch Printing Strategy: For large jobs, break your print run into smaller batches. Printer jams are inevitable, and there’s nothing worse than losing 50 labels to a single paper misfeed. I keep extra label sheets on hand and print in groups of 20-30 at a time to minimize waste.

Frequently Asked Questions

Printing labels from Excel is a breeze with mail merge! 🎯 By following the steps above, you can streamline your labeling process and save time. Now that you’ve mastered the basics, try experimenting with different label templates or fonts to customize your output further.