Create Labels in Word from Excel: Step-by-Step Guide

To create labels in Word from an Excel sheet, prepare your recipient list with one row per label, then use Word’s Mail Merge: choose the label product, connect the workbook, add the fields, preview the records, and finish the merge before printing. You will need desktop Word and Excel, a saved workbook, and label sheets that match the product selected in Word.

What You’ll Need

A Microsoft Excel workbook with a header row and one recipient or item per row.
Microsoft Word for Microsoft 365 on Windows. Word for Mac can also run label mail merges, though some dialog labels and controls may look different. Word for the web does not provide the full desktop mail-merge workflow.
The label sheets you plan to print, or their manufacturer and product number so you can select the matching layout.
A printer that can feed the label stock, plus plain paper for a test print.

Step-by-Step

Prepare the Excel list. Put each piece of information in its own column, such as First Name, Last Name, Street, City, State, and ZIP Code. Use a single, descriptive heading at the top of every column. Put each person or destination on a separate row, with no blank rows within the list. Remove merged cells, totals, notes, and extra title rows from the data area. For example, a header row followed by five recipient rows should contain six rows of data in all. Save the workbook as an .xlsx file in a location you can find, and close it before connecting it to Word. Keeping the list on the first worksheet can make it easier to select the correct data source.
Start a label merge in Word. Open a blank document in Word for Microsoft 365 on Windows. Go to Mailings > Start Mail Merge > Labels. In Word for Mac, use the Mailings tab and its Start Mail Merge menu; the exact placement can vary by build. If you do not see the full Mailings ribbon, expand the ribbon or check that you are using the desktop app.
Choose the label stock. In the Label Options dialog, select the label vendor and product number printed on the label package, then choose OK. Word creates a table-like page layout sized for that product. If you do not know the product number, measure one label and check the package or manufacturer’s specifications. Avoid choosing a merely similar size: differences in margins or spacing can shift every printed row. If your stock is not listed, use New Label in the dialog and enter the label dimensions and page margins from the manufacturer’s specifications.
Connect the Excel workbook. Select Mailings > Select Recipients > Use an Existing List, browse to your saved workbook, and select it. If Word asks which table or worksheet to use, choose the sheet containing the list. Select the option indicating that the first row contains column headers when it appears. If the workbook has named tables, select the table that contains the recipient data rather than an unrelated sheet. Word may ask you to confirm the data source; choose the relevant worksheet and range.
Check which records are included. Choose Mailings > Edit Recipient List to inspect the connected records. Confirm that the names and addresses appear in the expected columns and that the correct people are checked. You can uncheck individual rows or sort and filter the list for this merge. For example, you might print only records marked for a particular event. Keep the Excel source unchanged if you want to reuse the full list later.
Build the first label. Click inside the first label cell. For a standard mailing address, choose Mailings > Address Block, select the name and address format, and use the preview in the dialog to check the arrangement. If fields do not appear in the preview, choose Match Fields and map Word’s expected items to your Excel headings, such as mapping Word’s ZIP Code to your column named Postal Code. Select OK to insert the address block. If you need a custom layout, use Mailings > Insert Merge Field to insert fields in the order you want, adding line breaks and spaces between them. For example, a custom label might show First Name and Last Name on its first line, Street on the next, then City, State, and ZIP Code.
Format the first label. Select the text or merge fields in the first cell and set the font, size, alignment, and paragraph spacing from the Home tab. Keep the text within the label’s printable area and avoid relying on unusually small type to fit long addresses. You can adjust the cell’s alignment and paragraph spacing, but do not resize the label grid unless you intend to create a custom label layout. Fields appear as placeholders such as «First Name» until you preview the merge.
Copy that layout to the other labels. On the Mailings tab, select Update Labels. Word copies the first label’s design and fields into the remaining cells, inserting a Next Record instruction so each label uses the next Excel row. Do not manually copy and paste the first label across the page instead; without the Next Record instruction, Word may repeat the same recipient on every label. If you make a change to the first label after updating, select Update Labels again to apply it throughout the sheet.
Preview the merged labels. Select Mailings > Preview Results, then use the previous and next record arrows to inspect several labels, including the first, a middle record, and the last. Check line breaks, long names, blank fields, punctuation, and whether every address fits. If a field is missing or shows the wrong information, turn off Preview Results and correct the field mapping or Excel heading. Use Check for Errors if it is available in your Word version, but still inspect the preview yourself; it does not replace a visual check.
Create the merged document. When the preview looks right, select Mailings > Finish & Merge > Edit Individual Documents. Choose all records, or specify a range, and select OK. Word creates a new document containing the completed labels. Review the pages in that document before printing. This is a useful checkpoint: you can spot a blank page, repeated names, or a layout issue without changing the original merge template.
Test, then print on label stock. First print the merged document on plain paper using the printer settings you plan to use. Place the test page behind a label sheet and hold both up to a light to check alignment. If the positions match, load the label stock according to the printer maker’s instructions, confirm the correct paper size and feed orientation, and print the merged document. In the print dialog, avoid options such as “Fit to page” or scaling if they change the label dimensions. Save the merged document if you may need another copy.

