Add Prefix and Suffix to Lines

Developers turn a column of IDs into an array or SQL list without writing a script. Marketers add tracking parameters or hashtags to many lines at once. Writers and editors add bullets or quotation marks to a list of quotes. Data teams wrap values in quotes before importing them into a spreadsheet or database.

Remember the last line: if you are building a comma-separated list, you may need to delete the final comma by hand.

For tidy results, start with one item per line and no stray spaces. Run messy text through Remove Extra Spaces, sort and deduplicate it with the List Sorter, and use Find and Replace to change separators, for example replacing commas with line breaks, before adding your prefix and suffix.

You have 200 order IDs in a spreadsheet column and need to query them:

1. Copy the column and paste it here. Each ID is on its own line.
2. Set Prefix to ' and Suffix to ',.
3. Click Apply to every line. Each line now looks like 'A1042',.
4. Copy the result into your query between WHERE order_id IN ( and ), and delete the comma after the last ID.

The same steps with " and ", produce items for a JSON or JavaScript array.

Paste a list of features, one per line, set Prefix to <li> and Suffix to </li>, then wrap the result in <ul> and </ul>. For a Markdown list, use - as the prefix and leave the suffix empty; for a numbered Markdown list, 1. works on every line because Markdown renumbers automatically.

• Tick Skip empty lines so blank lines between groups do not end up as empty quotes or tags.
• Trailing spaces at the end of a line will sit inside your suffix. Clean them first if that matters, for example for CSV values.
• If your text uses Windows line endings, the tool still treats each line separately.
• Need the same text in the middle of each line instead? Use Find and Replace on a separator character.