Transpose Excel Rows and Columns
Rows into columns and columns into rows: the first column becomes the new header.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Transpose Excel Rows and Columns
- 1Select your file, or drop it on the page
- 2Run it — nothing to set up
- 3Download transposed.xlsx
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
How do I switch rows and columns in Excel?
Upload the file and download it transposed: what were rows are columns, with the first column as the new header.
Is it the same as Paste Special → Transpose?
The result is the same, without selecting ranges, and it works on a CSV too.
Is there a size limit?
Excel has 16,384 columns, so a table with more rows than that cannot be turned on its side.
Is my file kept?
Your file is not: it is processed in an isolated sandbox that is deleted afterwards. The result waits behind its download link for 2 hours, then it is deleted too.