Transpose rows and columns

Swap pasted data so vertical becomes horizontal, and the other way round. Free, and your data never leaves your browser.

Input
Result
Ad space: paste your AdSense code here

How to use it

  1. Copy a range of cells from Excel and paste it into the input box.
  2. Check the input and output separators.
  3. Copy the transposed result and paste it back into Excel or your document.

Frequently asked questions

Does it keep the Excel layout?

Yes. Pasted Excel cells use tabs between columns and line breaks between rows, and the tool swaps them.

Can I paste the result back into Excel?

Yes. Choose Tab as the output separator and paste into a cell.

More SQL tools

📋 List to IN clausePaste a column from Excel and get a quoted, comma-separated list for WHERE ... IN (...).✂️ Split to rowsTurn one line like a,b,c into one value per row.📥 Excel to INSERTPaste rows copied from Excel and get one INSERT statement per row.⚖️ Compare two listsFind what is in one list but not the other, what both share, or all unique values.🧹 Clean & sort linesTrim spaces, remove duplicates, sort, change case, and add text to every line.✨ SQL formatterPut each major clause on its own line and uppercase keywords.