Skip to content
PrivBay

Mail merge: make Word documents from a spreadsheet

Use this Word mail merge tool for mail merge Excel to Word online: fill a docx template with the rows of an Excel sheet or CSV file to make form letters, mail merge labels, Word documents from Excel or certificates from a spreadsheet. Choose mail merge to separate files for each row, named after a column, or one document to print, with nothing uploaded.

Drop your Word template here

A .docx or .dotx file. Type {{Column name}} where each value goes, or use Word’s merge fields.

Your list

Copy the cells with the column names in the first row, then paste them here.

What to create

The files come in one ZIP.

Preview

Add a template and your list to see each copy here before you create them.

Ready. Your files stay on this device.

How to do a mail merge

  1. Choose your Word template. Type {{Column name}} where each value should go, or keep the merge fields you inserted in Word.
  2. Select Open Excel or CSV file, or paste the cells of your sheet. The first row must hold the column names.
  3. Under Match fields to columns, check that each field has the right column, and look through a few copies in the preview.
  4. Choose A Word file for each row or One Word document, select Create, then select Download.

Mail merge from Excel to Word in your browser

A mail merge fills one Word document with the details of many people or things. Write a letter, certificate, invitation or contract once, with a marker where each name, address or amount goes, and get a finished copy for every row of your spreadsheet, up to 1,000 rows at a time.

Mark the places in your template

Type the column name between double braces, such as {{First name}} or {{Amount due}}, exactly where the value should appear. Capitals, spaces and underscores don’t matter, so {{first_name}} also finds the column First Name. The value takes the font and style of the first brace, so a bold placeholder gives a bold name.

If your document already has merge fields from Word’s Mailings tab, shown as «First_Name», use it as it is. The upper and lower case switches, and the text Word adds before or after a field, are applied. Word’s If, Ask, Fill-in, Address Block and Greeting Line fields aren’t filled, and the tool lists any it finds. Fields in headers, footers, tables and text boxes are filled too.

Check the preview before you create

The preview shows the text of each copy with the merged values highlighted, so you can spot an empty field or the wrong column before you make a hundred letters. If a field has no column with its name, pick one under Match fields to columns.

Separate files or one document to print

A Word file for each row suits documents that go to different people, such as offer letters, certificates or contracts. Name the files after a column and they arrive in one ZIP. One Word document puts every copy on a new page, with page numbers starting at 1 for each, so you can print the whole batch at once. Save it as PDF from Word if you need one file to share, then use compress PDF if it is too large to send.

For a QR code on every row of the same list, use the bulk QR code generator. To bill one client, the invoice generator is quicker, and for a single job application, try the resume builder.

If you use mail merge online for letters and want a matching sign-off in your email client, use the email signature generator.

To save individual documents from the downloaded archive, use Zip and Unzip Files.

Frequently asked questions

Do I need Microsoft Word to do a mail merge?

No. You need a template saved as a Word document (.docx), which you can make in Word, Google Docs, LibreOffice or Pages, and a list. Type {{Column name}} where each value goes, using the column names from the first row of your sheet. Merge fields inserted with Word’s Mailings tab work too.

Can I save each letter as a separate file?

Yes. Choose A Word file for each row and pick a column to name the files after, such as a name or an invoice number. Rows without a name are numbered, and when two rows share a name, a number is added so no file replaces another. All the files come in one ZIP.

Why do my dates and amounts look right here when they don’t in Word?

Word’s own mail merge often ignores Excel’s number formats, so 15% can come out as 0.15 and $1,250.00 as 1250. This tool uses each cell as Excel shows it, with its number format, so dates read as in your sheet and ZIP codes keep their leading zeros. To change how a value looks, change the cell’s format in Excel. Values from a CSV file are used as they are written.

Does it work for labels and envelopes?

Yes. For envelopes, make a template with one envelope and get a copy for each row. For a sheet of labels, set the labels up in Word with Mailings, Start Mail Merge, Labels, so every label after the first starts with a Next Record field. Each copy then fills one sheet, with a different row on each label.

Can it send the letters by email?

No. It makes documents, and nothing is sent anywhere. To email them, attach the files to your messages, or use the mail merge in your email program.

Can I get PDF files?

The tool makes Word files. To get a PDF, open the result in Word, Google Docs or LibreOffice and save or download it as PDF. One Word document makes a single PDF with every copy, each on its own page.

Is my list uploaded?

No. Your template and your list are read in your browser and the documents are made on your device. Lists often hold names and addresses, so nothing is sent to a server.

Last updated November 12, 2026