Delimiter converter

Turn lines or separated values into SQL lists, arrays and custom delimited text.

Processed on your device

Input

Open a local UTF-8 text file5 MiB maximum. The file opens in the text box above.Or drop a file here.

Options

Options
Choose how your existing values are separated. Use lines for a pasted spreadsheet column.
SQL adds quotes and parentheses; JSON creates an array of text values. Custom uses the options below.
Text placed between output values, such as a comma followed by a space.
Surround each value with single or double quotes. Matching quotes inside values are doubled.
Text added once before the complete list, such as an opening bracket.
Text added once after the complete list, such as a closing bracket.

How to use this tool

  1. Paste a column or choose its existing separator.
  2. Choose output separators and quotes, or use SQL or JSON array mode.
  3. Generate and copy the result. SQL mode doubles apostrophes; values stay text so leading zeros survive.

Things to know

  • SQL output is for preparing literals, not a substitute for parameterised queries.
  • Delimited inputs follow CSV quote escaping. A custom input separator must be one character.
  • Each text input accepts up to 5 MiB. Output is limited to 25 MiB and combined text settings to 1 MiB.
  • Line-based modes accept up to 100,000 lines, including a trailing empty line.
  • Output is limited to 25 MiB of UTF-8 text. Shorten the input, separators or replacement settings if it exceeds the limit.

Task guides

Turn an Excel column into a SQL IN list

Add quotes and commas to a column of IDs while preserving leading zeros and escaping apostrophes.

Guide in Text & lists

You might also need

More in text & lists

Text-column extractor

Extract numbered columns from delimited lines without damaging quoted fields.

Text & lists

URL slug generator

Create URL-friendly slugs from titles while choosing ASCII or Unicode output.

Text & lists

Text-between extractor

Extract each piece of text between a pair of delimiters.

Text & lists

Text repeater

Repeat text a chosen number of times, with line breaks, spaces or your own separator.

Text & lists

Line-ending converter

Convert newline characters to LF, CRLF or CR and download exact bytes.

Text & lists

Invisible character generator

Copy blank spaces or zero-width characters with their exact Unicode code point and character count.

Text & lists

Unicode inspector and normalisation

Reveal code points, invisible characters and Unicode normalisation differences.

Text & lists

Remove duplicate lines

Remove repeated lines while retaining their original order.

Text & lists

List shuffler

Randomise the order of lines using unbiased cryptographic randomness.

Text & lists

Essential preferences

Theme, favourites and your consent choice keep the site working as you expect. These remain available when you reject analytics.

Optional analytics is off while availability is checked.

We remember your explicit choice for 180 days. Use Cookie preferences in the footer to change it. Read our privacy information.