Transpose Excel

What Transposing Actually Does Here

The selected sheet is read into a grid, squared off to the width of its longest row, and then flipped about its diagonal: the cell at row 2, column 5 becomes row 5, column 2. Row 1 becomes column A, row 2 becomes column B, and a sheet of 500 rows by 8 columns comes back as 8 rows by 500 columns. Both grids are shown side by side - the first eight rows and six columns of each - so you can confirm the orientation before downloading.

What Crosses Over and What Does Not

Cell values cross over: text, numbers, and TRUE/FALSE all land in their mirrored position. Formulas do not - they are written as the value they last calculated, because every relative reference in a transposed sheet would point somewhere different. Number formats, fonts, fills, merged cells, and column widths are not carried across either, so a date shows up as the serial number Excel keeps underneath it and needs a date format reapplying. The download is a single sheet named Transposed; the other sheets in your workbook are not included, and your original file is never modified.

Edge Cases

Ragged rows are padded with blanks rather than shifted, so nothing slides into the wrong column. Completely empty rows in the original become completely empty columns in the result - they are not dropped, which keeps positions aligned with the source. The hard ceiling is the format itself: a worksheet holds 16,384 columns, so a sheet with more than 16,384 rows cannot be transposed in full and the overflow is dropped from the written file. Very wide results are also awkward to work with even when they are legal - past a few thousand columns, most people are better served by reshaping the data than by mirroring it.

How to Transpose an Excel Sheet

1. Upload the workbook - .xlsx, .xls, .xlsm, or .xlsb, read in your browser.
2. Select the sheet - only the chosen sheet is transposed and downloaded.
3. Compare the two previews - the header row of the original should read down the first column of the result.
4. Download Transposed - a new workbook; the original is untouched.

In desktop Excel the equivalents are Copy, then Paste Special with Transpose ticked - which, like this tool, pastes values and loses the formulas - or the TRANSPOSE function, which stays live but spills into a range you must leave clear. Use this page when the sheet is large enough that a paste is awkward, or when you want the result as a separate file rather than in the same workbook.

When a Different Tool Fits Better

Transposing is often reached for when the real problem is layout, not orientation. If your sheet has one column per month or per region and you want it analyzable, you want Unpivot Excel - it flattens a crosstab into one row per observation, which is what pivot tables and charts expect, and is not the same thing as a mirror image. If you only wanted to read across a wide table, INDEX and MATCH does that without reshaping anything. To narrow the sheet before flipping it, use Excel Column Extractor, and to put separately transposed sheets back into one file, use Excel Merge.