Transpose Excel Files Online
Transpose Excel files — flip rows and columns — directly in your browser. No upload, no server.
How to transpose Excel files
- Drop your file onto the upload area. The tool shows the row and column count and previews the first 200 rows.
- Check the notice above the preview. Files with more than 500 rows are transposed using only the first 500 rows.
- Click Transpose. Each original column becomes a row, and the counts update to show the new shape.
- Review the transposed table, then click Download CSV. The result is always saved as a CSV file named after your input with _transposed added.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A web team keeps quarterly visit totals with one row per region. A slide template needs the quarters running down the page and the regions across the top.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| region | q1_visits | q2_visits | q3_visits |
|---|---|---|---|
| North | 1840 | 2105 | 1990 |
| South | 960 | 1130 | NULL |
| West | 2410 | 2290 | 2675 |
Settings
- No options. The first 500 rows are transposed (this file has 3).
Result
| Field | Row_1 | Row_2 | Row_3 |
|---|---|---|---|
| region | North | South | West |
| q1_visits | 1840 | 960 | 2410 |
| q2_visits | 2105 | 1130 | 2290 |
| q3_visits | 1990 | 2675 |
Three rows and four columns become four rows and four columns. The old header names move into a new first column called Field. The new headers are Row_1, Row_2 and Row_3, not the region names. Every value is written as text, and the missing Q3 figure for South becomes an empty cell.
Working with Excel files
Only the first sheet of the workbook is read. The sheet is turned into text using the values as Excel displays them, then column types are detected again. Date cells are the exception: a cell showing 3/2/26 is read as the date 2026-03-02, and that is how it appears in the output. Formulas are read as their last saved results.
This is an alternative to Paste Special with Transpose ticked in Excel. The difference is the output: you get a CSV file, not a new sheet, and the headers are Field, Row_1, Row_2 and so on. Excel can open that CSV directly. Since at most 500 rows are transposed, the result has at most 501 columns, well inside the 16,384 columns a worksheet allows. Cell formatting, colours and merged cells are not carried over. Hidden rows and columns on the sheet are read like visible ones, so they appear in the output too. Unhide them in Excel first to see what is there, or remove unwanted columns with the Columns tool before transposing.
Frequently Asked Questions
Is this the same as Paste Special > Transpose in Excel?
The flip is the same, but the result is a CSV download rather than a pasted range. It also adds a Field column holding the old headers and names the new columns Row_1, Row_2 and so on.
Which sheet is transposed if my workbook has several?
The first sheet only. Save the sheet you want as its own workbook, or extract it with the Excel Sheet Extractor, then transpose it.
What do the column headers look like after transposing?
The first column is called Field and holds your original column names. The other columns are named Row_1, Row_2 and so on, one per original row. The values in your first column do not become headers.
Is there a row limit?
Yes. Only the first 500 rows are transposed, which gives at most 501 output columns. The tool warns you before you click Transpose if your file has more rows than that.
What format is the transposed file saved in?
Always CSV, whatever format you uploaded. All values are written as text and empty values become empty cells.
Related Tools
Rename Columns in Excel Files Online
Rename columns in Excel files instantly in your browser. No upload, no server — your data stays on your device.
Unpivot Excel Files Online
Reshape Excel files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
Manage Columns in Excel Files Online
Drop or select specific columns from Excel files directly in your browser. No upload required.
Transpose CSV Files Online
Transpose CSV files — flip rows and columns — directly in your browser. No upload, no server.
Transpose Parquet Files Online
Transpose Parquet files — flip rows and columns — directly in your browser. No upload, no server.
Transpose JSON Files Online
Transpose JSON files — flip rows and columns — directly in your browser. No upload, no server.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.