What Comma Separator does
Comma Separator scans entered text and collects values separated by whitespace, commas, semicolons, or pipe characters. Text inside balanced double quotes stays together, including escaped doubled quote characters.
The output can use comma plus space, comma, semicolon plus space, or pipe. Values containing the selected delimiter, a quote, or a line break are wrapped in quotes, with internal quotes doubled.
How to use Comma Separator
- Paste values separated by spaces, lines, commas, semicolons, or pipes.
- Place double quotes around any value whose internal spaces must be retained.
- Choose the required output delimiter and select Separate values.
- Inspect quoted entries and copy or download the formatted single list.
Important details
Quoted values
A value such as "New York" is kept as one item rather than split at its space. Within a quoted value, two consecutive quote marks represent one literal quote.
This is not a full table parser
The scanner produces one flat value list. It does not preserve rows and columns from CSV, infer empty fields, recognize headers, or apply spreadsheet data types.
Practical uses
- Reformat a pasted tag or keyword list for a configuration field.
- Join one-item-per-line values into a compact delimited string.
- Normalize a simple list while retaining quoted city or product names.
Privacy and limitations
Parsing happens entirely in this tab and the list is not uploaded to PagesTools. Avoid pasting personal records when a synthetic sample would be sufficient.
Input is capped at two million characters. Unclosed quotes are rejected, blank fields are discarded, and complex CSV with meaningful rows, empty cells, embedded newlines, or a nonstandard escape convention needs a dedicated parser.