List Converter

Free online tool. All processing is client-side. No signup needed.

How to Use the List Converter

1. Enter your input values above
2. Results update automatically
3. Copy or download the output

What is a List Converter?

A List Converter transforms text lists between different formats — comma-separated, newline-separated, JSON array, bullet points, numbered lists, semicolon-separated (CSV European), and pipe-separated. This is a surprisingly common need: turning an email list from 'one per line' to 'comma-separated' for a database query, formatting a CSV column into a JSON array for code, converting a numbered list to bullet points for a presentation. The tool handles common edge cases: trimming whitespace, removing empty lines, handling quoted items, and deduplication.

How Does It Work?

Paste a list in any format. The converter auto-detects the input format (commas, newlines, bullets, JSON array format) and offers conversion to any output format. Key features: (1) auto-trim whitespace around each item, (2) remove empty items, (3) remove duplicate items (optional), (4) sort alphabetically or numerically (optional), (5) add or remove quotes around items, (6) add prefixes or suffixes. Common conversions like 'newlines → comma separated' and 'JSON array → bullet list' have one-click buttons.

Formula

Input Format Detection:\n• Newlines → items split by \\n, \\r\\n, or \\r\n• Commas → items split by , (with optional space)\n• JSON Array → parsed as valid JSON array: [\

Who Uses This Tool?

• Developers converting column data to JSON arrays or SQL IN clauses
• Marketers formatting email lists for CRM import/export
• Content writers converting between bullet and numbered list formats
• Database admins transforming query results for configuration files
• Anyone with a list in the wrong format for their current task

Pro Tips

• For SQL IN clauses, select 'SQL format' and the converter wraps items in quotes and parentheses automatically
• The auto-detect feature handles most cases, but you can manually override the input format if the detection is wrong
• When converting CSV data with commas within items, use the 'quoted CSV' mode which respects RFC 4180 quoting rules
• Deduplication + sorting is powerful: paste a messy list with duplicates, let the converter clean it into a sorted, unique, formatted list

Frequently Asked Questions about List Converter

How does it handle items that contain the delimiter?

Items containing commas (like 'San Francisco, CA') must be double-quoted in CSV format. Our converter automatically quotes items containing the output delimiter to ensure valid CSV output.

Can I convert between ordered and unordered lists?

Yes. Select 'Numbered' as output to convert any list to 1., 2., 3. format, or 'Bullets' to convert to bullet points. The numbering/bullet style is customizable.

Free online List Converter — no signup, 100% client-side processing. All data stays in your browser.