Start a project

Tool 360 of 425 · Text lists

List Delimiter Converter

Re-delimits a list, with quoting, prefixes, trimming and dedupe, and also gives a JSON array.

List Delimiter Converter

Your input

Result

Result
JSON array

01

What it does

Re-delimits a list, with quoting, prefixes, trimming and dedupe, and also gives a JSON array.

  • Auto-detects the input delimiter
  • Quote with ', " or `
  • Prefix and suffix each item
  • Trim, dedupe, drop empties

02

Private by design

Everything happens in your browser. Nothing you type, paste or upload is sent anywhere, and it keeps working offline once the page has loaded.

03

What you get

The converted list and a JSON array, with a Copy and a Download button on every result.

  • Comma separated
  • SQL IN list
  • Text lists

Why it matters

Copying a spreadsheet column into an SQL IN (...) clause, a JavaScript array or a comma list is a daily chore.

Set the quote and delimiter and paste the column.

How to use it

  1. Type or paste your input; the example shows the format.
  2. Press Convert list. Results also update as you type.
  3. Read the summary line, then the table, notes or output below it.
  4. Copy or download what you need. Nothing leaves this page.

FAQ

How do I make an SQL IN list?

Quote: single, output: comma + space, then wrap in IN (...).

Does it handle quoted CSV fields?

Simple ones. For full CSV use the JSON CSV converter.

Is my input uploaded?

No. The tool runs in your browser and nothing you type, paste or open is sent anywhere.

Can I rely on the result?

It follows the public specification or formula named on this page and says where it simplifies. Check anything critical against the official tool or documentation before you ship it.

Work with me

Want a site that gets these right?

I build fast, accessible websites and web apps that pass these checks from day one. Tell me about your project and I'll reply personally with honest next steps.

All developer tools · Back to leej.uk