Add Prefix / Suffix to Lines

Prepend a prefix and/or append a suffix to every line. Useful for wrapping CSV values in quotes, adding list markers, creating SQL IN lists, or building HTML lists from plain text.

Runs locallyInstantPrivate
Input
Output
Lines with prefix/suffix appear here.

Common use cases

  • SQL IN clause — prefix ', suffix ', → wrap values in single quotes for WHERE id IN ('a','b','c')
  • CSV quoting — prefix ", suffix " → wrap each value in double quotes
  • Markdown / HTML lists — prefix - or • → instant bullet list from plain lines
  • Code arrays — prefix ', suffix ', → turn a list into a JavaScript/Python array body
  • Line numbering prep — combine with Number Lines for numbered and prefixed output

Frequently asked questions

How do I create a SQL IN clause from a list?

Prefix: single quote, Suffix: single quote + comma → 'value1', 'value2'. Paste into SQL WHERE id IN (…). Trim the trailing comma from the last line.

How do I wrap CSV values in double quotes?

Prefix: ", Suffix: ". Every line becomes "value". Useful for quoting a column of CSV values.

What does skip blank lines do?

When on, blank lines are left as-is without adding prefix/suffix — preserves visual separators in the input.

Related tools

Random String GeneratorGenerate random strings for passwords, tokens, and test data.Text RepeaterRepeat any text N times with a custom separator.Word CounterWords, characters, sentences, paragraphs, and reading time together.Character CounterCharacter counts with and without spaces, plus letter and digit tallies.