Print labels from Excel — without Word

How to prepare your spreadsheet

Both methods below read the same structure, so get the sheet right before starting either.

Use one row per record and one column per field. A row becomes a label; a column becomes a line on that label. Splitting an address into separate columns for street, city, state and postcode gives you control over where the lines break, covered further in laying out an address list; an address pasted into one cell with line breaks inside it does not, because it arrives as a single undifferentiated run of text.

Put plain headers in the first row: Name, Address, City, Postcode. Word turns those into merge field names, and this tool uses them to label the columns in the mapping step. A merged title row sitting above the headers breaks both, since the first row is where each one expects to find the field names.

Avoid merged cells anywhere in the data range. A merged cell has no clean row-and-column position, so readers either skip it or return the value in the wrong place. Unmerge, and repeat the value down the column if it needs to appear more than once. Avoid blank rows mid-list too: a blank row reads as an empty record, which in a Word merge becomes an empty label and pushes every label after it one position along the sheet.

Format ZIP and postal codes as text before typing them, not after. Excel treats 02134 as the number 2134 and discards the leading zero, and reformatting afterwards will not bring it back — the value has to be re-entered. Select the column, set Format Cells to Text, then enter the codes. A custom format of 00000 only displays the zero while still storing a number underneath, which is enough for printing from Excel and not enough for a Word merge reading the underlying value.

How to print labels from Excel using Word mail merge

Word's mail merge is the method Microsoft documents and most search results describe. It works, and if you already have it set up there is no reason to change.

Start in Word with a blank document, not in Excel. On the Mailings tab, choose Start Mail Merge and select Labels. In the Label Options dialog, set Label vendors to Avery US Letter — the vendor matters, because Avery US and Avery A4/A5 number their products differently — then find your product number in the list, for example 5160 Address Labels, and click OK. Word converts the page into a table whose cells match the die-cut of that sheet. If the cell boundaries are invisible, turn on View Gridlines from the Table Layout tab.

Next, attach the data. Choose Select Recipients, then Use an Existing List, and browse to your .xlsx file. Word asks which worksheet to use and shows a checkbox marked "First row of data contains column headers". Leave it ticked if your sheet has a header row — that is what turns your columns into named merge fields. Edit Recipient List lets you filter or sort at this point if you only want part of the list.

Build the first label only. Click into the top-left cell and use Insert Merge Field to place each field in turn, typing the spaces, commas and line breaks yourself — Word inserts the field but nothing around it, so «First_Name» «Last_Name» needs the space typed in between.

Then click Update Labels. This copies the layout from the first cell into every other cell on the sheet and adds a «Next Record» field to each one, which is what makes Word advance through the list rather than repeat the first row. Skipping this step is the most common reason a merge produces one correct label followed by twenty-nine copies of the same address.

Use Preview Results to step through the merged output and check a few records, particularly the longest ones. When it looks right, choose Finish & Merge, then Edit Individual Documents, and merge All. Word produces a new document containing every page of labels, and that document is what you print.

One detail worth knowing in advance: Word connects to Excel through OLE DB by default, which passes the stored value rather than the formatting you see, so ZIP codes with leading zeros can arrive stripped. To connect over DDE instead, tick "Confirm file format conversion on open" in File, Options, Advanced; Word then offers MS Excel Worksheets via DDE when you select the workbook, which preserves the displayed formatting.

Why this tool exists

The mail merge route needs desktop Word. The web version has no labels wizard at all, so a Microsoft 365 subscription is not by itself enough, and a machine running only Pages or Google Docs cannot do it.

On macOS the wizard is arranged differently from the Windows version most tutorials describe, and the Excel connection has long been the least dependable part of Word for Mac. Following a Windows walkthrough there means translating every step, and some steps have no equivalent, so the macOS route is separate.

Even with everything working, the first run takes about twenty minutes: the dialogs, the field insertion, the Update Labels step you have to already know about, the preview, the merge. Later runs are quicker, but only if nothing has moved — the document stores a path to the workbook and reconnects every time it opens.

The tool above does the same job in the browser in under a minute. Load the sheet, assign columns to lines, download the PDF. There is no document in between to save, break or reconnect, and nothing to install. It behaves identically on every desktop platform, because it is a web page rather than an application, so a list kept in Google Sheets needs no export step, and nothing is uploaded anywhere.

Printing correctly

Print at actual size. In the print dialog this is Scale 100% on macOS or Actual size on Windows; what matters is that "Fit to page" and "Shrink oversized pages" are both off. Scaling by even one percent moves each row further from the die-cut than the one above it, so the top labels look fine and the bottom ones print across the gaps.

Set printer margins to none where the driver offers it: a margin the printer adds is an offset applied to the whole sheet, shifting every label at once. Check the paper size is US Letter too — every Avery format here is Letter, and the same layout on A4 comes out shifted.

Then run one page on plain paper and hold it against a real label sheet, up to a window if you need the light. That one check catches scaling, paper size and driver margins at once, for the price of a sheet of paper. Every sheet in the Avery template index also offers a blank template with cut guides and a one-inch reference line, for exactly this purpose.