MailMergic
Try for free Go to app
Pricing PDF mail merge Upload PDF · Get PDF Word mail merge Upload DOCX · Get DOCX or PDF Excel mail merge New Upload XLSX · Get XLSX or PDF Offline App Company Contact FAQ Blog Log in

Early Access

Excel Mail Merge to Excel.
Two Spreadsheets In.
Hundreds Out.

Fill an Excel template with data from another Excel sheet and generate one personalized Excel file for every row.
No VBA. No Word. No copy-paste. Now in early access.

  • GDPR & CCPA compliant
  • 30-day money-back guarantee
  • Trusted by Novartis, BMW and Verizon
Try early access. Generate 100 Excel files →
Upload a sample data file
MailMergic generating personalized Excel files from a spreadsheet of customer data

Trusted by spreadsheet teams worldwide

TelefónicaVerizonScaniaChevronBMW GroupNovartis

Three steps

500 personalized Excel files while you brew coffee

Upload

XLS
XLS

Add your Excel template with placeholder fields like @customer_name or @region, plus your data file from Excel, CSV, or Google Sheets.

Map

Match your data columns to the template's placeholder fields. Drag and drop. No formulas required.

Generate

Sent

One click. One Excel file per data row, named automatically. Export as Excel or PDF. Download as a zip or send each file by email.

See it for yourself.

Try early access

How MailMergic generates Excel from Excel

Built for the job no other tool does

Bulk-generate Excel files from any spreadsheet

Drop in your data file. Upload your Excel template. MailMergic fills every cell and saves one Excel file per row. 200 customers in, 200 personalized pricing sheets out.

  • Works with Excel, CSV, and Google Sheets
  • One file per row, auto-named from any column
  • Export as Excel or PDF from the same template
  • Multi-sheet templates supported
Try early access

Formulas, formatting, and conditional formatting preserved

This isn't a CSV-export hack. SUM, VLOOKUP, IF, conditional formatting, and named ranges all survive the merge. The output behaves exactly like the template, just populated with that row's data.

  • Formulas and named ranges preserved
  • Conditional formatting carried over
  • Cell styles, fonts, and number formats retained
Try early access

Built for spreadsheet-heavy teams

Wherever Excel files pile up, MailMergic clears the queue

A salesperson reviewing a personalized customer pricing sheet at a tidy desk

Sales Operations

Per-customer pricing sheets generated from a master price list and a deals pipeline. Quote turnaround drops from a day to a minute. Every prospect gets the right line items, every time.

A finance professional reviewing a clean spreadsheet-style monthly statement at a desk

Finance & Accounting

Per-account customer statements at month-end. Per-region monthly P&Ls. Each output is a clean Excel file with formulas intact, ready for the recipient to drill into.

An HR professional handing a personalized review packet to an employee in a bright office

HR & People Ops

Per-employee performance summaries, comp letters, and review packets generated from a single HRIS export. No more 200 saved-as files with copy-paste mistakes.

A property manager at a desk preparing a monthly statement, with building shapes visible through a window

Property & Asset Management

Per-property rent roll and per-owner financial summaries, every month. One source-of-truth file in. One personalized statement per owner out.

Join early access. No signup required to try a sample.

Try early access

What changes when you switch

Stop generating Excel files one at a time

1,000+

Personalized Excel files per merge

One run. Not a week of save-as-and-rename.

95%

Less manual work

Reported by early-access users replacing VBA macros and manual workflows for monthly report generation.

0

Technical knowledge required

If your data has columns and your template has placeholders, you're done.

Built for sensitive spreadsheet data

Your data stays your data

Spreadsheets carry the most sensitive data in most companies: pricing, compensation, financial detail. MailMergic is GDPR- and CCPA-compliant by default. Files are encrypted in transit and at rest, hosted in the EU. Macros are stripped on upload for security.

  • GDPR Compliant
  • CCPA Compliant
  • EU-hosted
  • Encrypted in transit & at rest

Join early access. No signup required to try a sample.

Try early access

Common use cases

What people generate with Excel-to-Excel mail merge

These are the patterns we hear most often from early-access users. Bring your own template. Layout, formulas, and styling all carry through.

  • Per-customer pricing sheet generated from an Excel template

    Per-customer pricing sheet

  • Per-region monthly sales report generated from an Excel template

    Per-region monthly sales report

  • Per-employee performance summary generated from an Excel template

    Per-employee performance summary

  • Per-property rent roll generated from an Excel template

    Per-property rent roll

  • Per-account customer statement generated from an Excel template

    Per-account customer statement

Frequently asked questions

What does "Excel mail merge to Excel" actually mean?
It means taking an Excel template with placeholder fields like Customer Name or Region and combining it with a data source (Excel, CSV, or Google Sheets) to produce one personalized Excel file per row of data. Some people also call this "generate an Excel file for each row."
How is this different from a mail merge in Excel using Word, or the "&" concatenation hack?
A mail merge in Excel usually means using Excel as the data source for a Word mail merge, so the output is Word, not Excel. The "&" concatenation hack stitches strings together inside one cell of one spreadsheet, so you don't end up with separate files. MailMergic generates a real personalized Excel file per row.
Do I need to know VBA or write macros?
No. MailMergic runs in your browser. You upload a template, upload a data file, and click generate. No code, no scripting, no IT involvement.
Are formulas and conditional formatting preserved in the output?
Yes for the common cases. SUM, VLOOKUP, IF, conditional formatting, named ranges, cell styles, fonts, and number formats all carry through to the output file. Edge cases that need verification on your specific template: array formulas spanning rows, external file references, and very large pivot tables that lose their data source on merge. We recommend running one test merge with a representative row before doing a 500-row run.
What file formats can I use as the data source?
Excel, CSV, and Google Sheets. Connect a Google Sheet directly or export it as CSV. All three paths produce the same one-file-per-row output.
Can the mail merged output be exported as PDF instead of Excel?
Yes. After the mail merge, choose your output format: Excel (default) or PDF. The PDF preserves your template's layout, fonts, conditional formatting, and number formats. Use Excel output when the recipient needs to keep working with formulas; use PDF when the recipient just needs to view or print the result (invoices, statements, monthly reports).
Can MailMergic email each generated file to a recipient automatically?
Yes. After generating the personalized files (Excel or PDF), MailMergic sends each one as an attachment to the recipient's email address (pulled from a column in your data file) in a single step. Track delivery, opens, and bounces from one dashboard. No third-party email tool required.
What's the deal with macros?
For security, MailMergic strips macros on upload. The merged output is a clean Excel file. If your workflow depends on macros, the Excel-to-Excel feature isn't the right fit yet. Let us know what you need.
Excel-to-Excel mail merge is in early access. What does that mean for me?
The feature is functional and being used by early-access customers. Expect rougher edges than MailMergic's PDF and Word mail merge, which have been live since 2021. We're actively iterating based on early-access feedback. Let us know what you'd like to see.
How does this compare to your PDF and Word mail merge?
Same workflow, different starting point. Excel-to-Excel takes an Excel template and outputs Excel or PDF. Best when you design the report in Excel (formulas, conditional formatting, multiple sheets) and either want recipients to keep working in the spreadsheet or just need a final PDF. PDF mail merge takes a PDF template (a form, certificate, or pre-designed layout) and outputs PDF. Word mail merge takes a .docx template and outputs Word. Pick by what your template is, not by what the recipient receives.

Stop saving 200 Excel files by hand. Try early access in 60 seconds.

Try early access