Free tool
Format lines with a template
Format lines with a template: write the pattern once, like "{1} costs ${2}", and every line is filled in. Use {line} for the whole line, {n} for its number, {1} {2} for columns, or column names from a heading row.
The example is loaded. Paste your own list to replace it.
→ 2 lines
Template
Columns are separated by
The first row has column names (use them as {name})
Your text
Result
What it does
Build each line from a pattern like "Name: {1}, price: {2}". {line} is the whole line, {n} its number.
Settings you can change
- Template
- Columns are separated by: Comma ,, Tab, Semicolon ;, Pipe |, Other (type it)
- Other separator
- The first row has column names (use them as {name})
When to use it
Turn a CSV of names and emails into ready-to-paste lines like "Jane Doe <jane@example.com>".
Example: format lines with a template
Settings used: Template: {name} <{email}>; The first row has column names (use them as {name}): on.
Input
Result
Tips
- Type {{ or }} for a real brace.
Often used with
Put the same text at the start or end of every line.
Join line 1 with line 1 of another list, line 2 with line 2, and so on.
Turn rows into JSON objects, using the first row as the names.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper