How to mail merge from Excel to Gmail
Save your Excel sheet as a CSV file, upload it to Mailroom, and write one email using your column headings as merge tags. Each row receives its own personalised email from your Gmail address. Word and Outlook's mail merge only sends through Outlook; this route sends through Gmail.
Step by step
Tidy the sheet
Put the headings in row 1 (for example Email, First Name, Company) and one person per row. Remove merged cells and blank rows at the top.
Save as CSV UTF-8
In Excel choose File, Save As, and pick CSV UTF-8 (Comma delimited). The UTF-8 option keeps accented and non-English characters intact.
Sign in with Google
Go to themailroom.cc and choose Continue with Google. This signs you in and connects the Gmail account you will send from. Mailroom asks only for permission to send; it cannot read your inbox.
Upload the CSV
Create a project and drop the file in. Mailroom finds the email column and lists your other headings as merge tags. Rows with unusable addresses are flagged with their Excel row number.
Write one email with merge tags
Write the subject and body once. Wherever you want a value from the spreadsheet, type the column name in double curly braces, for example {{first_name}}. You can use bold, italic and links.
Preview and send yourself a test
Step through the preview to see exactly what each person will receive, then send a test to your own address. Mailroom warns you if a tag does not match any column.
Send, or schedule it
Press send. Each recipient gets their own individual email from your Gmail address, about one a second. Or pick a date and time and Mailroom sends it then.
Good to know
- Only the first worksheet is saved when you export to CSV. Move the list to the first tab, or save that tab on its own.
- Dates and numbers are sent as they appear in the CSV. If Excel shows 01/02/2026, that text is what the recipient sees.
- Uploading the .xlsx file itself does not work: it has to be saved as CSV first.
- Gmail itself allows 500 recipients a day from a personal @gmail.com account and 2,000 a day from Google Workspace. No tool can raise that.
- Mailroom's free tier sends 100 emails a day and 300 a month. A 7-day pass (£7.99 / $9.99, one payment) or Pro (£15.99 / $19.99 a month) lifts that to Gmail's own limit.
Common questions
Can I use Word's mail merge with Gmail?
Not directly. Word's email merge sends through Outlook. To send through Gmail you need a tool that connects to Gmail, which is what this method does.
My names show strange characters after exporting. Why?
The file was saved as plain CSV rather than CSV UTF-8. Save it again choosing the UTF-8 option.
Does it work with Excel on a Mac, or with Numbers?
Yes. Excel for Mac has the same CSV UTF-8 option, and Numbers can export CSV from File, Export To.
Related
Send your first one in five minutes
Sign in with Google, upload a CSV, write one email. 100 a day free.
Start with Mailroom