Mail Merge Word and Google Sheets: How to Connect Them

Yes—you can use a Google Sheets list for a mail merge in Microsoft Word, but Word does not connect directly to a live Google Sheet. Download the sheet as an Excel workbook or CSV file, then select that saved file in Word through Mailings > Select Recipients > Use an Existing List.

How Word and Google Sheets work together

Google Sheets holds and organizes the recipient information; Word uses that information to create a personalized document. For example, a sheet can contain each customer’s name, address, and renewal date, while a Word letter contains fixed text plus fields that Word replaces with the values from each row.

The key limitation is that the connection is to a file on your computer, not to the sheet’s online URL. Changes made in Google Sheets after you export the file will not automatically appear in a merge already connected to the earlier download. Export a fresh copy when the list changes, and check that Word is using the latest file before producing the final documents.

This workflow is useful for letters, labels, envelopes, and other documents prepared in Word. It does not mean that Word can send mail directly through a Google Sheets link, or that a Google Sheet itself becomes a Word document.

Prepare the recipient list in Google Sheets

Set up the sheet as a simple table before exporting it. The first row should contain a distinct heading for each kind of information, and each subsequent row should represent one recipient. For example, columns might be FirstName, LastName, Email, Street, City, and RenewalDate. Word uses these headings to identify the fields you can insert into the document.

Use one column per field. Keep a full name together or split it into first and last name columns according to how you plan to address people.
Remove blank rows above the headings and avoid blank heading cells, merged cells, and decorative title rows in the data range.
Check for duplicate recipients, spelling errors, and missing values. A blank cell will generally produce a blank merge field, not a message explaining what is missing.
Keep postal codes, account numbers, and phone numbers that may start with zero as text. If Sheets has already interpreted a value as a number, verify how it appears in the exported file.
Use consistent date and address formats. Try a few records with short and long names, apartment details, or non-US postal formats if those occur in your list.

A clean table prevents many problems later. If a letter needs to say Dear Jordan rather than Dear Jordan Lee, a separate FirstName column makes that choice straightforward. If you need a combined display field, you can also add a helper column in Sheets and export the result as another heading.

Export the sheet as Excel or CSV

In Google Sheets in a web browser, use File > Download > Microsoft Excel (.xlsx) to save an Excel workbook. This is usually the best first choice when Word is the destination: it can retain multiple tabs in one workbook and is convenient when you want to keep a spreadsheet file for later updates. When Word connects to it, select the tab that contains the recipient table.

For a simpler list, use File > Download > Comma-separated values (.csv). A CSV is a text file rather than a full spreadsheet workbook. It is suitable for a single, straightforward table, but does not preserve workbook features such as multiple tabs, formulas as formulas, or cell styling. Confirm that you exported the correct tab and inspect the file if the data includes unusual characters, leading zeros, or dates.

Save the downloaded file somewhere you can find it again, such as a dedicated project folder. Give it a clear name, such as Spring_Event_Recipients.xlsx. If you later export an updated list, either overwrite the same file or note the new filename so you do not accidentally merge from an older copy.

Connect the file to Word

For the full mail-merge workflow, use the Word desktop app. In Microsoft Word for Microsoft 365 on Windows, open a new document or the letter you want to personalize, then follow these steps:

Open the Mailings tab and choose Start Mail Merge. Select Letters for a personalized letter; choose another document type if you are preparing labels, envelopes, or a directory.
Choose Select Recipients > Use an Existing List.
Browse to the downloaded .xlsx or .csv file and select it. If Word displays a dialog asking you to choose a table or worksheet, select the tab or data range containing the headings and recipient rows. Confirm that the option indicating the first row contains column headings is selected when offered.
Choose Edit Recipient List to inspect the records. You can review the entries and, where appropriate, filter or sort the recipients before merging.

Once Word has connected to the file, the document is the main mail-merge document and the spreadsheet is its data source. Keep the source file in place while working. Moving or renaming it can leave Word unable to find the linked list, in which case you may need to connect the source again.

Word for Mac also has mail-merge tools, though some dialog names and file-selection details can differ by release. Look for the Mailings tab and its recipient-selection controls, then select the downloaded workbook or CSV. Word for the web does not provide the same complete desktop mail-merge workflow; use the desktop app to set up and finish the merge.

Insert fields and preview the results

Write the parts of the letter that are the same for everyone, leaving spaces where recipient-specific details belong. Put the cursor at the insertion point, then use Mailings > Insert Merge Field and choose the matching heading. A letter might begin with Dear, followed by the FirstName field, and later include the recipient’s address or renewal date.

The field labels shown in Word come from the spreadsheet headings. If a heading is confusing or contains an accidental blank space, fix it in Sheets and export the source again rather than guessing which field Word selected. Use Preview Results on the Mailings tab to cycle through records and see how the real values fit into the document.

Preview several different rows, not just the first one. Long names can wrap, missing values can leave awkward punctuation, and a date or number may appear in a format you did not expect. A greeting such as Dear followed by a blank first name may need a different approach for records with no name. Correct the data or adjust the document before generating a large batch.

