Set up your spreadsheet with one address per row

Excel can print address labels if your data is organized the right way: one complete address per row, with each part of the address in its own column. Open your spreadsheet and arrange it so that the first name goes in column A, last name in column B, street address in column C, city in column D, state in column E, and ZIP code in column F. If you already have all the address information crammed into one cell per person, you will need to split it into separate columns first — Excel's Text to Columns feature can do this if the data is separated by commas or another consistent character.

Make sure your data starts in row 2, leaving row 1 for headers like "First Name," "Last Name," "Street," "City," "State," and "ZIP." This keeps your spreadsheet organized and makes it easier to see what you are working with. If you have 50 addresses, you should have 50 rows of data plus the header row.

Key Takeaways

  • Organize your spreadsheet so each part of the address (first name, last name, street, city, state, ZIP) sits in its own column, with one complete address per row.
  • Use the Mail Merge feature in Word, not Excel itself, to actually print labels — Excel holds the data, but Word handles the label layout and printing.
  • You can buy label sheets that match standard label templates (like Avery 5160 for standard address labels) and tell Word which template you are using so it formats correctly.
  • Test your merge on a blank sheet of paper first to make sure addresses land in the right spots before you print on actual label stock.

Use Word's Mail Merge feature to connect Excel data to label templates

Excel does not have a built-in label printing tool, but Microsoft Word does — and Word can pull addresses directly from your Excel file. Open Word and go to the Mailings tab. Click Start Mail Merge, then select Labels from the dropdown. A dialog box will ask you to choose a label vendor and product number. If you bought Avery 5160 labels (the most common size for address labels), select Avery and then 5160 from the list. Word will show you a preview of the label size and layout.

After you choose your label template, Word will ask you to select your data source. Click Select Recipients, then Use an Existing List, and navigate to your Excel file. Word will open a dialog showing the sheets in your workbook — select the sheet that holds your addresses. Word will then display a preview of your data to confirm it recognized the columns correctly.

Insert merge fields into the label template

Once Word has connected to your Excel data, you are looking at a blank label template. This is where you tell Word which pieces of information go where on each label. Click in the top-left label area and then go to Insert Merge Field (still in the Mailings tab). A dropdown will show you all the column headers from your Excel spreadsheet — click the one you want to insert, like "First Name." Word will insert a placeholder that looks like <<First Name>>.

Build out the label by inserting fields in the order they should appear. Type a space or line break between fields as needed. For a standard address label, you might insert First Name, a space, Last Name, then press Enter, then Street, then Enter, then City, a comma, a space, State, a space, and ZIP. When you are done with the first label, Word will automatically copy this layout to all the other labels on the sheet.

Preview the merge and test on blank paper

Before you print on actual label stock, preview what the merged labels will look like. In the Mailings tab, click Preview Results. Word will show you what the first label looks like with real data from your Excel file. Use the arrow buttons to flip through a few labels and check that the addresses are formatted the way you want them. If something looks wrong — like an address running off the edge of the label or fields in the wrong order — go back and edit the template.

Print a test copy on regular white paper first. Load a blank sheet into your printer, go to File > Print, and print just the first page. Hold it up to a label sheet to see if the text lands where it should. If the addresses are off-center or too close to the edge, you can adjust the merge field positions in the template before printing on the actual labels.

Print the labels on your label stock

Once the test looks right, load your label sheets into the printer. Go to File > Print. If you have 50 addresses and each label sheet holds 30 labels, you will need to print two sheets. You can print all labels at once or specify a page range — Word will tell you how many pages the merge will create. Click Print and watch the first sheet come out to make sure the printer is feeding the labels correctly.

If you are printing a large batch, print one sheet, let the ink dry for a few seconds, and then load the next sheet. Label stock can sometimes stick together if the ink is still wet, so a short pause between sheets prevents jams.

Troubleshoot common problems

If Word says it cannot find your Excel file, make sure the file is saved and closed before you start the mail merge. Word sometimes has trouble reading files that are still open. If the addresses are not showing up in the preview, go back to Select Recipients and re-choose your data source — Word may not have recognized the sheet correctly the first time.

If some addresses are missing or appear in the wrong order, check your Excel spreadsheet for blank rows or extra spaces in the data. A blank row in the middle of your address list can confuse Word's merge. If a label is printing blank, that usually means the corresponding row in Excel is empty — go back and fill it in or delete the empty row.

If the text is too large or too small for the label, you can adjust the font size in the template before printing. Select all the merge fields in one label, change the font size, and Word will explore it to all labels when you merge.

Frequently Asked Questions

Can I print labels directly from Excel without using Word?

No. Excel does not have a label printing feature. You must use Word's Mail Merge tool, which is designed to pull data from Excel and format it for labels, envelopes, or letters. This is a built-in feature in Microsoft Office and does not require any extra software.

What if I do not have Microsoft Word, only Excel?

If you have only Excel, you can still print labels by exporting your data and using a free online mail merge tool or a third-party label printing program. Google Docs also has a mail merge feature that works similarly to Word. Alternatively, some label manufacturers like Avery offer free online tools where you upload your Excel file and they format the labels for you.

Do I have to buy Avery labels, or can I use any label stock?

You can use any label stock, but you need to know the template size. If your labels are not Avery brand, look for the product number or dimensions on the box and search Word's label templates for a match. If you cannot find an exact match, you can create a custom label size in Word by going to Mailings > Label Options and entering the measurements yourself.

What happens if I have more addresses than fit on one label sheet?

Word will automatically create multiple pages. If you have 50 addresses and your label sheets hold 30 labels each, Word will create two pages — the first with 30 labels and the second with 20. Print each page on a separate label sheet. You can also choose to print only certain pages if you want to reprint just a few labels.

Can I edit individual addresses after the merge without changing the Excel file?

You can, but it is not recommended because the changes will not save back to Excel. If you need to fix an address, it is better to go back to your Excel file, make the correction there, and re-run the merge. This keeps your data source accurate for future use.