Add a prefix and suffix to each line

Whatever you type in Prefix is added to the start of each line, and whatever you type in Suffix is added to the end. Either can be empty. Spaces count, so - (dash and space) gives a neat bullet.

With Skip empty lines on (the default), blank lines stay blank instead of getting a lonely prefix and suffix.

Everything runs in your browser, and the result can be copied or downloaded as a text file.

SQL IN list. Prefix ', suffix ', turns a column of IDs into values you can paste into WHERE id IN ( … ). Remove the comma after the last value by hand.

JSON or JavaScript array. Prefix ", suffix ", gives quoted, comma-separated strings for an array.

Markdown or plain-text bullets. Prefix - or * . For numbered items, use add line numbers instead.

HTML list items or table cells. Prefix <li> and suffix </li>, or <td> and </td>.

Email or chat quotes. Prefix > marks every line as quoted text.

URLs from slugs or IDs. Prefix https://example.com/products/ turns a list of product slugs into full links.

Hashtags. Prefix # turns a word list into hashtags (make sure the words have no spaces; the slug generator can help).

Adding a comma suffix still leaves one item per line. If you need everything on a single line, like apple, pear, plum, use the comma separator tool instead: it joins a list with any separator, can wrap items in quotes, and can add and before the last item.

Combining the two works well: add a prefix here (for example a currency symbol or a label), then join the lines with the comma separator.

Prefixes and suffixes are added to the line exactly as it is. If your lines have trailing spaces, the suffix appears after those spaces, which can break SQL or code. Run the list through remove extra spaces first to trim each line. To remove duplicate items before you wrap them, use remove duplicate lines.

To change something in the middle of each line rather than at its ends, use find and replace; with a regular expression such as ^ and $ you can also insert text at the very start or end of the whole text.

In Excel or Google Sheets you could build the same thing with a formula such as ="'"&A1&"'," and fill it down. Pasting the column here is usually faster for a one-off job, and you don't need to clean up helper columns afterwards. Copy the column, paste it, add the prefix and suffix, copy the result back.