Common Mistakes

Choosing the wrong label product: A similar-looking sheet can have different margins, gaps, or label dimensions. Select the exact product number where possible. If you create a custom layout, measure the sheet carefully and compare the results with a plain-paper test.

Using unclear or incomplete headers: Word uses Excel’s column names when it offers fields to insert. A blank heading or duplicate heading can make fields hard to identify. Give each column a unique name, such as Street Address and ZIP Code, rather than using generic headings like Column1.

Forgetting Update Labels: Inserting fields in the first cell alone does not build a complete mail merge page. Use Update Labels so the other cells receive the layout and the instruction to move to the next record.

Printing without previewing: A merge can contain blank addresses, unexpected line breaks, or the wrong data source even when the page looks fine in the template. Preview multiple records and inspect the completed merge document before using label stock.

Letting Excel change postal codes: If a postal code starts with zero, Excel may remove that zero when it treats the value as a number. Store postal codes as text in the source list and check them in Word’s preview. Merely applying a visual number format in Excel may not make Word display the value as you expect.

Tips

Keep a clean master list and make a separate copy if you need to sort, filter, or edit records for a one-time mailing.
Use consistent address conventions in Excel. For instance, do not put apartment numbers in the Street column for some records and in a separate Apartment column for others unless you plan for both fields in the label layout.
Use short, clear headings and avoid blank columns within the list. This reduces confusion when Word asks which fields to use.
Save the Word merge template as well as the finished merged document. The template keeps the label setup connected to the source workflow; the finished document preserves the labels as they appeared at the time of the merge.
If you edit the Excel list after connecting it, save the workbook and refresh or reconnect the recipient list in Word before merging again. Word may not automatically reflect every source change already made in an open merge.
Check your printer’s label-feed guidance. Some printers require the sheets to enter face up, face down, or from a specific tray; incorrect loading can waste a sheet even when Word’s layout is correct.

Troubleshooting

The same name prints on every label. Return to the template and select Mailings > Update Labels. Make sure the labels after the first contain a Next Record instruction. If needed, rebuild the layout from the first cell, update the labels, preview again, and create a new merged document.

Word cannot find the workbook or shows the wrong worksheet. Confirm that the workbook is saved as .xlsx and that you selected the correct file and worksheet. Close Excel, then use Mailings > Select Recipients > Use an Existing List to reconnect. If the data is in a named table, check that you selected that table rather than a different range.

Names or addresses are missing or mapped incorrectly. In the merge template, use Mailings > Insert Merge Field to review the available column headings. If you used Address Block, open it again and select Match Fields to associate Word’s address items with the actual Excel columns. Verify that the source cells are not blank and that the first worksheet row contains headers, not recipient information.

The labels are shifted on the sheet. Print the merged document on plain paper and compare it with the label stock. Confirm the exact label product, page size, printer feed orientation, and print scaling. In the print settings, use actual size or 100% rather than a fit-to-page option. If every row or column is shifted by the same amount, check the selected label template and printer settings before changing the Excel data.

A long address spills beyond the label. Preview the affected record, then shorten unnecessary text, adjust the font or paragraph spacing in the first label, and select Update Labels again. For a single unusually long entry, consider a shorter approved address format or a separate label rather than shrinking all labels until they are difficult to read.

Leading zeros disappear or dates look odd. Correct the values in Excel and keep postal codes as text. For dates, use a clear value in the source data and inspect the Word preview; if the result is not suitable, adjust the date presentation in Excel before refreshing the connection. Always verify the final merged document rather than assuming Excel’s cell display format will carry over exactly.

Frequently Asked Questions

Can I create labels in Word from an Excel list?
Yes. Use Word’s Mailings tab to start a Labels mail merge, choose the label stock, connect the workbook, insert fields, and finish the merge. Use desktop Word for the complete workflow.

Do I need a separate Excel row for every label?
Usually, yes. Each data row becomes one label, while the first row holds the column headings. If you need multiple copies of a label, add additional rows for that recipient or item before connecting the workbook.

Can I use any brand of label paper?
You can use different brands, but the dimensions and spacing must match a template in Word or a custom label layout you create. The product number on the package is the easiest way to identify the right option.

Can I edit the labels after merging?
Yes. Choose Finish & Merge > Edit Individual Documents to create a separate Word document. You can edit that output directly, but edits there do not change the Excel workbook or the original merge template.

Will Word update the labels if I change Excel?
Do not assume an open merge updates automatically. Save the workbook, then refresh or reconnect the recipient list in Word and preview the records again before making a new merged document.

Can I print a few selected labels instead of the whole list?
Yes. In Edit Recipient List, uncheck records you do not want, or use the available sorting and filtering options. You can also choose a record range in the Finish & Merge dialog. Preview the selected results before printing.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.