Convert a row of values into a column. Auto-detect commas, tabs, semicolons or pipes, respect quoted items, trim and de-duplicate, and keep several rows grouped.
Free, no sign-up
Runs in your browser
Your data stays private
How to use the Row to Column Converter
Paste a row of values (comma, tab, semicolon or pipe).
Leave the separator on auto-detect or choose your own.
Copy the vertical list.
Why use this Row to Column Converter
Auto-detectFinds the separator for you, including tabs copied from Excel.
Quote awareQuoted items containing commas stay in one piece.
Several rowsJoin them into one long column or keep a blank line between rows.
CleanupTrim items, skip empties, remove duplicates and quotes.
Frequently asked questions
How do I convert a row to a column?
Paste the row. Each value moves to its own line.
Can I split on a custom separator?
Yes. Choose "Custom text" and type the separator, such as " - " or "/".
What if I paste several rows?
Choose "One long column", or "Blank line between rows" to keep them separate.