Create Labels in Word From an Excel File

To create labels in Word from an Excel file, prepare a saved address list, then use Word’s Mailings tab to start a Labels mail merge, connect the workbook, insert and update the label fields, preview the results, and print. You will need the label package’s product number or measurements so the layout matches the sheets in your printer.

What You’ll Need

A desktop version of Microsoft Word and an Excel workbook with one recipient or item per row. Word for the web does not provide the desktop mail merge tools needed to build and print a label merge.
A label sheet or its packaging, including the manufacturer and product number. If the product is not listed in Word, you will need the label dimensions and page margins.
A printer that can feed the label stock, plus plain paper for a test print. Check the printer manual if you are unsure which tray or feed direction to use.

Step-by-Step

Arrange and save the Excel list. Put one recipient on each row, with one kind of information in each column—for example, First Name, Last Name, Street, City, State, and Postal Code. Use a single header row at the top, with a different heading for each column. Remove completely blank rows above or within the list, merged cells, and totals. Save the workbook as an .xlsx file in a location you can find. Close Excel before connecting from Word to reduce the chance of a file-access prompt.
Protect information that Excel might change. Postal codes, account numbers, and other values that may begin with zero should be stored as text. If Excel has already removed a leading zero, changing the cell format will not restore it; correct the value in the source data first. Check that names and addresses are spelled correctly and that each field is in its own column. Word uses the first row as field names, so do not put a title or a decorative blank row above the headers.
Start a label merge in Word. Open a blank document in the desktop Word app. On Windows, select Mailings > Start Mail Merge > Labels. In the Label Options dialog, choose the label vendor and product number printed on the package, then select OK. Word creates a page laid out as a table of label-sized cells. On Mac, use the Mailings tab and the corresponding Start Mail Merge and Labels commands; dialog wording or placement can differ slightly by Word version.
Choose the correct label layout. Match the product number exactly, not just the brand. If your label stock is not listed, select New Label in Label Options and enter the measurements from the manufacturer, including label width and height, page size, top and side margins, and horizontal and vertical pitch (the distance from one label’s starting edge to the next). Save the custom definition and select it. An approximate match can shift every row, even if the first label looks right.
Connect the Excel workbook. In Word, select Mailings > Select Recipients > Use an Existing List. Browse to the saved workbook and open it. If Word asks you to choose a table or worksheet, select the sheet containing the list and confirm that the first row contains column headers when that option appears. If the workbook has multiple sheets, make sure you select the one with the recipient data, not a notes or lookup sheet.
Insert the address information in the first label. Click inside the top-left label cell. For a standard postal address, choose Mailings > Address Block, select the format you want, and use Match Fields if Word has not matched a field such as Postal Code or Last Name. Review the preview in the dialog before confirming. For a custom arrangement, use Mailings > Insert Merge Field to add individual fields, typing spaces and pressing Enter between fields as needed. For example, place First Name, a space, and Last Name on the first line, then Street on the next line.
Copy the layout to every label. Once the first label is formatted, select Mailings > Update Labels. Word fills the other cells with the same layout and adds a Next Record instruction so each label uses the next row of Excel data. Do not manually copy and paste the first label across the page: without the record-advance instruction, the same recipient can repeat on every label. If Update Labels is unavailable, click in the first label and confirm that you started a labels mail merge.
Preview the labels. Select Mailings > Preview Results. Use the navigation arrows on the Mailings tab to check several records, including the first and last. Look for missing fields, unwanted blank lines, split addresses, truncated text, or repeated recipients. If a field is blank for some people, check the corresponding Excel column and revise the layout if needed. Turn Preview Results off to edit the merge fields or their spacing.
Complete the merge and print a test. Select Mailings > Finish & Merge > Edit Individual Documents, then choose all records or the range you need. Word creates a new document containing the merged labels; inspect it before printing. Select File > Print and print one page on plain paper first. Hold the test sheet behind a label sheet toward a light to check alignment. If it matches, load the label stock as directed by the printer and print the merged document. Avoid options such as Fit to Page or Scale to Paper Size, which can resize the label layout.

