Create Labels in Word From Excel: A Step-by-Step Guide

In Word for Microsoft 365 on Windows, create labels from an Excel list by choosing Mailings > Start Mail Merge > Labels, selecting the label vendor and product number, and connecting the workbook through Mailings > Select Recipients > Use an Existing List. Add fields to the first label, choose Update Labels, preview the entries, then finish the merge to print or create a separate document.

How the Excel-to-Word label merge works

Word uses mail merge to combine a label layout with rows of information in Excel. The workbook is the data source: each row is usually one recipient, and each column contains one kind of information, such as first name, last name, street address, city, or postal code. Word copies the layout you make for the first label across the sheet and fills each label with information from a different row.

This approach is useful for mailing labels, name tags, product labels, and other repeated items. You do not need a formula or a special Excel template. You do need a clean list, a label layout that matches the physical label sheets, and a quick review before printing. A mismatch between the document layout and the label stock can shift every entry, even when the recipient data is correct.

Prepare the Excel spreadsheet

Set up the list before connecting it to Word. Put the column names in the first row, with one recipient or item per row beneath them. Use clear headings such as FirstName, LastName, Address, City, State, and PostalCode. Avoid blank header cells, merged cells, and completely blank rows inside the list; these can make it harder for Word to identify and use the data consistently.

Keep each type of information in its own column. Do not put a full address in one cell if you want Word to arrange the parts on separate lines.
Use one row for each label. Remove test entries and duplicate records if they should not be printed.
Check spelling, punctuation, capitalization, and missing values. Word generally merges the data as it appears in Excel; it does not correct addresses.
Format postal codes, account identifiers, and other values with leading zeros as text before entering or importing them. If Excel has already removed a leading zero, changing the cell format afterward may not restore it.
Save the workbook as an Excel file, such as .xlsx. Close it before selecting it in Word to avoid file-access or update issues.

Keep the list in a simple, contiguous table where possible. If the workbook contains several sheets or separate tables, be ready to select the one that contains the intended records when Word asks which data source to use.

Choose the label stock and start the merge

Open Word for Microsoft 365 on Windows and create a blank document.
Go to Mailings > Start Mail Merge > Labels.
In Label Options, choose the label vendor and product number printed on the label package. Check that the product number matches the exact sheet size, not just the brand.
If the product is not listed, select New Label and enter the dimensions and layout details from the package or manufacturer. Give the custom label a recognizable name, then confirm the settings.
Choose OK. Word creates a document showing the label cells as a table-like grid.
Go to Mailings > Select Recipients > Use an Existing List, find the saved Excel workbook, and select Open.

Word may show a dialog asking which sheet or named range contains the recipients. Select the source with the headers and data, and confirm that the option indicating the first row contains column headers is selected when it appears. The wording of this prompt can vary with the workbook and Office configuration. If Word displays multiple possible sources, choose the sheet or range that actually holds the list.

Insert address information into the labels

Click inside the first label cell before adding any merge information. For a conventional mailing address, choose Mailings > Address Block. Review the preview in the dialog and use Match Fields if Word has not matched a field correctly—for example, if the workbook uses a heading such as PostalCode instead of a standard postal-code name. Confirm the block, then add any needed line breaks or spacing in that first label.

For a custom layout, choose Mailings > Insert Merge Field and insert each column where it belongs. A simple label might have a first and last name on one line, followed by the street address, then city, region, and postal code. Type spaces and punctuation between fields where needed; Word does not automatically know how you want separate fields combined. For example, a comma and a space between the city and region may be appropriate, while a country line may be unnecessary for domestic mail.

Use the names shown in the Insert Merge Field menu rather than typing field names manually. A typed word such as «City» is ordinary text unless it is inserted as a merge field. If you want a business name, department, or other optional line, add the corresponding field and decide how blank values should look. A field left empty in Excel may leave an unwanted blank line in the printed address, so check records that have optional information.

Copy the layout and preview every record

Once the first label looks right, choose Mailings > Update Labels. Word copies the first label’s arrangement to the remaining cells and adds the required record progression for the merge. Do not manually copy and paste the first label into every cell; using Update Labels is what lets Word populate the sheet with different spreadsheet rows.

Choose Mailings > Preview Results to see actual names and addresses in place of the merge fields. Use the record navigation controls on the Mailings tab to inspect more than the first entry. Look for long names, apartment or suite details, missing fields, unexpected blank lines, and postal codes with leading zeros. A layout that fits a short sample may not fit a long company name or street address.

