File Format Conversion from Microsoft Office

Can I use Mail Merge add-on with Microsoft Word documents, Microsoft Excel Spreadsheets, and Microsoft PowerPoint presentations?

This article describes how to convert file formats from Microsoft Word into Google Docs, Microsoft Excel into Google Sheets, and Microsoft PowerPoint into Google Slides, to allow Mail Merge add-on to be used with Microsoft Word documents, Microsoft Excel spreadsheets, and Microsoft PowerPoint presentations.

There is no Extensions or Add-ons option on the menu bar in a Microsoft Word document, Microsoft Excel spreadsheet, or Microsoft PowerPoint presentation open in Google Workspace, which prevents the use of Mail Merge add-on. To use Mail Merge add-on, you need to convert:

a Microsoft Word document into a Google Docs file format
a Microsoft Excel spreadsheet into a Google Sheets file format
a Microsoft PowerPoint presentation into a Google Slides file format

In Google Workspace from your Microsoft Word document, Microsoft Excel spreadsheet, or Microsoft PowerPoint presentation, click on File > Save as Google Docs/Google Sheets/Google Slides to create a copy of the file in a Google Docs, Google Sheets, or Google Slides file format, from which you can use Mail Merge add-on.

Microsoft Word Document in Google Docs

Microsoft Excel Spreadsheet in Google Sheets

Microsoft PowerPoint Presentation in Google Slides

If you are mail merging from Google Docs or Google Slides, Mail Merge add-on automatically converts your Microsoft Excel spreadsheet into a Google Sheets file format, so there is no need to do this file format conversion manually prior to a mail merge. The Microsoft Excel spreadsheet appears in the Select a Spreadsheet File dialog box (see screenshot below).

When the Microsoft Excel spreadsheet is converted automatically into a Google Sheets file format, the original Microsoft Excel spreadsheet remains (see screenshot below).