Account

What new tool do you want?

Office & Documents

Mail Merge (Template + CSV)

Personalize letters, emails or messages in bulk — write a template with {{placeholders}} and merge it with a CSV list of names and details.

How to use

  1. 1Write your template using {{Column Name}} for anything personal.
  2. 2Paste the CSV (first row = column names) on the right. Each row produces one copy.

How it's calculated

Every {{placeholder}} is replaced with the matching column value (case-insensitive). Unknown placeholders are listed so you can fix typos.

Frequently asked questions

Can I add a fallback if a value is missing?

Yes — write {{First Name|there}} and 'there' is used when the cell is empty.

How do I send the results as emails?

Copy each message into your email client, or use your email platform's own merge feature with the same CSV.

Can I export to Word?

Copy the output into Word or Google Docs — each merged copy is separated by a line.

Matching is forgiving about capitalization, not about typos

{{First Name}} and {{first name}} resolve to the same CSV column because matching is case-insensitive, but {{Frist Name}} won't match anything — it's a genuinely different string. Rather than silently leaving a blank, the merge leaves the placeholder text itself in the output and lists it under 'Unknown placeholders', so a typo in the template shows up as an obvious artifact instead of a quietly wrong letter.

The fallback syntax solves the 'blank cell' problem

{{First Name|there}} means: use the column value, or 'there' if that cell is empty for this row — handling the common case where a CSV export has some rows missing a name without a separate cleanup pass. The fallback is per-placeholder, so a template can treat a missing order number differently from a missing name in the same merge.

A worked example: a two-row order update

Template: 'Hi {{First Name|there}}, order {{Order}} ships {{Date}}.' CSV: First Name,Order,Date with rows Ana,#1001,May 3 and a blank name,#1002,May 4. The merge produces two copies separated by the chosen divider: 'Hi Ana, order #1001 ships May 3.' for the first row, and 'Hi there, order #1002 ships May 4.' for the second — the fallback 'there' filling in automatically where the first name cell was empty, with zero unknown placeholders reported since every tag in the template matched a column.

The greeting already includes a fallback for a missing first name

The template opens as Hi, then a first-name placeholder with the fallback word there, then a sentence about an order and a date. The separator between copies starts as five dashes. Placeholders match column names without caring about capitalization, and a name that matches nothing is listed so I can see the typo. The fallback form is the placeholder, a vertical bar, and the word to use when that cell is blank. Without that bar, a blank cell becomes a blank gap in the sentence. The letter box starts empty, with that greeting only as grey hint text until I paste it.

I need both the template and the table, and copies stay in row order

This one has two boxes, the letter and the data. Each data row becomes one copy, in the order I pasted them, with the dash line between copies. The summary counts the copies and names any unknown placeholders, or says none. Changing the separator changes every break at once, including making it a blank line if I clear that field. A column that exists but is empty uses the fallback when I wrote one, and otherwise leaves that spot empty rather than dropping the whole copy. Both boxes have to hold something before a merge appears.

Related tools

More: Office & Documents