About Mail Merge
Write a template once with placeholders like {{Name}} and generate one personalised document per row — letters, emails, certificates text or WhatsApp messages.
How to use Mail Merge
- Upload your recipient list.
- Write the template and insert fields by clicking them.
- Preview, then download a ZIP of files, one combined file, or a spreadsheet with a Message column.
Limitations
- Everything runs in your browser’s memory, so the practical file size depends on your device. As a rough guide: up to ~50 MB or ~500,000 rows works well on a modern laptop; phones and tablets handle much less.
- Very large files can make the tab slow or crash. If that happens, split the file first or use a desktop computer.
- Outputs keep values and formulas’ results but not formatting, charts, images, pivot tables or macros.
Frequently asked questions
Can it send emails?
No, it generates the text. Use the spreadsheet output with your email tool’s own merge feature.
Can I name each file after a column?
Yes, set the file name pattern, e.g. {{Name}}.
Which output formats are available?
TXT, HTML or Markdown files, or an XLSX with a Message column.
Disclaimer: Excel Tools by gumber.ai is a hobby project and is completely free to use. It is provided “as is”, without warranty of any kind. Always double-check results before relying on them, and keep a copy of your original files.
Related tools
Compare Excel Files
Spot changed cells, added rows and removed rows between two versions of a sheet.
Remove Duplicates
Find and remove duplicate rows based on all columns or just the ones you pick.
Excel VLOOKUP
Pull matching values from a second table into your sheet — no formulas, no #REF errors.
XLOOKUP / INDEX-MATCH
Look up any column in any direction and return one or many result columns.