Generate personalized text blocks from a CSV and a template
Fill a text template with {{field_name}} placeholders from each CSV row to generate personalized output.
🛡️ Your rows never leave your browser.
Why Onfyt: Supports conditional blocks: {{#if field}}...{{/if}} syntax to include sections only when a field is non-empty—e.g., only include discount text when a discount column is populated.
Interactive Sample Data
| first_name | invoice_id | amount | due_date |
|---|---|---|---|
| Grace | INV-1001 | KSh 4,500 | 2024-02-15 |
| Peter | INV-1002 | KSh 8,200 | 2024-02-20 |
How this tool works
Mail merge fills a text template with values from each CSV row, producing one personalized output block per row. Unlike a full mail-merge application, DataFix's mail merge output is plain text—suitable for pasting into individual emails, generating batch SMS messages, or producing printable personalized letters.
The template uses {{column_name}} placeholder syntax. DataFix replaces each placeholder with the corresponding column value for every row and outputs the results as a text file with blocks separated by record delimiters.
Generating customized mail-merge documents from CSV row data populates templates with recipient variables for transactional messaging and automated correspondence.
Generating customized mail-merge outputs combines CSV tabular records with message templates, dynamically injecting recipient variables for personalized customer correspondence, billing notices, and certificate generation.
Mail merge templating injects tabular CSV variables into custom text templates with mustache-style syntax, automating personalized customer notices, transactional correspondence, and bulk outreach preparation. Automated template rendering produces clean transactional correspondence drafts, eliminating manual copy-pasting across large recipient lists. Automated template rendering accelerates transactional communications, generating recipient-specific message drafts with strict field validation.
Merging spreadsheet rows into customized document templates automates personalized client communications and bulk notification drafts with verified variable substitution. Missing merge variable safeguards alert users if a record lacks required template attributes before generating the final message batch. Whitespace trimming ensures that injected variables nest neatly into sentences without awkward double spaces. Automated merge validation ensures all recipient attributes are populated before generating notification batches.
Things that usually go wrong
- Placeholder names must match column names exactly (case-sensitive).
- Columns with spaces in the name must be referenced as {{first name}} including the space.
Edge cases we tested
🧪 Placeholder with no matching column name
Left as-is ({{unknown_field}}); warning listed for unresolved placeholders.
🧪 Missing recipient placeholder tokens
Outputs empty fallback string without leaving raw token brackets.
Frequently Asked Questions
Can I use conditional logic in the template?
Basic if/else is supported: {{if city == 'Nairobi'}}Nairobi branch{{else}}other branch{{end}}.
What file format is the output?
Plain text (.txt) by default. HTML template output is also supported.
Related tools
Transform
Column to Comma-Separated List
Extract a CSV column and convert it to a comma-separated list for SQL IN clauses or code arrays.
Open Tool →
Transform
Comma-Separated List to Column
Convert a comma-separated, line-separated, or SQL IN list into a single-column CSV.
Open Tool →
Transform
Lines to CSV
Convert plain-text newline-delimited records into structured CSV tables.
Open Tool →