How to create a mail merge in Gmail from an Excel file?

- Updated: Jan 1, 2022

Gmail is the most popular email platform, with over 1.8 billions active users in 2022. Unfortunately, Gmail does not have a built-in solution to send a mail merge from an Excel. You need to use a third-party solution such as Mailmeteor, which let you send a mail merge from an Excel file (or a .CSV).

First, here’s what you need to send emails in Gmail using an Excel file:

  • Have a Gmail account or a Google Workspace account (formely GSuite);
  • Have a mailing list in an Excel file (here’s an example).

Now let’s see the 5 steps to reproduce to send emails to your mailing list stored in an Excel file.

Step 1. Import your Excel file in Google Sheets

  1. Open a new Google Sheets.
  2. In the menu, select “File” > “Import”. Import an Excel file in Google Sheets
  3. Head over to “Upload” and drag & drop your Excel file. Drag & Drop an Excel file in Google Sheets
  4. Once the file is uploaded, click on “Replace spreadsheets” to complete the import.
  5. Your Excel file is now imported in Google Sheets: An Excel file imported in Google Sheets

Here’s a video tutorial on how to do it:

Step 2. Open Mailmeteor

Right from Google Sheets, in the menu, select “Add-ons” > “Mailmeteor” > “Open Mailmeteor”

Open Mailmeteor from the Add-ons menu in Google Sheets

If you don’t have Mailmeteor, just open this link to install the add-on in a few seconds.

Mailmeteor is the top rated add-on for Google Workspace. It's built with privacy in mind and you can use it for free to send up to 75 emails/day. If your Excel file has more contacts, look at our pricing plan.

Step 3. Compose your template in Mailmeteor

  1. In Mailmeteor, click on “Create a new template”: Compose an email for a mail merge in Mailmeteor
  2. Then, write the subject line as well as your email: Example of a draft for a mail merge in Mailmeteor
  3. Once you are ready, click “Save template”!

Step 4. Preview your email

Previewing your email before sending it is a good practice to make sure everything looks right.

  1. In Mailmeteor, click on “Preview emails”: Preview button in Mailmeteor
  2. The preview renders exactly as your recipient will see your email: Preview of a mail merge in Mailmeteor

If you need to make a change, just click on the A pen icon icon. Then you can preview the email again.

Step 5. Hit send!

Whenever you’re ready, click on “Send emails” and your emails will shortly be sent with Mailmeteor.

Sending email for a mail merge in Mailmeteor

It has never been so easy to send a mail merge from Gmail - even with an Excel file!

This guide was written by Jean Dubrulle, Mailmeteor’s founder. Mailmeteor is a simple & privacy-focused emailing software. Trusted by millions of users worldwide, it is often considered as the best Gmail mail merge to send mass personalized emails. Give us a try and let us know what you think!

Start sending emails with Mailmeteor