Smart List Formatter
Turn pasted values into developer-friendly list formats.
Your data stays in your browser
Source list
Waiting for data
Format and cleanup
Cleanup runs in order: Trim → Remove empty → Deduplicate.
The shared source is never rewritten; only the formatted result changes.
Formatted list
No resultEnter or interpret a one-dimensional list to see a result.
Example
Deduplicate values · SQL IN list
Input
1001 1002 1002
Output
('1001','1002')How it works
- Output formats: one value per line, comma-separated, single- or double-quoted, SQL IN list, and JSON array.
- SQL IN quotes every value as text, doubles quotes inside values, and writes
NULLfor null values. - Trim surrounding whitespace, remove empty values, and deduplicate values (the first is kept).
- For a table, choose the column to format.