How to use
- Write your message in the Message template box. Mark the parts that change in braces, like
{name}. - Paste a table into the Data box. In Excel or Google Sheets, select the range including the header row and copy it.
- One finished message per row appears on the right as a card, each with its own Copy button.
- To use everything at once, copy All results or click Download .txt. Download CSV adds a
resultcolumn after your original columns.
Copying from Excel or Google Sheets
- Put column names (name, item, date and so on) in the first row, and one record per row below it.
- Drag to select the header and data cells, then copy (Ctrl+C).
- Paste into the Data box. Copied cells are separated by tabs, which the tool recognizes automatically.
You can also paste comma-separated CSV text. If the first line contains a tab, the data is read as tab-separated; otherwise as comma-separated. Values that contain commas or line breaks must be wrapped in double quotes, such as "Seoul, Jongno", and tables copied from a spreadsheet already take care of this. Up to 5,000 data rows (not counting the header) are used. Only the first 50 are shown as cards, while the full result and the saved files include them all.
Placeholder rules
| In the template | Meaning | With name=Alex |
|---|---|---|
{name} |
Replaced by the value in the name column | Alex |
{ name } |
Spaces just inside the braces are ignored | Alex |
{Name} |
Compared with headers ignoring upper and lower case | Works even if the header is name |
{{name}} |
Literal braces | {name} |
{title} |
With no matching column it stays as written and a warning is shown | {title} |
Placeholder names may contain letters (any language), digits, underscores and spaces. Something like {a-b} contains other characters, so it is treated as ordinary text. If a replaced value itself contains {...}, it is not replaced a second time.
Empty cells are handled by the Empty cells option. Replace with nothing removes the placeholder, while Keep the placeholder leaves {item} in the text so a missing value is easy to spot. Columns that the template does not use are listed on screen.
Ideas
- Group messages: change only the name and schedule. Each result shows its character count, but bytes are not calculated.
- Shipping notices: make columns for customer, product and tracking number, and write all the notices at once.
- Product descriptions: use columns such as product name, material and size to write the same format for every product.
- Email greetings: vary the recipient’s name and company in the first paragraph.
Privacy and your list
A customer list is sensitive. This tool does not send the template or the list to a server; everything is processed inside the browser tab that is open now, and it disappears when you close the tab. Once you copy or save the results, though, where that file ends up is up to you.
Related tools
To edit part of the finished messages in bulk, use Find and Replace. To move a table to or from JSON, try JSON CSV Converter. To turn one column into a comma list, use List Converter, and to check lengths, Character Count. Your text is processed in this browser and never sent to a server.