How to Transpose a CSV or Excel File
Swap rows and columns instantly to read a wide table or compare a few records side-by-side — no formulas, no rewriting cells. 100% offline on Mac & Windows.
Quick Answer
- ✓Transposing swaps rows and columns — the fields that ran across the top become a column down the side, and each record becomes its own column, so you read one record straight down instead of scrolling across dozens of fields.
- ✓FileHop flips the view in one click. Open any CSV, Excel, Parquet, or SQLite file in the data viewer and toggle Transpose — the field names and record headers stay frozen as you scroll, and you can switch back to Grid anytime.
- ✓Everything stays on your device. FileHop reads the file locally, so confidential data is never uploaded to a server.
What does transposing do, and why would you want it?
Transposing a table rotates it 90 degrees: the columns become rows and the rows become columns. People reach for it to read a very wide table without scrolling sideways forever, to line up a handful of records and compare them attribute by attribute, or to sanity-check an export where the layout is easier to read flipped.
In a spreadsheet you'd normally do this with Paste Special > Transpose, which copies a range and pastes it rotated. It works, but it's fiddly: it rewrites every cell into a new range, breaks formulas and references that pointed at the old layout, and gets slow or hits limits on large selections. If all you want is to read the data the other way around, rewriting the whole file is a lot of work for a quick look.
How to transpose a file in FileHop
FileHop is a free desktop file browser with a built-in data viewer. Its Transpose view rotates the table live — no copying, no formulas, no new file.
Download and open FileHop
It's free for Mac and Windows and opens like Finder or File Explorer — no setup or accounts.
Open your CSV or Excel file
Click the file to preview it as a table. The same viewer opens CSV, Excel, Parquet, and SQLite, so it doesn't matter which format your data is in.
Switch to Transpose view
Toggle Transpose and the table flips 90 degrees: field names run down the left, each record becomes a column, and both the field-name column and the record header stay frozen as you scroll. Read one record top-to-bottom, or compare a few side-by-side.
Switch back to Grid anytime
Transpose is a live view, not a conversion — flip back to Grid whenever you want, or jump to Dashboard for an auto-generated chart. Nothing about your file changes.
Everything runs on your computer — your data is never uploaded, so it's safe for confidential or proprietary datasets.
Other ways to transpose a table
FileHop's view toggle isn't the only option. Here's how the common alternatives compare, and when they make sense.
Excel Paste Special > Transpose
Copy the range, right-click the destination, and choose Paste Special with Transpose ticked. It actually writes out a rotated copy, which is what you want if you need a transposed file to keep. The catches: it breaks formulas and references, you have to redo it every time the data changes, and large ranges are slow or hit limits.
Online transpose tools
Browser-based tools rotate small files with no install, but they upload your data to a third-party server and struggle with large files — a non-starter for confidential datasets or anything beyond a few hundred rows.
A formula like TRANSPOSE() or a script
Excel's TRANSPOSE() function or a few lines of pandas (df.T) will rotate the data and stay in sync, but you're writing formulas or code just to look at the data a different way — overkill when you only need to read it, not produce a new file.
Transposing in Excel vs. FileHop
How flipping a table in FileHop compares with Excel's Paste Special > Transpose.
| What matters | Excel Paste Special | FileHop |
|---|---|---|
| Flip with one click, no formulas | Multi-step copy & paste | Yes — one toggle |
| Works on a raw CSV (not just .xlsx) | No — open in Excel first | Yes — any file the viewer opens |
| Leaves your file untouched | No — rewrites cells into a new range | Yes — read-only live view |
| Instant on wide tables | Fiddly, slow on large ranges | Yes — flips instantly |
Frequently Asked Questions
What does it mean to transpose a table?
Transposing rotates the table 90 degrees so rows and columns swap places. The fields that ran across the top become a single column down the left, and each record becomes its own column. It's a quick way to read a very wide table or line up a few records to compare them.
Can I transpose a CSV without opening it in Excel?
Yes. FileHop opens a CSV directly in its data viewer, and the Transpose toggle flips the table in place. You don't need to import the CSV into Excel or use Paste Special — and it works the same on Excel, Parquet, and SQLite files too.
Does FileHop write out a new transposed file?
No. Transpose is a read-only view — it rotates how the data is displayed but never changes or re-saves your file. If you need a transposed file to keep, use Excel's Paste Special > Transpose, which rewrites the cells into a new range.
How many records can the Transpose view show?
The Transpose view shows up to 200 records, which become 200 columns after the flip. It's built for wide-and-short data — a handful of records with many fields — not for transposing thousands of rows. It rotates the rows currently loaded, a page of up to about 1,000.
What stays in place when I scroll a transposed table?
The field-name column on the left and the record header along the top stay frozen as you scroll, so you always know which field and which record you're looking at — even on a very wide flip.
When is transposing actually useful?
It's ideal for wide-and-short data: a single config row with dozens of settings, or a few items you want to compare attribute by attribute. Instead of scrolling sideways across many columns, you read one record straight down the screen.
Is my data uploaded anywhere?
No. FileHop reads the file directly on your computer and never uploads it. That makes transposing safe for confidential, proprietary, or regulated data that can't leave your machine.
How is this different from Excel's Paste Special > Transpose?
Excel actually rewrites your data into a new rotated range, which breaks formulas and references and gets slow on large selections. FileHop just flips the view instantly — no formulas, no rewriting, no new file — so it's faster for reading but won't produce a saved transposed copy.
Can I switch back to the normal layout?
Yes. Transpose is a live view toggle. Switch to Transpose to read a record top-to-bottom, then switch back to Grid whenever you want — your file is never altered either way.
Does it work on both Mac and Windows?
Yes. FileHop is free and runs on both macOS and Windows, transposing files the same way on each.
Flip any table in seconds
Free desktop app for Mac and Windows. Transpose, search, and filter your data — no formulas, no uploads.
Download FileHop Free