If the displayed sequence or recipient selection needs adjustment, choose Mailings > Edit Recipient List. You can deselect records that should not be included and, where available, sort or filter the list. Make those choices before producing the final labels, then preview again. Preview Results is a view of the merged data; it does not change the Excel workbook.

Finish the merge and print carefully

When the preview is correct, choose Mailings > Finish & Merge. Select Edit Individual Documents to create a new document containing the merged labels, or select Print Documents to send the merge to the printer. Creating an individual document first is helpful when you want to inspect the complete output, save it, or make a last adjustment without changing the source workbook.

Before using label stock, print a test on plain paper. Hold the test page against a label sheet and check whether the text is centered in each label and whether the rows line up. In the print dialog, verify the correct printer, paper size, and orientation. Avoid options such as Fit to Page or scaling that shrink or enlarge the output unless the label manufacturer specifically calls for them; even a small scale change can move text out of alignment.

Load the label sheet in the direction required by the printer and use stock rated for that printer type. Some label products are designed for laser printers, some for inkjet printers, and some for particular paper paths. Follow the label and printer manufacturers’ instructions, especially for laser printers, where unsuitable adhesive or stock can damage equipment. If the test is misaligned, correct the label product selection or custom dimensions before printing another sheet.

Common problems and practical fixes

Every label repeats the same person: Check that you used Update Labels after designing the first cell and that Preview Results advances to different records. Repeated content can mean the remaining cells were filled with ordinary copied text instead of the merge layout.
Word cannot find the workbook or the right sheet: Save and close the workbook, confirm that it contains a header row and data, then reconnect with Use an Existing List. In the source-selection prompt, select the correct sheet or range.
Fields appear as names instead of actual addresses: Turn on Preview Results. If the field names remain, confirm that the entries were inserted through Insert Merge Field or Address Block and that the data source is connected.
Postal codes lose their first zero: Store the values as text in Excel before the merge. If the zero has already been removed from the underlying value, restore the correct code in the source data rather than relying on Word to infer it.
Text is shifted on the label sheet: Confirm the exact vendor and product number, printer paper size, orientation, and scaling settings. Test on plain paper before using another sheet of labels.
Some addresses have awkward gaps: Inspect records with empty optional fields and simplify the address layout. For example, omit a company line when it is blank rather than leaving unnecessary space above the street address.

Custom labels, Mac, and Word for the web

If your label brand or product number is missing, the New Label option can define a custom layout using measurements such as label height and width, page margins, the number of labels across and down, and the gaps between labels. Use measurements from the manufacturer when possible. Small measurement errors can accumulate across a sheet, so compare a plain-paper test with the physical stock before printing a full run.

Word for Mac also supports label mail merges in the desktop app, though dialog details and some options can differ from Windows. Look for the Mailings tab and the label and recipient commands there; check the prompts carefully when connecting an Excel workbook. Word for the web does not provide the full desktop mail-merge workflow for creating labels, so open the document in the Word desktop app to set up and complete the merge.

For a small number of labels, manually arranging text in a label template can be quicker. For a large or frequently updated list, a mail merge is easier to repeat: update the Excel records, reconnect or refresh the recipient list as needed, and produce a new merged document. If the labels need design elements such as logos or barcodes, create and test the layout in Word before committing label stock, or consider dedicated label-design software when it offers a template or printer workflow your job requires.

Frequently Asked Questions

Can I create labels in Word from an Excel spreadsheet?

Yes. Use Word’s label mail merge, connect the Excel workbook as the recipient list, place merge fields in the first label, choose Update Labels, and preview the results before printing.

Do I need to format the Excel list in a special way?

No special template is required, but use clear column headers in the first row, one record per row, and no merged header cells. Keep each address component in its own column if you want control over how it appears.

How do I print different names on each label?

Insert the fields in the first label and choose Mailings > Update Labels. Preview Results should then show a different spreadsheet record in each label cell. If every cell repeats the same record, check that the labels were updated and the recipient list is correct.

Can I use a label brand that is not listed in Word?

Yes. In Label Options, choose New Label and enter the sheet and label measurements. Use the manufacturer’s specifications and print a plain-paper test to check alignment before feeding label stock.

Can Word for the web make labels from Excel?

The full label mail-merge setup is a desktop Word task. Open the document in Word for Microsoft 365 on Windows or the Word desktop app for Mac to connect the Excel data and complete the merge.

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.