Transpose Excel — Swap Rows and Columns
Upload any Excel file, preview the transposed layout, and download the result in one click. Works for single sheets or entire workbooks. Your file never leaves your browser.
Drop your Excel file here
or click to browse — .xlsx, .xls, .xlsm, .xlsb
100% private — your file never leaves your browser
How to Transpose Excel
Upload your file
Drag and drop your Excel file onto the tool or click to browse. The tool reads it instantly in your browser.
Preview and configure
See the original and transposed dimensions. Choose whether to transpose the active sheet or all sheets in the workbook.
Download result
Click Transpose and download the result as a new .xlsx file. The original file is unchanged.
When Do You Need to Transpose?
Transposing is the operation of rotating a table so that rows become columns and columns become rows. Common scenarios where you need to transpose Excel data:
- Wrong orientation from a source: An export from another system has months as rows but your template needs them as columns
- Pivot table compatibility: Pivot tables need data in rows (one record per row) — if you have data in columns, transpose first
- Charts: Some chart types require data in a specific orientation that doesn't match your source
- Survey data: Survey tools often export with respondents as columns — transpose to get one respondent per row for analysis
- Legacy format conversion: Old reporting formats sometimes store time series as columns; modern tools expect rows
The Excel built-in TRANSPOSE() function can do this too, but it creates formulas rather than static values, and requires knowing the exact output size in advance. This tool gives you clean static values in one click.
Frequently Asked Questions
What does transposing an Excel spreadsheet do?
Transposing rotates your data 90 degrees — what were rows become columns and what were columns become rows. For example, a table with 100 rows and 5 columns becomes a table with 5 rows and 100 columns. This is useful when you receive data in the wrong orientation for your template, chart, or analysis tool.
Does transposing preserve my formulas?
No — formulas are converted to their calculated values during transposition. This is expected behaviour, because cell references inside formulas (like =A1+B1) would no longer be valid after a transpose. The data values are preserved correctly.
Can I transpose just one sheet in a multi-sheet workbook?
Yes. When you upload a workbook with multiple sheets, you can choose to transpose only the active (selected) sheet, leaving other sheets unchanged. Or you can transpose all sheets at once.
Is there a size limit for the Excel file I can transpose?
There is no hard limit — the tool is constrained only by your browser's available memory. Files up to 50 MB work well in most modern browsers. Very large files with millions of cells may be slow to transpose.
Why would I need to transpose data?
Common scenarios include: receiving survey data with respondents as columns instead of rows, getting financial data in the wrong orientation for a chart or pivot table, working with systems that export rows as headers, or needing to reformat legacy data to match a standard template.