How to use it
- Copy a column from Excel or Google Sheets and paste it above. Each cell becomes one line.
- Pick a separator and quotes. Comma + space gives a, b, c; single quotes with a comma give 'a','b','c'.
- Choose whether to drop blank lines, extra spaces and duplicates, then copy the result. It updates as you change options.
What it is for
- Email recipient boxes: join an address column with semicolon + space to get
a@x.com; b@x.com. - SQL conditions: join order numbers with single quotes, commas and parentheses to get
('1001','1002','1003'), ready to paste afterIN. - Code arrays and keyword lists: double quotes with commas give
"a","b","c". - Turn on duplicate removal for columns with repeated values. To only sort or tidy lines, use Remove Duplicate Lines or Sort Lines.
Examples
The input is five lines: " apple / pear / (blank) / apple / grape ". The values below were produced by running this tool's own function.
| Settings | Result |
|---|---|
| Comma + space, default cleanup | apple, pear, apple, grape (1 blank line removed) |
| Comma + space, remove duplicates | apple, pear, grape |
| Comma, single quotes, remove duplicates | 'apple','pear','grape' |
Things to watch
- If a value contains a comma, joining with commas makes the boundaries unclear. Use double quotes or a semicolon.
- A single quote inside single quotes is doubled (
O'Brienbecomes'O''Brien'), as SQL expects. If you need another style, fix it with Find and Replace. - Duplicates are matched exactly after trimming, and case matters.
- Your list is processed only in the browser and is never sent to a server.