You can turn an Excel spreadsheet into mailing labels using built-in features in Microsoft Word or Google Docs, without needing extra software

The fastest route is mail merge, a feature that pulls names and addresses from your Excel file and formats them as labels on a template. Word and Google Docs both have this built in. The process takes about 10 to 15 minutes once you have your spreadsheet organized correctly — the main work is making sure your column headers match what the mail merge tool expects.

If you are using a document editor you chose partly for privacy reasons, mail merge stays within that tool. Your data does not leave Excel or get sent anywhere else. The labels print from your computer to your printer, or save as a PDF you control.

Key Takeaways

  • Excel columns must have clear headers in the first row — "First Name", "Last Name", "Address", "City", "State", "ZIP" — before you start the merge.
  • Microsoft Word's mail merge tool walks you through selecting your Excel file, choosing which fields go where on the label, and printing or saving the result.
  • Google Docs does not have a built-in mail merge, but you can use a free add-on called "Mail Merge for Docs" that connects to Google Sheets instead of Excel.
  • Label templates are available in both Word and Google Docs for common sizes like Avery 5160 (one-inch by 2.625-inch labels), so you do not have to set up spacing yourself.
  • Once the merge is complete, you can edit individual labels by hand if a few addresses need corrections before printing.

Setting up your Excel file so mail merge will recognize it

Mail merge reads the first row of your spreadsheet as column names. If your first row says "First Name", "Last Name", "Address", the tool knows to look for those exact fields. If your headers say "FN", "LN", "Addr", the merge will still work, but you will have to tell the tool which column is which.

Put one piece of information per column. "John Smith" in one cell is harder to work with than "John" in one column and "Smith" in another, because most label templates let you arrange first and last names separately. If you have a column for "Full Address" with the street, city, state, and ZIP all together, split it into separate columns before you merge.

Remove any blank rows or columns in the middle of your data. Mail merge stops reading when it hits an empty row, so if row 5 is blank and your data continues in row 6, the merge will skip everything below row 5. Check that every person in your list has at least a name and address filled in — if a field is truly empty, leave the cell blank rather than typing "N/A" or a dash.

Using mail merge in Microsoft Word

Open Word and go to the Mailings tab at the top. Click Start Mail Merge, then choose Labels. A dialog box will ask you to pick a label size — Avery 5160 is the most common, but scroll through the list if you have a different brand or size. Word will create a blank label template for you.

Next, click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will ask which sheet you want to use (if your file has multiple sheets) and whether the first row contains headers — say yes. The tool now knows where your data is.

Click in the first label box and then click Insert Merge Field. A dropdown menu shows all the column headers from your Excel file. Click the ones you want in the order you want them — usually First Name, then Last Name, then Address, City, State, ZIP. Press Enter between fields to put them on separate lines. Once the first label is set up, click Update Labels and Word copies that format to every label on the page.

Click Preview Results to see what the labels will look like with real data from your spreadsheet. Scroll through a few to make sure names and addresses are in the right places. If something is wrong, go back and fix either the template or your Excel file, then preview again.

When everything looks right, click Finish & Merge and choose either Print Documents (to send straight to your printer) or Edit Individual Documents (to save as a Word file you can edit by hand before printing). If you choose to edit, Word creates a new document with all your labels merged in — you can fix typos or delete labels you do not need.

Using mail merge in Google Docs

Google Docs does not have mail merge built in, but a free add-on called Mail Merge for Docs does the same job. First, move your data to Google Sheets instead of Excel — you can upload your Excel file directly to Google Drive and Google will convert it, or copy and paste the data into a new Google Sheet.

Open a new Google Doc and go to Extensions in the menu. Click Add-ons, then Get add-ons, and search for "Mail Merge for Docs". Click the result, then Install. Google will ask for permission to access your Google Drive — this is how the add-on finds your spreadsheet.

Go back to your Google Doc. Under Extensions, find Mail Merge for Docs and click Open. A sidebar appears asking you to select your Google Sheet. Choose the sheet with your data. The add-on reads the column headers and shows them in a list.

Type your label template in the main document — use the same format as Word (first name, last name, address on separate lines). Highlight the field names you want to merge (for example, highlight "First Name" in your template), then click the matching field in the sidebar. The add-on replaces that text with a merge code. Repeat for every field.

Click Merge in the sidebar. The add-on creates a new document with all your labels filled in. You can then print it or save it as a PDF.

Choosing between printing and saving as PDF

If you print directly from Word or Docs, the labels go from your computer to your printer with no stops in between. This is the most private route if you are concerned about data leaving your device.

Saving as a PDF gives you a file you can print later, share with someone else, or store. The PDF stays on your computer unless you upload it somewhere. If you save it to a cloud service like Google Drive or OneDrive, that service can see the file — but it is still your data, not sent to a third party.

If you are using a document editor specifically because you wanted to avoid certain cloud services, remember that Word's mail merge works the same way whether you save the result or print it. Google Docs always saves to Google Drive by default, so if that was a reason you chose a different editor, use the Word method instead.

Fixing mistakes before you print

If you notice a typo or wrong address after the merge is done, you have two options. You can go back to your Excel or Google Sheet, fix the original data, and run the merge again — this is faster if you have many labels to redo. Or you can edit the merged document by hand, which works better if only a few labels need changes.

In Word, after you click Finish & Merge and choose Edit Individual Documents, you get a new document where you can click into any label and type corrections. In Google Docs, the merged document is a regular Google Doc, so you can edit it the same way.

If you print directly without saving first, you cannot go back and fix anything — the labels are already printed. For that reason, it is worth doing a test print on regular paper first, checking a few labels for errors, and then printing on your actual label sheets.

Frequently Asked Questions

What if my Excel file has middle names or suffixes?

Add them as separate columns — "First Name", "Middle Name", "Last Name", "Suffix" — and include them in your merge template in the order you want them to appear. You can add spaces or commas between fields by typing them directly in the template.

Can I merge only some of the rows in my spreadsheet?

Yes. In Word, after you select your data source, you can click Edit Recipient List and uncheck the rows you do not want to merge. In Google Docs with Mail Merge for Docs, you will need to delete the rows from your Google Sheet first, then run the merge.

What label sizes does Word support?

Word has templates for most common label brands and sizes, including Avery, Staples, and generic options. When you click Label Options in the mail merge setup, you can search by brand name or scroll through the full list. If your labels are an unusual size, you can create a custom template by setting the page margins and label spacing yourself.

Do I need to save my Excel file in a specific format?

Word and Google Docs both read standard Excel files (.xlsx) without any conversion. If your file is in an older Excel format (.xls), it will still work. CSV files (comma-separated values) also work if you have exported your data that way.

Can I use the same merged document for different label sizes?

No — the label template is tied to a specific size. If you need the same data on different label sizes, create a separate mail merge for each size. The good news is that once you have set up the merge fields the first time, setting up a second one takes just a few minutes.