Recommended Free Tools
Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
To create mailing labels from an Excel spreadsheet, use desktop Microsoft Word’s mail-merge tools: prepare the Excel list, choose the exact label vendor and product number in Mailings > Start Mail Merge > Labels, connect the workbook, design the first label, select Update Labels, preview every record, and test the alignment on plain paper before printing on label stock. Excel supplies the records; Word lays them out and prints them.
This workflow is supported in Word for Microsoft 365, Word 2024, Word 2021, Word 2019, and Word 2016, including the Mac versions covered by Microsoft’s label documentation. Word for the web cannot directly create or edit a label mail merge, so use the desktop application.
As an Amazon Associate I earn from qualifying purchases.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsWhat do I need before creating labels?
Gather the spreadsheet, the physical label package, and a desktop copy of Word. The product number printed on the label package is essential because Word’s grid must match the stock’s dimensions and spacing.
- An Excel workbook: Save it locally, keep all records on the first worksheet, and finish edits before connecting it to Word.
- One field per column: Put a unique header in row 1, such as FirstName, LastName, Street, City, State, and PostalCode.
- Readable formatting: Check postal codes, apartment numbers, dates, and other values that could be reformatted or lose leading zeroes.
- Label stock information: Note the vendor, product number, sheet size (such as US Letter or A4), and whether the package specifies an inkjet or laser printer.
- Desktop Word: The browser version can preserve settings in an existing document but does not directly create or edit the merge.
How should the Excel sheet be arranged?
Use a rectangular list with headers in the first row and one recipient per row. Avoid blank rows, merged cells, subtotals, explanatory text above the headers, or multiple unrelated tables on the worksheet. If the workbook contains several sheets or tables, know exactly which one contains the label records; Word will ask you to select it.
Popular on Amazon
- 2026 New Version: Compared with traditional label makers, Nelko P21 handheld label maker has half the weight and size, making it smaller, smarter, and ultra-portable. The wireless Bluetooth label maker can slip into your pocket, allowing you to print anytime, anywhere. For great printing results, we recommend using our NELKO thermal label paper. Important Note for iOS Users: Please make sure you have updated your Nelko P21 app to the latest version (V4.8.0) for a great experience
- High-quality Printing: The P21 label maker features BPA-Free Direct Thermal Technology. Equipped with high-speed chips and 203 DPI, the P21 label maker delivers high-definition printing without ink or toner, perfect for back to school supplies. The label maker comes with a long-lasting built-in rechargeable battery for extended use. This label maker prints in monochrome (black text only), and you can create color labels by using color pattern label tapes. Note: Charging adapter not included
- Easy to Use: NELKO label printer connects with iOS & Android phones via Bluetooth. Step 1: Download "Nelko" app from Google Play or App Store. Step 2: Install paper roll. Step 3: Connect P21 via Bluetooth in the APP. Step 4: Choose a quick template and print. It is not compatible with Google Pixel phones running Android 14. This label maker's APP includes 3600+ icons, 700+ borders, 5500+ materials, 750+ templates, 29 languages. Note: This label maker doesn't work with computers
- Multiple Creative Functions & Templates: This app for the label maker provides various features and templates, making it easy to create various designed label stickers in the App with text, QR code, barcode, materials, images, time and borders, etc. The length of labels is fixed, including 14×40mm, 14×50mm, 14×75mm, and more. Please do not tear or damage the green sticker on the back of the label strip, otherwise it will affect the printing effect. Note: Continuous label tapes are not supported
- Design Your Own Labels: This label maker machine with tape is widely used at home, in the office, and at school. At home, it helps organize clothes, food storage, cosmetics, and mailings. In the office, it is ideal for notebook tags, price tags, reminder labels, and other office supplies. At school, it supports teachers and students with name tags, item identification, and classroom organization. You can also use it to create unique back-to-school decorations and fun school supplies for kids
Format postal codes as text when a leading zero is meaningful. For example, a code such as 01234 must remain five characters in Excel before you connect the workbook. Review the displayed values rather than relying on how the cells look after a number format has been applied.
How do I choose the correct label layout in Word?
Open the desktop Word application and select Mailings > Start Mail Merge > Labels. In Label Options, choose the printer type, label vendor, and the exact product number printed on the package.
- Choose the printer type offered by your label stock, usually a continuous-feed or page-printer option.
- Open the vendor list and select the correct regional sheet format, such as an Avery US Letter entry or an A4/A5 entry where applicable.
- Select the product number that matches the package. A similar-looking label is not necessarily interchangeable: margins, gaps, and label pitch determine alignment.
- Click OK. Word creates a table-like label grid in the document.
What if my label product is not listed?
Select New Label in Label Options and enter the dimensions from the package or manufacturer specification. Measure the label width and height, the horizontal and vertical pitch (label plus gap), page margins, and the number of columns and rows. Save the custom definition with a descriptive name, then select it for the merge.
Do not substitute a product number merely because the labels appear to have the same size. A small difference in side margins or vertical spacing can move every row out of alignment.
How do I connect the Excel spreadsheet to the Word labels?
After Word creates the label grid, connect the workbook as the recipient list.
- Select Mailings > Select Recipients > Use an Existing List.
- Browse to the locally saved Excel workbook and open it.
- When Word displays the workbook’s sheets or tables, select the one containing your records. Confirm that the option indicating the first row contains column headings is enabled when shown.
- Open Mailings > Edit Recipient List and inspect the records. Clear a recipient’s checkbox to exclude that row, or use the list controls to sort and filter before inserting fields.
If the expected worksheet is missing, close the workbook in Excel and reconnect it. Word may not show unsaved changes or a sheet that was added after the connection was established.
Free tools Windows power users keep installed
One-click scans. No signup required.
How do I design the first label with merge fields?
The upper-left label is the template for the sheet. Put the fields, punctuation, line breaks, and formatting you want in that label before copying it to the rest.
Also popular on Amazon
- CUSTOMIZE, ORGANIZE and OPTIMIZE YOUR LABELING GAME: Portable, battery operated, user-friendly handheld label maker ideal for dorm rooms, student life and traveling; a compact solution to identify belongings, create reminders, and express yourself
- BE CREATIVE. BE UNIQUE. Btag: Use exclusively with Brother P-touch Btag Label Tapes measuring ½” (12mm) wide and 13.1’ (4m) long; available in 17 colorful options; featuring split, easy peel backings for effortless application; damage-free removal
- EXPRESSIVE OPTIONS: Pre-loaded with 3 fonts in 6 font styles including underline and italic, 10 frames, 200 symbols; prints up to two lines of text with a combined height of 7mm. per label; create colorful unique messages to apply almost anywhere
- ALL-IN-ONE LABEL CREATION, PRINTING and CUTTING: Type comfortably on the full QWERTY keyboard, quickly print labels, then use the built-in cutter for clean, smooth edges on every label, every time; quick and easy meets fun and functional
- EFFECTIVE FEATURES FOR EFFICIENT LABELING: Avoid mistakes and eliminate waste by using the 12-character display screen to preview your text and tape length before printing; saves 10 labels for quick re-printing of frequently used or favorite labels
- Click inside the first label.
- Choose Mailings > Address Block for Word’s combined address field, or choose Insert Merge Field to place individual columns such as FirstName, Street, City, State, and PostalCode.
- When using individual fields, type the spaces, commas, and line breaks yourself. A typical layout is a name line, a street line, and a final city/state/postal-code line.
- Use Match Fields if Word cannot identify which spreadsheet column corresponds to a component in Address Block.
- Format the first label as you would any text: choose the font, size, alignment, paragraph spacing, and emphasis. Keep enough interior space for the longest likely name or address.
Address Block is convenient for conventional postal addresses, while individual fields give you control over company names, apartment or suite lines, international formats, and optional fields. If an optional column can be blank, design the merge so an empty field does not leave an unwanted extra line.
How do I make every label use the first label’s design?
With the first label selected, choose Mailings > Update Labels. Word copies the first-label layout and inserts the required next-record rule into the remaining cells, so each label advances to the next spreadsheet row.
- Finish the first label’s text and formatting.
- Click Mailings > Update Labels.
- Click in a later label to verify that it contains the merge fields and a next-record instruction rather than a duplicate of the first recipient.
- If you change the design later, edit the first label and select Update Labels again.
If only the first label contains data, the update command was skipped or the later cells were overwritten. Return to the first label, restore its layout, and run Update Labels before previewing.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallHow do I preview the merged labels and catch bad records?
Choose Mailings > Preview Results, then use the previous and next record controls to inspect different recipients, including the first, middle, and last records.
- Check that every field displays a value from the intended column.
- Look for blank lines caused by empty optional fields.
- Test long names, long street addresses, apartment numbers, and international addresses.
- Verify that postal codes retain leading zeroes and that punctuation appears only where you want it.
- Use Edit Recipient List to remove duplicates or exclude records that should not be printed.
Previewing does not change the source workbook. If the data is wrong, close or pause the merge, correct the Excel values, save the workbook, and reconnect or refresh the recipient list before printing.
How do I print the labels without wasting a sheet?
Print a plain-paper proof first. This is the safest way to detect a printer setting or label-definition error before using adhesive stock.
- Select Mailings > Finish & Merge > Print Documents.
- Choose to print all records, the current record, or a specified range.
- In the printer dialog, select the correct paper size and tray. Disable options such as “Fit to page,” “Scale to fit,” or automatic enlargement; the document must print at 100% size.
- Print one copy on ordinary paper.
- Place the proof behind an unused label sheet and hold both up to a light source. Check that text sits inside every label and that the first and last rows remain aligned.
- Correct the label product, printer type, paper size, tray, or scaling if necessary, then repeat the proof.
- Load the label stock according to the printer’s orientation marks and print the final batch.
Printer drivers can use different default trays or scaling settings for ordinary paper and specialty media. Confirm the settings again when you switch to label stock.
Also popular on Amazon
- Ideal For Small Office, Home Office, and Home Organization: a mobile label maker to keep homes, small offices, and workspaces tidy and organized. Powered by 6 AAA batteries or optional AC adapter (each sold separately)
- Prints on Brother Genuine TZe Label Tapes: Create labels that are approximately 1/2 inch (12mm) wide. Easy to peel, durable and laminated labels are ideal for a variety of applications in multiple finishes and colors and can print 1 or 2 lines of text on labels
- Personalize Your Labels: Choose from 14 different fonts, 11 font styles, 99 designer frames, and over 600 symbols and use the familiar QWERTY style keyboard for ease of use
- Built-in Memory: Save up to 30 frequently used labels Create them, save them, find them, and reprint them as many times as needed
- Create and Print Quickly and Easily: Use the 25 pre-set label templates to create and print professional-looking labels in an instant with a variety of templates for home and workplace organization, and more
Can I save the merge and reuse it with an updated list?
Yes. Save the Word merge document after establishing the Excel connection. The document retains the data-source connection and can be reused with an updated list, provided the workbook remains accessible and its column structure is compatible.
For a recurring mailing, keep the same header names in Excel. If you rename or remove a column, reopen the merge and check every inserted field and Address Block mapping before printing. Save a new Word file when you need a different label design so the established version remains intact.
What are the alternatives to a Word mail merge?
The best workflow depends on whether you already have structured data and whether you need Word’s field-level controls.
| Workflow | Data-source support | Field and formatting control | Preview and filtering | Desktop Word required? | Best use |
|---|---|---|---|---|---|
| Desktop Word mail merge | Excel lists and other connected recipient sources | Individual merge fields, Address Block, and full label formatting | Preview records; edit, sort, or filter the recipient list | Yes | An existing spreadsheet with many records or a repeatable mailing |
| Word built-in label template | No connected list required | Preset or custom label grid with ordinary document text | Manual review; no record-by-record merge | Usually, for creating or editing the layout | A one-off sheet or labels whose text is entered manually |
| Avery Design & Print Online | Browser-based import options depend on the current service | Template-oriented design; controls vary by template | Online preview and service-specific data tools | No, but it requires a browser and the service | Users who prefer a browser workflow over Word |
Microsoft’s current Word guidance says the older Avery step-by-step wizard is retired. Use Word’s built-in Mailings > Labels layouts, a custom New Label definition, or a searchable Word template instead.
What should I do when labels are blank, wrong, or misaligned?
Match the symptom to the likely cause before changing the layout.
Fields are blank or show the wrong values
- Confirm that the selected worksheet or table is the one containing the records.
- Compare the inserted merge-field names with the exact Excel headers. Reinsert a field if a header was renamed.
- Check that the workbook was saved after the data was entered and before Word connected to it.
- Use Preview Results rather than viewing field codes alone; field codes can look correct while the selected data source is wrong.
Only one label is populated
Edit the upper-left label and select Update Labels. Do not manually paste the first recipient into every cell; the update command supplies the next-record behavior that advances through the list.
Labels print too high, low, left, or right
- Recheck the package’s vendor and product number in Label Options.
- Verify whether the stock is US Letter, A4, or another page size.
- Confirm the printer type and the tray used for the stock.
- Turn off printer and Word scaling and print at 100 percent.
- Run another plain-paper overlay test before using adhesive sheets.
Postal codes lose zeroes or other formatting
Correct the cell formatting in Excel, preferably treating postal codes as text when necessary. Save the workbook and reconnect or refresh the recipient list; changing only the Word field will not restore a digit that Excel already discarded.
Also popular on Amazon
- [HIGH TECH LABEL PRINTER] Equipped with a Japanese high tech thermal print head, 203 DPI high printing quality. No ink, No toner, Clean with no mess, economical. Works with both fanfold labels and roll labels. Label size: labels width ranges from 1.57" to 4.1"
- [PRINT WIRELESSLY]The label printer support printing wirelessly. For windows 8 or later and Mac, you can print via Bluetooth. For Android& iOS, you can’t print via Bluetooth on phone, need to download the App "Jadens printer" and print on it.
- [PRINT VIA USB] USB connection works with both Windows (7 and newer) and Mac OS (10.9 and newer) devices. Please long and press the feed button to identify and calibrate label size each time you change labels.
- [WIDE USAGE] JADENS thermal label printer is widely used to print labels from various marketplaces and shipping platforms, such as Endicia, Dazzle, ShipStation, Shipping Easy, Shippo, ShipWorks, Ordoro, eBay, Amazon, Easy, and Shopify. Use JADENS thermal label maker machine to print shipping labels, warehouse labels, market labels, helping increase your productivity. Ideal for your online small business for shipping packages.
- [EASY TO SET UP & RELIABLE AFTER-SALE SERVICE] Set up in one minute. Printer driver, instruction videos and problem shooting videos are provided in U-Disk for better understanding. Offer one year warranty; customer support can be reached out to email, phone, remote control.
The product number is missing from Word
Choose the regional vendor list that matches the paper size, such as the US Letter or A4/A5 list where applicable. If the exact item still is not available, select New Label and enter the package dimensions instead of choosing an approximate preset.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Which facts matter most for a reliable label merge?
- Excel is the data source; desktop Word performs the layout and merge.
- Unique headers and correctly formatted cells determine whether fields populate properly.
- The physical package’s vendor and product number must match Word’s label definition.
- The first label is the template, and Update Labels propagates it through the sheet.
- Preview several records and test alignment on plain paper before printing label stock.
- Word for the web cannot directly create or edit the merge settings.
Frequently Asked Questions
Can I create mailing labels in Word for the web?
Not from a new merge. Word for the web can retain mail-merge settings in an existing document, but creating or editing the label merge requires the desktop Word application.
How do I print only selected Excel rows as labels?
Before finishing the merge, open Mailings > Edit Recipient List and clear the checkboxes for rows you do not want. You can also filter the list using its field values, then print the filtered recipients through Finish & Merge > Print Documents.
Why does Word ask me to select a table when my workbook has one sheet?
Word treats an Excel worksheet or a defined Excel table as a possible data source. Select the item that contains the header row and recipient records, and make sure the workbook was saved and closed in Excel before reconnecting.
Can I use labels for packages instead of postal addresses?
Yes. Insert fields such as OrderNumber, SKU, or CustomerName individually rather than using Address Block. The same first-label and Update Labels process works for any one-record-per-row data.
What happens if I change the Excel column names after building the labels?
The existing Word fields may become unmatched or display errors because they refer to the old headers. Restore the original header names when possible, or use Insert Merge Field and rebuild the affected lines before previewing and printing.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
