Learning how to make address labels from Excel is one of the most practical productivity skills you can pick up, whether you are running a small business, sending wedding invitations, or mailing out a quarterly newsletter. Excel stores your contact list in clean, structured rows, and Microsoft Word reads that list during a mail merge to generate perfectly formatted labels on standard Avery sheets. Once you understand the workflow, you can print 30, 300, or 3,000 labels in minutes without retyping a single address.
The process feels intimidating the first time because it spans two applications, but it follows a predictable pattern: prepare your spreadsheet, start a mail merge in Word, link the data source, insert merge fields, preview the results, and print. Each step has a few common pitfalls — extra columns, missing ZIP codes formatted as numbers instead of text, or label sheets that print one row off — but every issue has a known fix. This guide walks through each phase with the exact menu paths used in Microsoft 365.
Before you open Word, the Excel side matters enormously. A well-structured worksheet uses one row per recipient, one column per field (First Name, Last Name, Street, City, State, ZIP), and a header row in the very first row of the sheet. There should be no merged cells, no blank rows breaking the list, and no totals or notes mixed into the data. If you have ever wrestled with merged cells, you may want to review how to merge cells in Excel to understand why merges break data sources and how to undo them cleanly.
Address labels are also a useful learning exercise because they touch on adjacent Excel skills you will reuse constantly: text-to-columns for splitting full names, TRIM and CLEAN for removing stray spaces, custom number formats for forcing five-digit ZIP codes, and VLOOKUP or XLOOKUP for pulling addresses from a master contact database. By the end of this guide you will know how to make address labels from Excel reliably, troubleshoot the most frequent print errors, and adapt the workflow for envelopes, name badges, shipping labels, and product tags.
This article covers the full Microsoft 365 workflow on both Windows and Mac, plus alternative routes if you only have Excel and no copy of Word — including printing directly to label sheets from Excel using a custom page setup, and using free tools like Google Docs or LibreOffice as substitutes. We will also cover Avery's free Design & Print online tool, which can import an Excel sheet directly and skip Word entirely for users who find the Word interface confusing.
Whether you are a beginner who has never run a mail merge or an office veteran who needs a refresher on the new Microsoft 365 ribbon, the sections below give you everything from a five-minute quick-start to deep troubleshooting. Expect screenshots-worth of detail in plain prose, real Avery product codes (5160, 5161, 5163, 8160), and tested fixes for the most common errors like skipped labels, cut-off addresses, and ZIP codes losing their leading zeros.
Create a single worksheet with header row in row 1 and one recipient per row. Use separate columns for First Name, Last Name, Street, City, State, and ZIP. Save as .xlsx and close the file before starting the merge.
In Word, go to Mailings > Start Mail Merge > Labels. Choose your Avery product number (5160 is most common for address labels at 1 by 2-5/8 inches). Word builds a blank template matching that sheet layout.
Click Select Recipients > Use an Existing List, browse to your Excel file, and choose the correct worksheet tab. Confirm the First row of data contains column headers checkbox is ticked so Word reads field names properly.
In the first label cell, click Insert Merge Field and add each column with spaces, commas, and line breaks between them. Use Address Block for a one-click layout, or build it manually for full control over formatting.
Click Update Labels to copy the layout to every cell on the sheet, then Preview Results to see real addresses. Check the last label on the page to confirm ZIP codes and state abbreviations render correctly without truncation.
Run a test print on plain paper first, hold it against an Avery sheet to verify alignment, then load real label sheets and print. Save the merged document as PDF for archiving so you can reprint individual sheets later.
Preparing your Excel spreadsheet is the single most important step, and roughly 80% of mail merge failures trace back to data problems rather than Word problems. Open a blank workbook and dedicate row 1 to headers: First Name, Last Name, Company, Street, City, State, ZIP, Country. Use plain text in headers — no spaces if you can avoid them (Excel tolerates them, but some merge versions get cranky), no special characters, and no merged title cells across the top. Each subsequent row holds one recipient, and every field gets its own column.
Resist the temptation to combine fields. Putting Full Name in one column instead of First Name and Last Name limits your salutation flexibility forever — you cannot easily switch from Dear John Smith to Dear John or Mr. Smith without splitting the data later. Similarly, keeping Street, City, State, and ZIP in separate columns lets you sort by ZIP for bulk mail discounts, filter by state for regional mailings, and validate ZIP codes with formulas. The Excel functions list includes TEXT, TRIM, PROPER, and CONCATENATE which are all useful for cleaning address data.
ZIP codes deserve special attention because Excel treats them as numbers by default, which strips leading zeros. A Boston ZIP of 02115 becomes 2115 the moment you type it. The fix is to format that column as Text before entering data: select the column, press Ctrl+1, choose Text, then type the ZIPs. If you already have data with stripped zeros, apply a custom number format of 00000 to force five digits, or 00000-0000 for ZIP+4 codes. This preserves leading zeros without changing the underlying number.
Clean up stray whitespace before merging. A single trailing space after a state abbreviation can shift commas on your label or break sorting. Use the TRIM function in a helper column to strip leading and trailing spaces: =TRIM(B2). Copy the helper column, paste as values back over the original, then delete the helper. Apply PROPER to enforce title case on names: =PROPER(A2) converts john SMITH to John Smith. These tiny cleanups make every printed label look professional.
If your master contact list lives elsewhere and you need to pull specific fields for this mailing, VLOOKUP excel formulas are your friend. A formula like =VLOOKUP(A2, MasterList!A:F, 4, FALSE) pulls the city from your central database based on a customer ID. For larger lists or two-way lookups, XLOOKUP is more flexible. Always paste the results as values before saving the file for merge — formulas can recalculate during merge and produce unexpected results.
Finally, double-check the sheet name. Word reads the worksheet tab name during merge, so a tab named Sheet1$ shows up as Sheet1 in the merge dialog. Rename it to something descriptive like Holiday2026Mailing so you can identify it instantly if you have multiple address lists in one workbook. Delete any empty sheets in the file before saving, save as .xlsx (not .xls or .csv unless required), and close the workbook completely. Word cannot read an Excel file that is currently open in another window with locked editing.
One last preparation tip: sort your data before merging. Sort by ZIP code ascending if you plan to use USPS bulk mail rates, by Last Name if you want alphabetical order on the printed sheets, or by State if you are doing regional segmentation. Sorting after the merge is technically possible but tedious. Sort first, save, then merge — and your labels print in exactly the order you want them stacked.
The classic route uses Word's Mail Merge wizard, which reads your Excel file as a data source and places merge fields into label-sized cells on an Avery template. This method gives you the most formatting control: you can bold names, italicize companies, add return-address banners, and conditionally include or skip fields with IF statements. It is the workflow Microsoft officially supports and the one most office tutorials reference.
The downside is that Word and Excel must both be installed and licensed, and the interface differs slightly between Windows and Mac. Mac users sometimes find Step 6 (Complete the Merge) buried under a different menu. The upside is reliability — once configured, the same template prints flawlessly month after month, and you can save the merged document for reuse with updated data.
Avery offers a free online tool at avery.com/print that imports Excel directly without requiring Word. Upload your .xlsx file, choose your product code, drag fields onto the template, and download a print-ready PDF. This is the easiest option if you do not own Word or find the merge wizard confusing, and it works on Chromebooks and tablets that cannot run desktop Office.
Avery's tool includes pre-built layouts for shipping labels, return addresses, name badges, and product labels, plus design extras like background colors and logos. The trade-off is fewer advanced features — no conditional logic, limited font selection, and you must reupload the spreadsheet if you change data. It is perfect for one-time runs and small businesses without an IT department.
If you only have Excel and no Word license, you can format an Excel sheet as a label grid using custom column widths, row heights, and page margins. Set each row to 1 inch and each column to 2.63 inches to match Avery 5160 dimensions, then use a single formula per cell to concatenate the address: =A2&CHAR(10)&B2&CHAR(10)&C2&", "&D2&" "&E2 wrapped with text wrapping enabled.
This approach skips mail merge entirely but requires precise page setup. Set margins to 0.19 inches top and bottom, 0.18 left and right, and print at 100% scale (no shrink-to-fit). It is fiddly to set up the first time but reusable forever. Useful when you need labels printed from a shared spreadsheet on a machine without Word installed.
Avery sheets cost around 15 cents each. Before loading a stack into your printer, print the merged document on regular paper and hold it up to a blank label sheet against a window. Misalignment of even 2mm cascades across 30 labels and ruins the whole sheet. A 30-second paper test saves a $5 sheet every time.
Avery dominates the US label market, and knowing the right product code saves you from buying sheets that do not match your template. The most common code is Avery 5160, which produces 30 labels per sheet at 1 inch by 2-5/8 inches — ideal for standard postal addresses.
Avery 5161 is 1 by 4 inches with 20 labels per sheet, better for longer addresses or business names. Avery 5163 produces 10 shipping labels at 2 by 4 inches, and 8160 is the inkjet equivalent of 5160 for inkjet printers. Word lists all of these by code in the Label Options dialog.
If you are buying generic store-brand labels (Staples 575-080, Office Depot SKUs, Amazon Basics), check the box for an Avery-equivalent code. Most generics list the matching Avery number prominently because the entire industry standardizes on Avery dimensions. Once you select the code in Word, the template configures itself automatically with the correct number of labels per page, cell dimensions, and margins. Never override these manually unless you have measured your specific sheets with a ruler.
For the actual print step, load label sheets according to your printer's instructions — usually face-down in the rear feed for laser printers, face-up in the bypass tray for inkjets. Set print quality to high or photo for inkjets to prevent smudging, and set the paper type to Labels or Heavyweight to slow the print speed and avoid jams. Lasers handle labels at standard speed but generate heat that can curl cheap sheets, so use Avery-brand or another premium label paper for laser printing.
Print only one sheet at a time on your first run. Sheet-fed label printing has a higher jam rate than plain paper because of the adhesive backing, and a jam mid-sheet can leave half-printed labels stuck to your printer's rollers. Once you confirm clean alignment and no jams, you can load five or ten sheets at a time. Most office printers can handle a full 30-sheet stack of labels, but business mailings of 500+ addresses are safer printed in batches with cool-down breaks.
Color and font choices matter for readability. USPS automated sorting equipment reads black text on white labels best. Avoid colored text, fancy script fonts, or backgrounds — they reduce machine readability and can trigger manual sorting fees on bulk mail. Stick with Arial, Helvetica, or Calibri at 10-12 point for the address block, and 8-10 point for return addresses. Bold the recipient name for visual hierarchy but keep the street address regular weight.
If you are doing bulk mail (200+ pieces qualifying for USPS discounts), sort the Excel file by ZIP code ascending before merging. The USPS requires presorted bulk mail to be banded or trayed by ZIP, and printing in ZIP order makes the post-print sorting trivial. You can also generate an IMb (Intelligent Mail Barcode) using the USPS Business Customer Gateway and add it as a merge field, though this requires a USPS account and is overkill for runs under 500 pieces.
For shipping labels with tracking numbers, switch to Avery 5163 or 5164 sheets and include the carrier's barcode as an image field in the merge. USPS Click-N-Ship, UPS WorldShip, and FedEx Ship Manager all export label PDFs that you can split and print, but for bulk recurring shipments a custom Excel-to-Word merge with a barcode font like Code 128 is faster. Install the font on your machine, format the tracking column with that font, and the barcode renders directly on the label.
Troubleshooting is where most label-printing sessions go sideways, but every error has a known fix once you recognize the symptom. The most common complaint is skipped labels — Word fills the first label and then leaves the rest blank. This happens when you forgot to click Update Labels after inserting the merge fields. Update Labels copies the field layout from the first cell to every other cell on the sheet. If you skip it, only label one gets data. Click it, preview again, and the issue disappears.
Another frequent issue is cut-off addresses where the last line wraps or disappears entirely. The cause is usually the cell margin or font size. Open the label template, click inside any label cell, and check Table Properties — internal cell margins should be 0.05 inch or less on all sides. If your font is 12 point, drop to 11 or 10 point for long addresses. Apartment numbers, suite numbers, and rural route addresses are the usual culprits because they push the address to five lines instead of the standard four.
If your labels print one row off — meaning every address appears in the position that should hold the previous label — your printer's top margin is misconfigured. Open Page Setup in Word, set the top margin to exactly 0.5 inch (Avery 5160's specification), and disable any printer driver setting that adds extra margin. Some printer drivers have a Borderless or Edge-to-Edge mode that conflicts with label sheets — turn it off and use the default margin settings.
Names and addresses appearing in the wrong fields usually means Word matched columns incorrectly during the merge. Go to Mailings > Match Fields and verify that each merge field points to the correct Excel column. If you renamed columns after starting the merge, Word may not auto-detect the new names. Re-run Select Recipients to refresh the connection. The how to freeze a row in Excel feature is also useful here — freezing row 1 in your source file makes it easier to spot column header changes that could confuse Word.
Special characters and accented letters sometimes render as boxes or question marks. This indicates an encoding mismatch between Excel and Word. The fix is to save your Excel file as .xlsx (modern Office Open XML format) rather than the legacy .xls. The newer format uses UTF-8 encoding which handles accents, umlauts, and non-Latin characters cleanly. If you must use .xls for compatibility, ensure both files are on the same system locale.
Blank labels appearing mid-sheet usually mean your Excel file has blank rows interrupting the data range. Word reads from the first row of headers down to the last contiguous row of data. A single empty row stops the merge there or inserts blank labels. Sort your data, delete any blank rows, and ensure the data range is solid before merging. Use Ctrl+End in Excel to jump to the last used cell — if it lands past your real data, delete those phantom rows and save.
Print quality issues like smudging, streaking, or labels peeling off in the printer are hardware problems, not Word problems. Switch to a fresh sheet of premium-brand labels (Avery, not generic), set the printer paper type to Labels in the print dialog, and clean the printer rollers if you have been printing heavily. For inkjets, let printed sheets dry for 60 seconds before stacking. For lasers, avoid sheets with damaged or partially used label spaces — the missing labels expose adhesive that can stick to the fuser and cause permanent damage.
Beyond the basic workflow, several practical tips elevate your label-printing game from competent to expert. First, build a reusable template document. After you complete your first successful merge, save the Word file as a .docx labeled something like AddressLabels_5160_Template.docx. Next time you need labels, open this file, point Select Recipients to a fresh Excel file with the same column structure, and you skip all the setup steps. Standardize your Excel column names (First Name, Last Name, Street, City, State, ZIP) and the template will match automatically every time.
Second, use the Address Block feature in Word's Mailings tab for one-click formatting. Instead of manually inserting six merge fields with commas and line breaks, Address Block builds a smart layout that handles country codes, optional middle names, and formats US versus international addresses differently. You can customize how names are displayed (Joshua Q. Public, J. Q. Public, or Mr. Public) and whether company names appear. It is the fastest path to professional-looking labels.
Third, learn to filter recipients during the merge. Mailings > Edit Recipient List opens a dialog where you can sort, filter, and deselect individual records. You can filter by state to print only California addresses, exclude any record where the Country field is not empty (skipping international addresses for a US-only run), or sort by ZIP for bulk mail. These filters apply to the current merge only and do not modify your Excel source, so they are safe to experiment with.
Fourth, save your final merged document as PDF, not just the template. The PDF captures the exact merge output and can be reprinted any time without rerunning the merge. This matters when you need to reprint a single sheet that jammed or got smudged — open the PDF, print only page 7, and you are done in 30 seconds. Save PDFs in a labeled folder by date and project so you can audit who got what, when.
Fifth, integrate label printing with your CRM or contact database. If you use Outlook, Mailings > Select Recipients > Choose from Outlook Contacts pulls names directly without an intermediate Excel file. If you use Salesforce, HubSpot, or Mailchimp, export your contact list to CSV, open it in Excel, clean it with TRIM and PROPER, save as .xlsx, and merge. Building this export-clean-merge habit takes 10 minutes and saves hours when you do quarterly or monthly mailings.
Sixth, consider envelopes as an alternative to labels for premium mailings. Word's Envelopes feature in the Mailings tab uses the same Excel data source but prints directly on envelopes, which looks more personal and professional than peel-and-stick labels. Number 10 business envelopes are standard, and most modern printers handle them through the bypass tray. Set up an envelope merge once and you can switch between labels and envelopes depending on the mailing's formality.
Finally, validate your address list against USPS standards before mailing. The USPS offers free address verification through their Address Information System Products, and several third-party tools (Smarty, Lob, Melissa Data) verify entire spreadsheets in bulk. A clean list reduces returned mail, improves deliverability rates, and qualifies you for better USPS bulk mail pricing. For mailings of 100+ pieces, verification typically pays for itself in saved postage on undeliverable addresses.