Previewing a merge
Write the template
Use
{{column_name}}or{column_name}for each field. Add a fallback after a vertical bar, as in{{first_name|there}}, for columns that are sometimes empty.Paste sample data with a header row
The first line must hold column names. Matching ignores case, spaces and punctuation, so
First Name,first_nameandfirstnameall fill{{first_name}}.Check the token list
Under the boxes the tool lists every token it found in the template. A typo such as
{{compnay}}shows up here.Read each merged email
Each row gets a card: "All tokens filled" in green, or "Missing:" in red with the names of the empty fields. A missing field without a fallback is left as the raw token so you cannot miss it.
Download if useful
Download merged emails gives a CSV with the row number, the finished text and any missing fields, handy for a final review in a spreadsheet.
Example: a vet and a café from the same list
A supplier of out-of-hours phone answering (fictional) pasted two rows. The first has no service filled in, the second has no first name.
Row 1 is flagged because service has no fallback, and the raw token stays in the text. Row 2 is fine: the empty first name falls back to "there". The fix is either to fill the column or to give the token a fallback such as {{service|out of hours}}.
Template:
Hi {{first_name|there}}, is {{company}} in {{town}} still taking {{service}} enquiries?
Data:
first_name,company,town,service
Aisha,Kettle & Crumb,Harrogate,
,Moorside Vets,Skipton,out of hoursRow 1 Missing: service
Hi Aisha, is Kettle & Crumb in Harrogate still taking {{service}} enquiries?
Row 2 All tokens filled
Hi there, is Moorside Vets in Skipton still taking out of hours enquiries?Token behaviour at a glance
| You write | Value present | Value empty or column missing |
|---|---|---|
{{company}} | Replaced with the value | Left as {{company}} and listed as missing |
{{first_name|there}} | Replaced with the value | Replaced with there |
{company} | Replaced with the value | Left as {company} and listed as missing |
{{ First Name }} | Spaces and case ignored when matching the column | Same as above |
Before you load the list into a sending tool
- Paste the five or six messiest rows, not the first five: blanks, long names, names with apostrophes and ampersands.
- Give a fallback to every token whose column is not filled for 100% of rows.
- Check capitalisation in the source. A business name scraped in capitals will merge in capitals.
- Confirm your sending tool uses the same token style. Some expect double braces, others single, others square brackets.
- Remove any row where the company field holds something that is not a business name, such as a page title.
Questions people ask
What is a mail merge fallback?
A fallback is the text used when a field is empty. Written as {{first_name|there}}, it produces "Hi Aisha" when a name exists and "Hi there" when it does not. It is the simplest way to stop a blank field turning into an awkward greeting, and this formatter shows you which rows are relying on it.
Why is a token left in the email instead of removed?
Deliberately. If a field is empty and has no fallback, removing the token silently would produce sentences such as "is Kettle & Crumb in still taking enquiries". Leaving {{service}} visible and listing it as missing makes the problem impossible to overlook while you are still reviewing.
Can I paste a full export from Excel?
Yes, as comma-separated text with a header row. Large pastes work, but the page shows a card for every row, so a sample of the trickiest rows is easier to review. If your export uses semicolons, convert it to commas first, and save with UTF-8 so names with accents come through correctly.
Does this send the emails?
No. It only shows and exports the merged text. Sending is done by your own mailbox or a sending tool, which should also handle opt-outs, suppression of people who asked not to be contacted, and sensible daily limits.
Where your data goes
Your template and the sample rows are merged by script running locally in this browser tab. No row of your lead list is uploaded, and the download is created on your device.
Checked against the tool on