Map Extract
Free tool

Mail merge a Word template with a spreadsheet

Choose a Word template with fields such as {{Business}} and a CSV or spreadsheet with matching columns. Preview each row, then download one Word file per row, one long document with a page per row, or a single PDF.

Runs in your browser. Nothing you enter is uploaded.

A follow-up letter after a trade fair

The template has four fields: {{First name}}, {{Business}}, {{Town}} and {{Pieces}}. The data has two rows; the second uses lower-case column names with underscores and has no Pieces column.

Both rows fill First name, Business and Town, because column names are matched ignoring case, spaces and underscores. For the second row, {{Pieces}} stays in the text and is reported as not filled, so you catch it in the preview. With the file name pattern Letter {{Business}}, the files are called Letter Copperleaf Florist.docx and Letter Fairfield Opticians.docx.

Input
Template: Dear {{First name}}, ... our trade price list for {{Business}} in {{Town}}. Your first order of {{Pieces}} pieces ...

Data:
First name,Business,Town,Pieces
Mel,Copperleaf Florist,Bolton,36

first_name,business,town
Raj,Fairfield Opticians,Manchester
Result
Row 1: Dear Mel, ... trade price list for Copperleaf Florist in Bolton. Your first order of 36 pieces ...
Row 2: Dear Raj, ... trade price list for Fairfield Opticians in Manchester. Your first order of {{Pieces}} pieces ...  (not filled: Pieces)

Running a merge

  1. Add the template

    Under 1. Word template, choose a DOCX. The fields found are listed. Fields can be written {{Name}}, «Name» or as Word MERGEFIELD fields, in the body, headers, footers, footnotes or endnotes.

  2. Add the data

    Under 2. Data, choose a CSV, TSV or spreadsheet (the first sheet is used), or paste CSV. The first row must hold the column names.

  3. Check the fields

    A message confirms every field has a column, or lists the ones without. Step through rows with Previous and Next to preview each filled document.

  4. Name the files

    Set File names with fields, such as Letter {{Business}}.

  5. Download

    Choose Download Word files (ZIP), One document, a page per row, or the PDF option, which makes a single PDF from all rows.

Letters, labels and proposals for a short list

Mail merge is at its best for a few dozen personalised documents: follow-up letters after an event, proposals for a shortlist of stockists, certificates for a training day or payment reminders. Word's own mail merge does this too, but it needs Word on the computer and a few too many steps for a one-off job. Samples on the page (a sales letter, a certificate and a payment reminder) show the idea before you build your own.

Formatting in the template is kept: each value goes into the run where its field starts, so bold, fonts and colours around it stay the same, even when Word has split a field across several runs while you were editing.

Before you print or send

  • Every field has a matching column, or you have decided to leave it.
  • You have previewed the first, the last and a couple of rows in between.
  • Names and businesses are spelled as the recipients spell them.
  • Letters that market to people include a clear way to opt out, and the list has been checked against your suppression records.

Questions people ask

How do I do a mail merge from Excel to Word without Word?

Choose your DOCX template and your Excel or CSV file here. Fields in the template such as {{Company}} are filled from the matching columns, and you download one Word file per row in a ZIP, one combined document, or a PDF. Everything runs in the browser, so Word is not needed.

What field formats does it understand?

Three: double curly braces such as {{First name}}, French quotes such as «First name», and Word's own MERGEFIELD fields created through Word's mail merge tools. Field names are matched to column names ignoring case, spaces, hyphens and underscores, so First_Name and first name both match.

What happens if a column is missing?

Fields without a matching column are listed in a warning before you merge, and they stay in the documents as written, for example {{Pieces}}. If a column exists but a row has no value, the preview tells you which fields were not filled in that row. Rename the column or the field to fix it.

How many rows can I merge?

Up to a few thousand rows work well; the merge runs in your browser, so very large merges are best split into batches. One Word file per row is the most flexible output. For printing, one document with a page per row or a single PDF is easier to handle.

Where your data goes

The template and the data stay in your browser. Every document is filled and packed on this page, and nothing is uploaded or emailed.

Checked against the tool on

Top