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.
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).