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
- 1Write your template using {{Column Name}} for anything personal.
- 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
- Merge CSV Files (Append or Join)
Combine two CSV files — stack rows (matching columns by header name) or join them on a shared key column like a VLOOKUP.
- Sign-Up Sheet Maker
Make a printable sign-up sheet for volunteers, potlucks, classes or events — with your own columns and number of rows.
- Pivot Table Tool (Summarize CSV & Excel Data)
Summarize spreadsheet data with a pivot table in your browser — group by rows and columns, sum, count, average, min or max, group dates by month, quarter or year, and export to Excel.
- CSV Cleaner & Deduplicator
Clean up a CSV file — trim spaces, remove empty rows and duplicate rows (or duplicates by one column), and fix ragged rows — all in your browser.
- Word Tables to Excel Converter
Pull every table out of a Word document into an Excel workbook, one sheet per table or all on one sheet. Merged cells stay merged, header rows are kept, and numbers, currencies and percentages typed as text become real numbers you can sum.
- Word to PDF
Convert a .docx document to PDF in your browser — headings, lists, tables and pictures carried over.