Guides JP

List Formatter

Convert lists between newline, comma, tab, and space delimiters, and add quotes, prefixes, suffixes, and numbering in one place.

Last updated: 2026/10/16 Text Feedback & bug reports
Input
Delimiter conversion
Per-line decoration
Cleanup options
0Input
lines
0Output
items
0Removed
lines
Result

How to Use

1

Enter Your List

Type or paste the list into the input box. Newline, comma, or tab separated lists are all detected automatically.

2

Pick Delimiter & Decoration

Choose the output delimiter and, if needed, set quotes, a prefix, a suffix, or numbering.

3

Clean It Up

Enable remove empty lines, remove duplicates, or trim to tidy the list up.

4

Copy the Result

The result updates in real time. Press the copy button and paste it wherever you need it.

About the List Formatter

Tab-separated data copied from a spreadsheet, items stacked one per line, a comma-joined list — lists arrive in many shapes. This tool freely converts between those delimiters and lets you add quotes, prefixes, suffixes, or numbering to each line, as well as remove empty or duplicate lines, so you can reshape any list in seconds. Everything runs locally in your browser, so your text is never sent to any server.

Features

  • Convert Between DelimitersFreely convert between newline, comma, tab, and space delimiters, with automatic detection of the input delimiter.
  • Quotes, Prefixes & NumberingAdd quotes, prefixes, suffixes, and numbering to each line — handy for SQL IN clauses and building code arrays.
  • Real-time ProcessingResults update the moment you type or change an option — no waiting.
  • Privacy ProtectedAll processing happens in your browser. Your text is never sent to a server.

Use Cases

  • Turn one Excel column into a comma list or SQL IN clause
  • Format a newline list into a JSON or code string array
  • Expand a comma-separated list into one item per line
  • Prefix each line with "- " to build a Markdown bullet list
  • Strip duplicates and blank lines from rosters or email lists

FAQ

Is the list formatter free to use?
Yes, it is completely free. No registration or installation is required — just open it in your browser.
Can I convert a comma list into one item per line?
Yes. Set the input delimiter to "Comma" or "Auto-detect" and the output delimiter to "Newline", and the comma list expands into one item per line. The reverse conversion works the same way.
How do I build a SQL IN clause or a code array?
Choose "Single" or "Double" quotes and set the output delimiter to "Comma". Each item is wrapped in quotes and joined with commas. Combine a prefix and suffix to add the surrounding brackets.
How are empty and duplicate lines handled?
Enabling "Remove empty lines" strips blank lines, and "Remove duplicate lines" keeps only the first occurrence of each line. Combine these with trim so duplicates are matched regardless of surrounding whitespace.
Is my text stored on a server?
No. All processing runs locally in your browser with JavaScript, and your text is never sent to or stored on any server. You can safely format lists that contain personal information.

Related Tools

Line Break Remover Remove or replace line breaks, collapse spaces & trim text Text Sort & Dedupe Sort lines, remove duplicates, trim & clean text at once Case Converter Convert to camelCase, snake_case, kebab-case & more in bulk

Popular Tools

Character Counter Count characters, words, and lines in real-time JSON Formatter Format and validate JSON with syntax highlighting QR Code Generator Create custom QR codes with logo, colors & styles Password Generator Generate secure random passwords with one click Base64 Encoder Encode and decode text or files to Base64 IP Address Checker Check your global IP address