Common Mistakes

Choosing a similar but incorrect product number: Label sheets can look nearly identical while having different margins or spacing. Confirm the code on the package and in Word’s Label Options rather than selecting a familiar-looking template.

Putting multiple details in one Excel column: If full names or complete addresses are combined in a single cell, Word cannot easily rearrange the parts for a custom layout. Split the information into useful columns before making the merge.

Forgetting Update Labels: Designing only the first cell does not automatically copy it across the sheet. Use Update Labels, then preview multiple records to make sure each label advances to a different row.

Printing directly onto label stock first: A small alignment error can waste a whole sheet. Test on plain paper, check the printer’s feed direction, and do not alter scaling unless the label maker’s instructions specifically require it.

Editing the source after making the merged document: The document created through Edit Individual Documents is a separate merge result. If you change the Excel list, run the merge again to get an updated set of labels.

Tips

Keep a clean, dedicated worksheet for the merge. A simple header row and uninterrupted list make it easier to select the right data range.
Use consistent text in a column. For example, avoid entering some states as full names and others as abbreviations unless that is intentional.
Use Address Block for a conventional mailing address, then check Match Fields. Individual merge fields are more suitable when you need a particular order or want to include details such as a company name.
Save the merged label document with a descriptive name if you may need to print it again. Keep the original Excel workbook too, because it is the editable source list.
For a partial run, choose the required record range when completing the merge, and check that the selected numbers correspond to the records you previewed.

Troubleshooting

Word cannot find or open the workbook: Confirm that the file is saved as an Excel workbook, that it is not in a location requiring a sign-in you have not completed, and that you have permission to access it. Close the workbook in Excel and try Mailings > Select Recipients > Use an Existing List again. If the workbook was moved or renamed, browse to its current location.

The wrong worksheet or no recipients appear: Reconnect to the workbook and choose the sheet with the headers and records. Check that headers are in the first row of the selected data, and remove blank rows above the list. If Word asks whether the first row contains headers, confirm that it does when your first row is headings.

Every label shows the same person: Return to the label document and select Mailings > Update Labels. Preview the result again. If you typed or copied fields into other cells manually, clear the extra cells and update the labels from the first cell so Word inserts the correct record progression.

The labels are shifted on the page: First verify the product number, paper size, and printer feed direction. Print on plain paper and compare the test with the sheet. If the shift is consistent across the page, the selected label definition or printer scaling may be wrong. If only later rows drift, check label pitch and the printer’s handling of the stock. Do not change several measurements at once; adjust the layout only after confirming the manufacturer’s specifications.

Text is missing, crowded, or runs onto extra lines: Check that the merge fields match the Excel headers, and inspect the affected source rows for empty values or unusually long text. Remove unnecessary blank lines from the first label, then select Update Labels again. If an address line is too long, use a smaller readable font or adjust the layout without changing the label’s physical dimensions.

Frequently Asked Questions

Can I create labels from Excel without Word?

Excel can store and organize the address list, but Word’s desktop mail merge is a practical way to arrange records on standard label sheets. You can use another label-design application if it supports your label product and can import the workbook.

Do I need a special format for the Excel file?

No special label template is required. Use a standard .xlsx workbook with one recipient per row and clear column headings in the first row. Keep the information you want to print in separate columns.

Can I print only selected names?

Yes. After connecting the list, use Mailings > Edit Recipient List to sort or filter recipients. When you choose Finish & Merge > Edit Individual Documents, you can also specify a record range. Preview the chosen records before printing.

Why are leading zeros missing from postal codes?

Excel may interpret the value as a number and remove the zero before Word reads it. Store postal codes as text and correct any values already changed in the workbook, then reconnect or refresh the merge and preview again.

Can I use Word for the web or Word for Mac?

Word for the web does not include the full desktop label mail merge workflow, so use Word for Microsoft 365 on Windows or the desktop Mac app. The Mac app has similar Mailings commands, although some dialog details can vary by version.

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.