Prefix and Suffix Adder

How to add text to the beginning of every line

Paste the list on the left, then type what goes before and after each line. The result appears on the right as you type.

Five presets fill both boxes for the common cases, so the usual job is one click rather than working out what to put in two fields.

The four things people build with this

A SQL list. Wrapping each value in quotes with a trailing comma turns a pasted column of IDs into the contents of an IN (...) clause. It is the reason this tool gets used most, and doing it by hand for two hundred rows is how the afternoon disappears.

Bullets. A plain hyphen in front of every line, for pasting somewhere that does not make lists for you.

HTML list items. <li> and </li> around each line, which is faster than any editor macro for a list you were given as plain text.

Numbering. Right-aligned, so the text stays in a straight column when the list passes ten items and the numbers gain a digit. A left-aligned number shifts every line after the ninth by one character, which looks like a mistake in a document.

Blank lines are left alone

They pass through untouched rather than getting wrapped.

That matters more than it sounds for the SQL case. A quoted empty string sitting in the middle of an IN clause is valid syntax, so nothing errors. The query simply returns a row nobody asked for, or fails to return one that was expected, and the reason is invisible in a list of two hundred values.

What usually comes first

This is the last step. Before it, the list normally needs the treatment the rest of the category does.

Strip the markers off a list pasted from a document with the list cleaner, or the old bullets end up inside the new quotes. Then take out the repeats with the duplicate line remover, since a duplicate in a query is at best wasted work.

And if what you want at the end is a single comma-separated line rather than one item per line, the column to comma tool does that in one step without any wrapping at all.

Everything runs in your browser. Nothing is uploaded.