File Format Conversion from Microsoft Office
Can I use 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, to allow Mail Merge add-on to be used with existing Word documents, Excel spreadsheets, and PowerPoint presentations.
There is no Extensions or Add-ons option on the menu bar in a Word document, Excel spreadsheet, or PowerPoint presentation open from the Google Workspace, preventing use of Mail Merge add-on. To run Mail Merge add-on, you need to convert:
A Word document to a Google Docs format
An Excel spreadsheet to a Google Sheets format
A PowerPoint presentation to a Google Slides format
From your Word document, Excel spreadsheet, or PowerPoint presentation, click on File > Save as Google Docs/Sheets/Slides, to create a copy of the file in a Google Docs/Sheets/Slides format, from which you can run Mail Merge add-on.
Microsoft Word Document
Microsoft Excel Spreadsheet
Microsoft PowerPoint Presentation
NOTE: If you are merging from Google Docs or Google Slides, Mail Merge add-on automatically converts your Microsoft Excel source spreadsheet into a Google Sheets format, so there is no need to do this file format conversion manually prior to a mail merge. The Excel spreadsheet appears in the Select a Spreadsheet File dialog box (see screenshot below).
During the mail merge process, a copy of the spreadsheet is created automatically in a Google Sheets format, preserving the original Excel spreadsheet.