Finish the merge and check the output

When the preview looks right, choose Mailings > Finish & Merge. For letters, Edit Individual Documents creates a new document containing the merged records, which is useful when you want to inspect, revise, or save the batch as one file. Print Documents sends the merged output to the printer. The exact choices depend on the merge type selected at the beginning.

For a first run, create individual documents or merge only a few selected records, then review the result before printing or distributing the full batch. Confirm that names, addresses, dates, page breaks, and salutations are correct. A merge can produce many pages quickly, but it does not verify that the source data is accurate.

Word can also use a mail merge to send email messages, but that is a separate workflow from creating letters. Email merging depends on Word’s supported desktop mail setup and may not work with every mail application or account configuration. Do not assume that selecting an Email Messages merge type will send through Gmail simply because the recipient list came from Sheets. Test the setup with a small, appropriate group before relying on it.

Choose between XLSX and CSV

Use XLSX when the list has multiple tabs, when you expect to update it, or when you want to keep a familiar spreadsheet file as the source. It is generally easier to identify the correct worksheet in a workbook. However, it is still worth checking how Word interprets formatted values such as dates, currency, and numbers with leading zeros.

Use CSV when the recipient data is a single, plain table and you want a lightweight file that most programs can read. It is not a live connection, and it does not carry the workbook’s formatting or separate worksheets. If a CSV opens with columns in the wrong places or characters displayed incorrectly, check the export and import behavior rather than assuming the merge fields themselves are at fault.

Neither format keeps Word synchronized with the online Sheet. For a recurring campaign, create a repeatable routine: update the Sheet, download a new file, confirm the saved date or filename, reconnect or refresh the recipient source as needed, and preview the output again.

Common problems and practical fixes

Word cannot find the file: Check that the workbook has been downloaded to the location you selected and has not been moved or renamed. Use Select Recipients to choose the correct source again if necessary.
Headings appear as records: The first row may not have been recognized as column names. Check the source layout and the heading-row option in Word’s connection dialog.
Wrong worksheet or incomplete list: A workbook can contain several tabs. Reconnect and select the tab with the actual header row and recipient data, then inspect the recipient list.
Dates or numbers look different: Preview the merged document and verify the exported file. Spreadsheet display formatting does not always appear exactly as expected in a Word field. For critical values, use a clearly prepared text column in the source and check the final output.
Zeros disappear from codes or phone numbers: Store these values as text in Sheets and verify that the exported version retains them. Treating an identifier as a number can remove information that matters.
New rows are missing: Word may still be using an earlier export or recipient connection. Download the current sheet and reconnect to that file, then confirm the last expected recipient is present.

Privacy, cost, and other ways to do a merge

The spreadsheet and Word document may contain names, addresses, or other personal information. Save the export in an appropriate location, limit access to people who need it, and remove temporary copies when they are no longer needed under your organization’s rules. A downloaded file can remain on a computer even after the online sheet is changed or deleted, so consider where it is saved and backed up.

There is no separate fee just for exporting a Sheet as XLSX or CSV, but access to Google Sheets and desktop Word depends on the account, software, and licensing available to you. Features and eligibility can vary, so check the terms for your own Google and Microsoft accounts rather than assuming every account has the same capabilities.

If you want to stay within Google’s tools, Gmail offers mail-merge features for eligible accounts, including workflows that can use information from Google Sheets. Availability and limits depend on the Google account or Workspace edition. That route is different from a Word mail merge: it is worth considering when sending email is the goal, while Word is the natural choice for formatted letters, labels, and print-ready documents. Third-party add-ons and scripts are other options, but review their permissions and data handling before giving them access to a recipient list.

Frequently Asked Questions

Can Word mail merge directly from a Google Sheets URL?

No. The typical Word workflow uses a downloaded Excel workbook or CSV file as its recipient source. Export the latest version of the Sheet, then select that file in Word.

Which download format is better for a Word mail merge?

XLSX is a good default for a workbook or a list with multiple tabs. CSV works well for one plain table. In either case, check the selected tab, headings, and output values before merging.

Will changes in Google Sheets update my Word merge automatically?

No. Word is connected to the exported file, not to a live Google Sheet. Download the updated data and make sure Word is using that current file before you create the merged documents.

Can I use Google Sheets with Word for email mail merge?

You can use an exported Sheet as the recipient source for a Word email merge, but sending depends on Word’s compatible desktop email setup. Gmail is not automatically connected just because the data came from Google Sheets; test your configuration before sending.

Can I do the whole mail merge in Word for the web?

For the complete setup and merge process, use the Word desktop app. Word for the web does not offer the same full mail-merge workflow as the desktop version.

Why are my dates or postal codes wrong after merging?

Word may interpret spreadsheet values differently from how they look in Sheets, and numeric treatment can remove leading zeros. Check the downloaded file and preview multiple records; prepare identifiers as text and use clearly formatted source values where needed.

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.