Sign up free

Transpose Rows and Columns in Excel

Turn a wide table into a tall one, or the other way round, without copying and Paste Special.

More tools
WordMerge WordSplit WordCompress WordCompare WordFind and Replace in WordDelete Blank Pages in WordWatermark WordProtect WordUnlock Word
Excel security & sizeCompress ExcelWatermark ExcelProtect ExcelUnlock Excel
PowerPointMerge PowerPointSplit PowerPointCompress PowerPointWatermark PowerPointProtect PowerPointUnlock PowerPoint
All Office filesOffice ViewerExtract Images from OfficeRemove Document Metadata

or drop files here

Accepts XLSX, XLS, CSV

Encrypted upload. Files are deleted automatically after 1 hour.

About Transpose Excel

Transpose Excel data when a report lists months across the top but your chart or import tool wants them down the side, or when a survey export puts each respondent in a column. Upload an XLSX, XLS or CSV file and every sheet comes back flipped: the first row becomes the first column, the second row the second column, and so on.

The result holds values only. Formulas are replaced by their results and cell formatting isn't carried over, so the new layout doesn't depend on cells that have moved. CSV files stay CSV; everything else comes back as an XLSX with _transposed added to its name.

How to use Transpose Excel

  1. 1
    Upload the sheet

    Click Choose file or drop the XLSX, XLS or CSV you want to flip.

  2. 2
    Click Transpose Excel

    Every sheet with data is flipped in an isolated process. There are no settings to choose.

  3. 3
    Download the result

    Save the _transposed file. An XLSX holds one flipped sheet for each original sheet.

Why use Cubfile for this

  • Every sheet at once

    A workbook with several sheets is transposed sheet by sheet, with the sheet names kept.

  • Values, not broken formulas

    Each cell holds the value it showed before, so nothing refers to cells that moved.

  • CSV in, CSV out

    A CSV comes back as a UTF-8 CSV that Excel opens without garbled characters.

  • Tidy column widths

    Columns in the new sheet are sized to fit their content.

FAQ

Transpose Excel: questions and answers

Does Transpose Excel keep formulas and formatting?
No. You get the values each cell displayed, without formulas, colors or merged cells. That's usually what you want after flipping a table, since formulas would point at the wrong cells. Should some figures come out as text, Excel & CSV Cleaner turns them back into real numbers.
How do I transpose Excel data without Paste Special?
Upload the file here and click Transpose Excel. It's handy on a phone or tablet, or when a sheet is too large to select and paste comfortably.
Is there a size limit when I transpose Excel data?
An Excel sheet can have at most 16,384 columns, so an XLSX sheet with more rows than that can't be turned sideways; save it as CSV first. Free accounts handle files of up to 50 MB and VIP up to 1 GB. A sheet that's too long can also be cut into smaller parts with Split Excel and transposed part by part.
How many times can I use it for free?
Visitors get 2 tasks in total and free accounts 2 a day. VIP has no daily limit.
Are my Excel files deleted after transposing?
Yes, automatically, one hour after the task. They're uploaded over HTTPS and handled in an isolated process, and we never look at the contents.
Share Transpose Excel with a friendIt runs in any browser, and they can try it without signing up.

Related tools

DOC Office ViewerOpen Word, Excel and PowerPoint files in the browser, no Office needed.
XLS Compare ExcelFind every changed cell between two spreadsheets.
DOC Compare WordHighlight every insertion, deletion and change between two documents.
XLS Compress ExcelMake workbooks smaller by shrinking images and dropping cached data.
PPT Compress PowerPointShrink presentations full of big photos.
XLS Excel & CSV CleanerTrim spaces, drop empty rows, fix number and date text in one go.
XLS Remove Duplicates in ExcelFind and remove duplicate rows by all columns or the ones you pick.
XLS Merge ExcelCombine workbooks into one file: as sheets, or rows appended.