Map Extract
Free tool

Email template formatter and mail merge preview

Write a template with merge tokens, paste a few rows of your lead list as CSV, and see each finished email exactly as the recipient would. Rows where a token has no value are marked in red before anything is sent.

Runs in your browser. Nothing you enter is uploaded.

Previewing a merge

  1. 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.

  2. Paste sample data with a header row

    The first line must hold column names. Matching ignores case, spaces and punctuation, so First Name, first_name and firstname all fill {{first_name}}.

  3. 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.

  4. 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.

  5. 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}}.

Input
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 hours
Result
Row 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 writeValue presentValue empty or column missing
{{company}}Replaced with the valueLeft as {{company}} and listed as missing
{{first_name|there}}Replaced with the valueReplaced with there
{company}Replaced with the valueLeft as {company} and listed as missing
{{ First Name }}Spaces and case ignored when matching the columnSame 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

Top