Skip to content
Home
/
Free tools
/
Mail merge previewer
Free tool

Mail Merge Previewer: See Every Personalized Email

Paste a CSV from Sheets or Excel and a template, then preview every personalized email and spot [tokens] with no data. Free, no sign-up.

Free with no sign-up. Everything runs in your browser: nothing is uploaded or stored.

1. Your list

Paste straight from Google Sheets or Excel, including the header row.

2. Your template

Use [tokens] that match your column names, for example [first name] or [company].

Paste a list and write a subject or body to see each personalized email.

How it works

  1. Copy the cells from Google Sheets or Excel, including the header row, and paste the list.
  2. Write a subject and body using [tokens] that match your column names.
  3. Every row is rendered with its own values, so you read exactly what each person receives.
  4. Tokens with no column or a blank cell stay visible in yellow so nothing half-finished gets sent.
  5. Copy one email, or copy all of them into your sending tool.

Why preview before sending

A merge mistake is permanent: a blank first name, a raw [company] token, or a value from the wrong row is already in someone's inbox before you notice. Previewing every row takes a minute and catches the errors that templates and spreadsheets hide. This tool only previews; it never sends and nothing is uploaded.

For a single email, use the email personalizer. To check the template against your column names before pasting data, use the token checker.

Frequently asked questions

Does this tool send the emails?

No. It only renders a preview of each personalized message so you can check the merge before sending. Copy the results into your email tool, or use the personalizer for a single message.

How do I paste my Google Sheets list?

Select the cells including the header row, copy, and paste into the list box. Commas, semicolons, and tabs are detected automatically. If your sheet has no header row, turn off the first-row-is-headers switch.

Why does a [token] stay in brackets after previewing?

Two reasons: the token has no matching column name, or the cell for that row is empty. Both are listed under the preview so you can fix the data or the template before sending anything.

How many rows can I preview?

The preview shows up to 200 rows at once, which is enough to spot merge problems. Copying all emails includes every row in the pasted list.

Answer every email. Approve every send.

Connect Gmail, name your labels, and approve your first AI draft today.

14-day free trial

No credit card

Nothing sends without approval

Disclaimer: these free tools are provided for general information only, as-is and without warranties of any kind. They are not legal, compliance, security, financial, or other professional advice, and no result is a guarantee that a message will be delivered, accepted, or compliant. You are responsible for reviewing every result before relying on it or sending anything based on it. To the maximum extent permitted by law, Tutti accepts no liability for any loss or damage arising from the use of these tools or from reliance on their output. Your use is also governed by our Terms of Service.