Column to Row Converter

Convert a column of values into a row. Join lines with commas, tabs or custom text, split into several rows of N items, quote values and remove duplicates.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the Column to Row Converter

  1. Paste a column of values, one per line.
  2. Choose the separator and how many items go in each row.
  3. Copy the row, or paste tab-separated output into Excel.

Why use this Column to Row Converter

  • Items per rowMake one long row, or rows of 3, 5 or any size.
  • Excel friendlyUse tab separation to paste a row straight into a spreadsheet.
  • QuotingNever, only when needed, or always.
  • CleanupTrim items, skip blanks and remove duplicates.

Frequently asked questions

How do I convert a column into a row?

Paste the column and choose a separator. All lines are joined into one row.

Can I create several rows?

Yes. Set "Items per row" to a number such as 4 and the output wraps after every 4 items.

How do I paste the result into Excel?

Choose the Tab separator, copy the output and paste it into a cell. The values fill across.

Related tools

More Lists & Naming tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.