Swap an Excel table’s rows and columns

Drop a table (or paste one) and get it transposed right away: row 1 becomes column 1 and column 1 becomes row 1, with the shape shown as “5 rows × 12 columns → 12 rows × 5 columns”. Ragged rows are padded with blanks. Download Excel or CSV, or keep editing online.

Runs in your browser · no upload · no sign-up

怎麼用

  1. 1 Drop an Excel or CSV file, or paste a table
  2. 2 Preview the transposed table
  3. 3 Download Excel or CSV

能做

  • Transpose the whole table at once — no copy and Paste Special
  • Works on ragged tables; gaps are left blank
  • Numbers stay numbers
  • Pick which sheet of a workbook to transpose

不能做

  • Formulas are not re-referenced — the export holds values
  • Colours, borders and merged cells are not kept
  • No partial ranges — the whole sheet is transposed

常見問題

How is this different from Paste Special ▸ Transpose?

Same result, without selecting, copying and finding space to paste. Note that a table with more than 16,384 rows becomes more than 16,384 columns — Excel will truncate it, so split it first.

What happens to the header?

The header row becomes the first column — that is what transposing means.

Will my original file be changed?

No — you download a new file.

What about merged cells?

Merged cells keep only the top-left value; the other positions are blank.

Does it work on a phone?

Yes — tap the box to choose a file, and swipe the preview sideways.

Is the file uploaded?

No, everything runs in your browser.