Business
Letter Mail Merge to PDF
Write one letter with {{Name}}-style placeholders, drop a spreadsheet of recipients, and download a PDF for each row — zipped, and as one combined file for printing. Runs in your browser; nothing is uploaded.
Privacy
Your file never leaves your device. It is read and converted by your own browser, so nothing is uploaded, queued or logged — which is what makes this safe for a client’s books.
Tips
- A placeholder is the column heading in double braces: {{Name}}, {{Amount due}}. Case and spacing do not matter, so {{amount_due}} finds "Amount Due". A placeholder with no matching column is left in the letter as typed, and listed, so it cannot slip through unnoticed.
- The first row of the spreadsheet is the headings. Every row after it is one letter; blank rows are skipped.
- Put the recipient’s address in the template as placeholders — {{Name}}, {{Address}} — on the lines where you want it. The letterhead, date and signature are set once and go on every letter.
- Amounts and dates print as the cell holds them. Format them in the spreadsheet as you want them read (12,500.00 · 15 October 2026); a date cell stored as a number is turned into a date only when the heading contains "date".
- The standard PDF fonts cover Western European characters. Names in Devanagari, Tamil or Arabic script, and the ₹ sign, would print as "?" — the tool lists any row where that would happen. Write Rs for rupees.
- The combined PDF starts each letter on a new page, so it prints and collates in one job; the ZIP has one file per recipient for emailing.
Frequently asked questions
Does it read Word templates or produce Word files?
No. The template is plain text typed here, and the output is PDF only. That is what makes it work without an upload: the letters are drawn directly by the site’s PDF writer, in the standard fonts a PDF reader has built in.
Can a letter run over more than one page?
Yes. A long letter continues on a following page, and the signature block always stays with the text before it. Each recipient still starts on a fresh page in the combined file.
What happens to a row with an empty cell?
The placeholder becomes empty text, and the row is listed under issues with the column name — a demand letter for a blank amount is worth catching. The letter is still produced so the numbering stays in step with the spreadsheet.