Skip to content

List Converter

Convert a list between comma-separated, newline-separated, JSON array, and other common formats - with optional sorting and deduplication.

Category: converter
Use Case: Turning a Spreadsheet Column into a JSON Array, Cleaning Up a Messy List of Values, Formatting a List for Code or a Config File
Privacy: 100% browser-based

4 items

Recommended Settings

Pro Tips

  • Input accepts either comma-separated or newline-separated values (or a mix of both), so you can paste directly from a spreadsheet column or a comma-separated line
  • Blank lines and extra whitespace around each item are automatically trimmed and ignored
  • Combine sorting and deduplication to quickly turn a messy pasted list into a clean, unique, alphabetized one
  • The quoted, comma-separated format is handy for pasting values directly into code as a list of string literals

Most Popular

Most people paste a spreadsheet column and convert it into a JSON array or a quoted, comma-separated list for use in code

When to Use This Tool

Turning a Spreadsheet Column into a JSON Array

Paste a column of values and get a ready-to-use JSON array.

Cleaning Up a Messy List of Values

Remove duplicates and sort a list pasted from an inconsistent source.

Formatting a List for Code or a Config File

Convert a list into quoted, comma-separated values ready to paste into source code.

Converting Between List Formats

Switch a list from newline-separated to comma-separated or vice versa.

How It Works

1

Split the input on both commas and newlines, trimming whitespace and discarding empty entries

2

Optionally remove duplicate items and sort the remaining items alphabetically

3

Join the resulting list back together in your selected output format

100% Private

Files never leave your device. All processing happens locally in your browser.

Lightning Fast

Powered by Client-side text parsing and formatting for optimal performance on modern browsers.

Open Source

Built with verified, open-source libraries. Fully transparent.

Frequently Asked Questions

Can I mix commas and newlines in my input?

Yes, the tool splits on both commas and newlines, so a pasted mix of formats is handled the same way.

Is deduplication case-sensitive?

Yes, 'Apple' and 'apple' are treated as different items. Trim and normalize case in your input first if you need case-insensitive deduplication.

What does the JSON array format look like?

Each item becomes a quoted string in a properly formatted JSON array, ready to paste directly into JavaScript, Python, or any JSON-based configuration.

Is my list data sent anywhere?

No. All parsing and formatting happens locally in your browser.