Migrate from MS Office
Can I use the Mail Merge add-on with my Microsoft Word Documents, Microsoft Excel Spreadsheets and Microsoft PowerPoint Presentations?
This article describes how to convert file formats from Microsoft Word to Google Docs, Microsoft Excel to Google Sheets and Microsoft PowerPoint to Google Slides, enabling the Mail Merge add-on to be used with existing Word documents, Excel spreadsheets and PowerPoint presentations.
If you open a Word document, Excel spreadsheet or PowerPoint presentation from Google Workspace and try to mail merge, you will note that there is no Extensions or Add-ons option on the menu bar. To run the Mail Merge add-on, you first need to convert your Word document to Google Docs format, your Excel spreadsheet to Google Sheets format or your PowerPoint presentation to Google Slides format.
From your Word document, Excel spreadsheet or PowerPoint presentation, click File > Save as Google Docs/Sheets/Slides. This will create and open a copy of your file in Google Docs/Sheets/Slides format, from which you can run the Mail Merge add-on as normal.
Microsoft Word Document
Microsoft Excel Spreadsheet
Microsoft PowerPoint Presentation
NOTE: If you are merging from Google Docs or Google Slides, the add-on will automatically convert your Microsoft Excel source spreadsheet into Google Sheets format; there is no need to do this manually prior to merging. Your Excel spreadsheet will appear in the Select a Spreadsheet File dialog box (see screenshot below).
During the mail merge process, your original Excel spreadsheet will be preserved and a copy of your spreadsheet will be created automatically in Google Sheets format.