Add Prefix and Suffix to Lines

What this tool does

Add Prefix and Suffix to Lines wraps each line of a list in the text you specify. Presets cover the common jobs, such as quoting values for code, building SQL rows or HTML list items, and a {n} placeholder inserts a running number.

Developers and analysts constantly reshape lists: a column of IDs copied from a spreadsheet needs quotes and commas before it can go into an IN clause, a list of names must become HTML list items, or every line of a config needs commenting out. Doing it with a text editor’s multi-cursor works, but only if you have such an editor open and the list is short.

Here you type a prefix and suffix, or pick a preset, and every line is rewritten instantly. The {n} placeholder inserts a counter starting at any value, and {line} repeats the line’s own text inside the prefix or suffix. For the quote and SQL presets, quotes inside values are escaped, so O’Brien becomes O''Brien in SQL, preventing broken statements. A final option removes the trailing comma from the last line so the list is ready to paste. All processing happens in the browser.

How to use Add Prefix and Suffix to Lines

1. Paste your list into the Lines box, one item per line.
2. Choose a Preset, or keep “Custom prefix and suffix” and type your own Prefix and Suffix.
3. Use {n} in the prefix or suffix to number lines, and set “First value of {n}”.
4. Keep “Trim spaces around each line first” on to remove stray spaces copied from spreadsheets.
5. Leave “Escape quotes inside values” and “Remove trailing comma from the last line” on for code and SQL.
6. Copy the result or download it as a text file.

Tips for better results

• For a SQL IN list, use the single-quote preset and wrap the output in parentheses: WHERE id IN (…).
• A prefix of “https://example.com/products/” and an empty suffix turns a list of slugs into full URLs.
• Use \t in a custom prefix or suffix to insert a tab and build two-column, spreadsheet-ready text.
• The Markdown task preset (“- [ ] ”) converts a plain list into a checklist for GitHub issues or notes apps.

Common use cases

• Turning a column of customer IDs into a quoted, comma-separated list for a database query.
• Generating <li> elements for a navigation menu from a list of page names.
• Commenting out a block of shell or Python configuration lines with “# ”.
• Creating numbered labels like “Item {n}: ” in front of each product line.

Common mistakes to avoid

• Switching off escaping and then pasting a value with an apostrophe into SQL, which ends the string early.
• Forgetting that empty lines are skipped by default, so the {n} counter does not count them either.
• Copying the output into code without checking the last line still needs, or should not have, a trailing comma.