Merging CSV or Excel spreadsheets into personalized PDFs
Turning a customer roster or donor spreadsheet into individualized letters should work as a private browser mail merge without uploading spreadsheets to a cloud add-on. Every CSV file is parsed locally following the delimiter and quoting rules of IETF RFC 4180 Common Format for CSV Files, keeping comma-containing street addresses and currency figures intact.
Validating column headers, 500-row limits, and 20 MB file guards
Row 1 of your spreadsheet must contain unique, non-empty headings, up to 100 columns wide. The batch letter generator accepts 1 to 500 data rows per run, enforces a 20 MB file limit, and guards Excel workbooks against zip-bomb expansion beyond 50 MB or 10,000 archive entries.
If your CSV includes international accents or currency symbols, save the file in UTF-8 encoding before loading it. The parser automatically strips a leading UTF-8 BOM so your first column heading never picks up hidden characters.
Troubleshooting missing placeholders in mail merge letters starts with checking row 1 spelling and trailing spaces. If {Invoice_No} does not match your header capitalization or contains an extra space, click the column pill directly to insert the exact token.
Inserting merge tokens and stepping through recipient previews
Click any column button under Insert merge field at cursor to drop {column} tokens into Letter template (up to 20,000 characters). Select Typeface (Helvetica, Times, or Courier) and Font size (pt) between 6 and 72 pt.
Use Previous row and Next row above the preview pane to verify how short and long recipient names wrap before exporting. If you are preparing award handouts instead of letters, you can generate bulk award certificates from a name list with dedicated border templates.
Plain-paper letters versus stamping onto a PDF background
Choosing between plain-paper generation and background PDF stamping depends on whether your team already maintains a designed letterhead file. Excel workbooks follow the Library of Congress Office Open XML (.xlsx) Format Description, letting you load .xlsx sheets directly without exporting to CSV first.
| Mode or output | Input requirements | Page sizing | Best use case |
|---|---|---|---|
| Plain-paper mode | Spreadsheet + template | A4 or US Letter | Internal notices and plain memos |
| PDF background mode | Spreadsheet + PDF (≤ 20 MB) | Preserves PDF page size | Branded letterheads and pre-designed forms |
| One combined PDF | 1–500 rows (≤ 2,000 pages) | Single multi-page PDF | Batch office printing in one job |
| Separate PDFs in a ZIP | 1–500 rows + naming column | Individual PDF per row | Email attachments and client portals |
For matching outbound envelopes or parcel boxes from the same contact table, pair your letter batch with parcel shipping and return label sheets printed at 100% scale.
How do Left, Top, and Wrap width coordinates work on PDF backgrounds?
Stamping text onto an existing PDF uses user-space points measured from the top-left corner at 72 points per inch (25.4 mm), matching the Library of Congress PDF 2.0 (ISO 32000-2) Format Description. Setting Left (pt) to 72 and Top (pt) to 144 places the first line exactly 1 inch from the left edge and 2 inches down.
Mail merge formatting, coordinates, and font wrapping remain consistent across every generated recipient page. Adjust Font size (pt) alongside your coordinates whenever you switch between Helvetica, Times, and Courier.
Measuring points at 72 points per inch on A4 and US Letter
An A4 page measures roughly 595 by 842 points, while a US Letter page measures 612 by 792 points. Start with the default 50 pt left and 100 pt top offsets, then adjust in 10 to 20 pt increments while watching the live recipient preview.
Targeting specific background pages and preventing line clipping
When Wrap width (pt) is 0, lines break only at manual newlines in your template. Enter a positive point width (such as 450 pt on A4) so long merged paragraphs wrap automatically inside your letterhead margins without clipping.
If your background PDF has multiple pages, set Target page to stamp only the chosen page while keeping all remaining pages intact for every recipient. To print matching address stickers for windowless envelopes, align recipient addresses onto pre-cut Avery sticker sheets.
ZIP file naming, Web Worker memory, and privacy scope
Large batches of client statements or tax notices require predictable filenames and strict client-side isolation. Every merge job runs off the main UI thread via the MDN Web Docs Web Workers API so the browser tab stays responsive during multi-page assembly.
Naming individual PDFs from a spreadsheet column
When Output is set to Separate PDFs in a ZIP, choose any column under File naming column so files export as sanitized recipient names rather than generic letter-0001.pdf numbers. Duplicate values in that column receive automatic numeric suffixes so every record stays intact.
Tip: Always test your
{field}layout with the longest recipient name and address in your spreadsheet using Preview recipient before running a 500-row ZIP export.
Why recipient lists and letterheads stay inside your Web Worker
Spreadsheets, background PDFs, and merged output bytes stay in local browser memory with 0 bytes sent to any server, and password-protected background PDFs are unlocked client-side before stamping. For UK charity donor mailings, you can also reference the Gift Aid declaration form to keep donor records organized locally.