Comma Separator

How It Works

Comma-separated values (CSV) are one of the most widely used data interchange formats. This tool handles the two most common manual tasks: joining a list into a single CSV string, and splitting a CSV string back into a list.

Lines to CSV:
Each line of your input becomes one value in the output, separated by a comma (or your chosen separator). The options let you control the exact format:

- Trim whitespace: removes leading and trailing spaces from each line before joining.
- Add quotes: wraps each value in double quotes — useful when values may contain commas themselves, or when pasting into a spreadsheet that needs quoted strings.
- Custom separator: use any character in place of a comma — a semicolon for European locale spreadsheets, a pipe for database imports, a tab for tab-separated values.

Example:
Input:
apples
bananas
cherries

Output (with quotes): "apples","bananas","cherries"

CSV to Lines:
The input is split on the separator character. Each resulting value is placed on its own line. Options:
- Trim whitespace: strips spaces around each value after splitting.
- Strip quotes: removes surrounding double or single quotes from each value.

Example:
Input: "apples","bananas","cherries"
Output (strip quotes):
apples
bananas
cherries

This is useful when you receive data in a single row (from a database query, an API response, or a spreadsheet copy) and need to process each item separately.