カンマ区切りツールとは?
無料のオンライン カンマ区切りツール。テキスト行をカンマで結合、またはカンマ区切りテキストを行に分割。
Comma-separated data is everywhere — CSV files, import/export data, keyword lists, email address collections, and database output. Working with delimited text often requires splitting it into lines for editing, joining items with a delimiter, cleaning messy formatting, or removing duplicates. Comma Separator provides four processing modes with customizable delimiters.
In Split mode, the tool splits delimited text into individual lines. Enter "apple, banana, cherry" and it becomes a vertical list: apple, banana, cherry. This is useful for viewing, editing, or reordering individual items from a comma-separated list.
Join mode does the reverse — it takes a vertical list of items and joins them with your chosen delimiter. A list of email addresses on separate lines becomes a comma-separated string ready for an email client's "To" field. The quote-wrapping option adds single or double quotes around each item, which is essential for CSV formatting.
Clean mode splits text by any common delimiter (comma, semicolon, tab, newline, pipe), trims whitespace from each item, removes empty entries, and rejoins with commas. This is ideal for fixing messy data where items might be separated by inconsistent delimiters. Deduplicate mode removes duplicate entries while preserving the order of first occurrence.