How to Mail Merge Word Documents From a Spreadsheet

If you searched "how to mail merge Word documents," you probably have a template and a list of data, and need one personalized document per row. Maybe you need 200 offer letters with different names and salaries. Maybe you are generating certificates for every attendee at an event. Maybe you are producing personalized invoices or contracts from a client list.

Mail merge has been around for decades, but it has never been simple. Word's built-in wizard requires a data source connection, forces you through multiple dialog boxes, and was designed for printing, not for generating individual .docx files. Most people give up halfway through and do it by hand. This guide covers a faster way.

Why Word's built-in mail merge is painful

• It requires a data source connection. Word's mail merge wizard needs a direct connection to a data source like an Access database, an Excel file opened through a specific path, or Outlook contacts. You cannot just drop in a CSV.
• The wizard is confusing. The step-by-step wizard has six panels with options that do not clearly explain what they do. Most people get lost around step 3 and abandon the process.
• Output goes to the printer, not files. Word's mail merge was designed for printing letters or envelopes. Getting individual .docx files as output requires workarounds, macros, or third-party add-ins.
• You cannot easily generate separate documents. If you need one .docx per row (like individual contracts or certificates), Word does not support this natively. You end up with one giant document with page breaks, which you then have to manually split apart.
• It breaks frequently. Data source connections break when files are moved, renamed, or shared. The merge field syntax is fragile and error-prone.

How mail merge works step by step

Open the Document Generator, upload your Word template with placeholders, upload your CSV data, and get one personalized document per row, downloaded as a ZIP.

Step by step

1. Prepare your template. Create a .docx file with placeholders wrapped in double curly braces, like {{FirstName}}, {{Company}}, and {{Amount}}. These placeholders will be replaced with data from your spreadsheet.
2. Prepare your data. Create a CSV file where the column headers match your placeholder names exactly. Each row represents one document to generate.
3. Upload both files to the Document Generator. Drop the template and the CSV file.
4. Review the field mapping. The tool automatically matches your CSV columns to the placeholders in your template. Verify that everything is mapped correctly.
5. Generate and download. Click Generate. The tool creates one .docx file per row and packages them into a single ZIP download.

How to set up your template

The placeholder syntax is simple: wrap any field name in double curly braces.

Example template text:

Dear {{FirstName}},

We are pleased to offer you the position of {{JobTitle}} at {{Company}}, with a starting salary of {{Salary}} per year.

Rules for placeholders:

• Placeholder names must match your CSV column headers exactly (case-sensitive).
• You can use the same placeholder multiple times in one template.
• Placeholders work anywhere in the document: paragraphs, tables, headers, footers.
• If a placeholder in the template does not match any CSV column, it is left unchanged in the output.

Tip: Type your placeholders in one go. If you type {{, then go back and edit, Word sometimes splits the text into separate formatting runs behind the scenes, which can prevent the placeholder from being detected. The simplest fix: type the full placeholder (like {{FirstName}}) in a single pass without moving your cursor in the middle.

When to use mail merge

Offer letters. HR needs to send personalized offer letters to 50 new hires, each with a different name, job title, salary, and start date. One template, one spreadsheet, 50 ready-to-send documents in seconds.

Contracts. Generate client-specific contracts from a standard template. Each document gets the right client name, address, contract terms, and amounts filled in automatically.

Certificates. Event organizers, training programs, and schools need to produce certificates for every participant. Fill in names, dates, course titles, and scores from a spreadsheet.

Invoices. Freelancers and small businesses can generate monthly invoices from a template, pulling client names, amounts, dates, and project descriptions from a CSV.

Personalized cover letters. Job seekers applying to multiple companies can generate tailored cover letters by merging company names, positions, and other details into a single template.

Client reports. Consultants producing periodic reports for multiple clients can fill in client-specific data, metrics, and dates from a spreadsheet into a standard report template.

How does this compare to other methods?

	Word Mail Merge wizard	VBA macro	Google Docs add-ons	Online mail merge tools	PicoTools
Setup time	15-30 min	Hours (coding)	10-20 min	5-10 min	Under a minute
Produces separate .docx files	No (one big doc)	Yes (with coding)	No (Google Docs only)	Varies	Yes
ZIP download	No	Manual	No	Some	Yes
No software needed	No (Word required)	No (Word required)	No (Google account)	Yes	Yes
Works on Mac	Partial (limited wizard)	No (VBA limited on Mac)	Yes	Yes	Yes (any browser)
CSV support	Indirect	Yes	Yes	Yes	Yes
File privacy	Local	Local	Google servers	Uploaded to server	Local (browser only)

Your files never leave your device

All processing happens locally in your browser. Your template, CSV data, and generated documents are not uploaded, stored, or transmitted anywhere. This makes it safe to use with employee data, client information, salary details, or anything confidential.

---

Frequently asked questions

What placeholder format does it use?

Double curly braces: {{FieldName}}. The field name must match your CSV column header exactly, including capitalization.

Can I use an Excel file instead of CSV?

The tool accepts CSV files for the data source. If you have an Excel file, save it as CSV first (File > Save As > CSV in Excel or Google Sheets).

Is the formatting preserved?

Yes. The tool preserves all formatting from your Word template: fonts, sizes, colors, tables, headers, footers, and images. Only the placeholder text is replaced.

How many documents can it generate?

There is no fixed limit. Since everything runs in your browser, the practical limit depends on your device's memory. Most users generate hundreds of documents without issues.

What happens if a placeholder does not match any CSV column?

If a placeholder in the template has no matching column in the CSV, it is left as-is in the output document (e.g., {{MissingField}} stays as {{MissingField}}). This makes it easy to spot unmatched fields.

Does it work on a Mac?

Yes. The tool runs entirely in your browser, so it works on Mac, Windows, Linux, Chromebook, or any device with a modern browser. Unlike Word's built-in mail merge, which has limited functionality on Mac, this tool works identically on all platforms.

Is it safe to use with confidential data?

Your files never leave your device. Nothing is uploaded, stored, or visible to anyone. Processing happens entirely in your browser, and all data is gone when you close the tab.