List Converter

Transform lists between formats - comma-separated, newline, bulleted, numbered, JSON array, SQL IN clause, and HTML.

Loading...
1. Paste your list into the input area in any supported format (comma-separated, newline, tab-separated, etc.). 2. Let the tool auto-detect the input format or manually select it from the input format dropdown. 3. Choose the desired output format: newline, comma-separated, bulleted, numbered, JSON array, SQL IN clause, or HTML list. 4. Review the converted list in the output area with items cleaned, trimmed, and properly formatted. 5. Click the copy button to copy the converted list to your clipboard.

About This Tool

The List Converter transforms lists between a wide variety of popular formats with a single click. Paste a comma-separated list and convert it to one item per line, a bulleted Markdown list, a numbered list, a JSON array, a SQL IN clause, or an HTML unordered list. The tool auto-detects your input format or lets you specify it manually.

This tool is a huge time-saver for developers, data analysts, content writers, and anyone who works with lists in different contexts. Convert a column of spreadsheet data into a SQL query, turn a bulleted list from a document into a JSON array for an API, or reformat comma-separated tags into a clean newline-separated file - all instantly.

Supported input formats include newline-separated, comma-separated, semicolon-separated, and tab-separated lists. Output formats include all input formats plus bulleted lists, numbered lists, JSON arrays, SQL IN clauses, and HTML unordered lists. Items are automatically trimmed of whitespace and empty items are removed.

Frequently Asked Questions

The tool counts the occurrences of newlines, commas, semicolons, and tabs in your input and uses the most frequent separator as the detected format. You can override this by manually selecting an input format from the dropdown.
Yes. Select 'SQL IN clause' as the output format and the tool will wrap each item in single quotes and format them as a SQL IN expression like ('item1', 'item2', 'item3'). Single quotes within items are properly escaped.
Yes. Each item is trimmed of leading and trailing whitespace, and empty items (blank lines or consecutive separators) are automatically removed from the output.
Yes. When you copy a column from Excel or Google Sheets, it is typically tab-separated or newline-separated. Paste it into the tool and select the appropriate input format (or use auto-detect) to convert it to any output format.
The HTML output generates a properly formatted <ul> element with each list item wrapped in <li> tags. The output is indented for readability and can be pasted directly into any HTML document.

Related Tools

Sort Lines

Sort lines of text alphabetically (A-Z or Z-A), by line length, numerically, or shuffle and reverse them randomly.

Text and Writing

Remove Duplicate Lines

Remove duplicate lines from your text while preserving the original order. Supports case-sensitive and case-insensitive modes.

Text and Writing

JSON Formatter and Validator

Format, validate, and beautify JSON data with syntax highlighting, tree view, and error detection.

Developer Tools

CSV to JSON Converter

Convert CSV data to JSON arrays or objects with automatic type detection and header mapping.

Developer Tools