Mail merge from Excel

Your Excel sheet already holds the names, addresses and details. A mail merge turns every row into a personalized document or email. Here is how to do it in your browser, no Word required.

  • Trusted since 2020
  • GDPR & CCPA compliant
  • 30-day money-back guarantee
MailMergic app generating PDFs from a spreadsheet

How to mail merge from Excel in 5 steps

All you need is an Excel file with a header row (Name, Address, Amount, ...) and a template. MailMergic supports PDF, Word, Excel and image templates.

  1. Upload your template

    A PDF form, a Word letter, an Excel sheet or an image. Static PDFs work too: you place text fields anywhere on the page.

  2. Upload your Excel file

    XLSX, XLS and CSV are supported, as well as Google Sheets. The first row becomes your list of merge fields.

  3. Place your merge fields

    Drag columns like {Name} or {Invoice number} onto the template. Dates, numbers and currencies keep their formatting.

  4. Preview and check

    Step through the rows before generating. AI error detection flags missing values and data mismatches.

  5. Generate and deliver

    One document per row, as separate files or one combined file. Download everything, or email each document to its recipient with delivery tracking.

Customers love MailMergic

From small teams to large organizations, users around the world rely on MailMergic to automate their document workflows, save hours of manual work, and deliver perfectly personalized results, every single time.

Average score from 134 post-purchase surveys in 2025: 4.6/5

"Over the past three years, MailMergic has consistently surpassed my expectations."
Abijah S.
Sales Representative
"I cannot sing your praises enough. Amazing product and amazing support!"
Nicola H.
Lawyer
"I am super impressed with this, I just wished I found you years ago."
Bobby F.
Online Teacher
"I have to say the support you've provided is outstanding 😊"
Muhammad Y.
Finance Analyst
"This program is really amazing!"
Carrie N.
HR Manager
"Even though I only use it once a year, the improvements make it much easier to use and great at preventing mistakes."
Yefim Z.
Regional Director
"I have to say I am very impressed with your app, how well thought out it is, and how robust it is."
Philip L.
MailMergic User

The classic way: Word + Excel

Microsoft Word has built-in mail merge: open Word, go to Mailings, choose Start Mail Merge, select your Excel file under Select Recipients, insert merge fields, then Finish and Merge. For simple printed letters this works fine.

The Word route shows its limits as soon as the output should be individual PDF files or emails with attachments:

Where Word mail merge struggles

  • One long document instead of one file per person; splitting into separate PDFs needs add-ins or VBA scripts
  • No personalized email attachments and no delivery or open tracking
  • Dates, currencies and decimals often arrive unformatted from Excel
  • PDF form templates are not supported at all
  • Requires a desktop Office license; no browser or Mac-friendly workflow

Word vs. MailMergic for Excel mail merges

Word + ExcelMailMergic
One PDF file per rowAdd-ins or VBA neededBuilt in
Email each row its documentNot without pluginsBuilt in, with tracking
PDF form templatesNot supportedSupported
Date and number formattingOften breaksKept per column
Works in the browserNoYes, nothing to install
Images, QR and barcodes per rowVery limitedSupported

Frequently asked questions

Can I mail merge from Excel without Word?
Yes. MailMergic runs entirely in your browser. Upload the Excel file and a template (PDF, Word, Excel or image), map the columns, and generate one document per row. Word is not involved at any point.
Does formatting like dates and currencies carry over?
Yes. MailMergic reads the display format of each column, so 01/31/2026 stays a date and 1,250.00 stays a currency amount. You can also override the format per column.
Can every row become its own PDF file?
Yes, that is the default. You can name each file from your data (for example Invoice-{Number}.pdf), protect each with its own password, or combine everything into one PDF instead.
Can I email each person their own document?
Yes. Add an email column, write a subject and message with merge fields, and MailMergic sends every document to its recipient and tracks delivery, bounces and opens.
Does Google Sheets work as a data source too?
Yes. You can connect a Google Sheet directly instead of uploading an Excel file, or start straight from our Google Sheets add-on.

Your Excel file is ready. Your documents are 5 minutes away.

Start a mail merge from Excel