CSV Tools New Tool

Free Online CSV Transpose, Turn Rows Into Columns

Turn the rows of a CSV into columns and the columns into rows, entirely in your browser. The header row becomes the first column and the first column becomes the new header, which is the part most tools get wrong. Ragged rows are squared up first so nothing lands in the wrong place, and a whole folder can be flipped at once.

Free Forever Nothing Uploaded Header handled Many files at once

Free Online CSV Transpose, Turn Rows Into Columns

Advertisement Slot (Top Banner) Google AdSense Unit • Responsive Banner

Bulk CSV Transposer Your file is read inside this tab. Nothing is uploaded anywhere.

Drop the CSV files you want flipped Rows become columns. Several files at once, each one flipped on its own. Choose files Up to 25 MB per file. Nothing is uploaded.

Or paste it

Reading the file Separator First row is a header Trim spaces around values

The header

Uneven rows Ignore completely empty rows

Writing the result Separator Quote every field Windows line endings, for Excel Add a byte order mark, so Excel reads accents

0 files - was - now 0 values padded

Before

Nothing to show yet.

Flipped

Nothing to show yet.

Buy Us A Coffee

Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.

Buy Us A Coffee

Sponsored Content (Below Tool) Google AdSense Placement

How to Transpose a CSV File

A few steps, and nothing is uploaded.

Drop the file in One CSV or several. Rows can also be pasted straight out of a spreadsheet.

Say what to do with the header The default swap is almost always what you want: the headings become the first column and the first column becomes the new headings.

Choose how uneven rows are padded Padding with empty values is safe. A dash makes the gaps visible, which helps when you are checking the result by eye.

Download the result One file as a CSV, or every file together as a zip. The counters show the grid size before and after.

What to Know About Transposing

Where the header goes, and what happens to uneven rows.

The header is the whole difficulty. After flipping, the old headings are no longer a header row, they are the labels down the left. A tool that rotates the grid and leaves the header on top produces a file where the first row is the first record and nothing is labelled. The default here moves the headings into the first column and promotes the old first column to be the new header, which is what a spreadsheet does too.

Uneven rows have to be squared up first. Transposing a grid where one row is shorter leaves holes in the middle of the result rather than at the end, and everything after a hole reads as if it belongs to the wrong label. The rows are padded to one width before the flip, and the number of padded values is reported.

Transposing twice does not always give you the original file back. If rows were padded on the way through, the padding is real data the second time round. It also will not match if you swapped the header the first time and not the second. On a clean rectangular file with the same settings, it does come back exactly.

A very wide result is harder to use than a tall one. Ten thousand rows transposed gives ten thousand columns, which Excel cannot open at all, since it stops at sixteen thousand and struggles long before that. The file itself is valid; it is spreadsheets that will not cope. Flipping is for reshaping modest tables, not for turning a long export sideways.

Values are moved, not reformatted. A leading zero, a currency symbol or a date spelling survives the flip untouched, because nothing is parsed on the way through.

Key Features & Capabilities

What this tool does, and what it deliberately does not.

Header done properly Headings move into the first column and the first column becomes the new header, the way a spreadsheet does it.

Squared up first Uneven rows are padded before the flip so no value ends up under the wrong label.

Three header modes Swap it, keep it on top and flip only the data, or treat the whole file as data.

A folder at a time Every file flipped separately with the same settings, downloaded together as a zip.

Values untouched Nothing is parsed or rewritten, so codes, prices and dates come out exactly as they went in.

Nothing is uploaded The flip happens in this tab, so internal reports never leave your computer.

About the CSV Transposer

Data arrives in whichever shape the system that produced it preferred. A report gives you one row per month and one column per region; the chart you need wants one row per region and one column per month. Neither shape is wrong, and getting from one to the other by hand means retyping a grid, which is slow and error prone in a way that is hard to spot afterwards.

Spreadsheets can do it with a paste special, and that is fine for one table. It stops being fine when the file is too big to open comfortably, or when there are twenty files that all need the same flip, or when the thing on the other end is an import rather than a person.

The reason a dedicated tool is worth having is the header. Flipping a grid is four lines of code; deciding what happens to the labels is the actual problem. Headings that stay on top after a flip are meaningless, because they describe columns that no longer exist. Moving them into the first column keeps every value labelled, and promoting the old first column to be the new header keeps the file readable by anything that expects a header row.

Frequently Asked Questions

Headers, ragged rows, big files and doing it twice.

By default it becomes the first column, and your old first column becomes the new header row. That is what keeps everything labelled, and it is what a spreadsheet does when you transpose a table with headings.

On a clean rectangular file with the same settings, yes, exactly. If rows had to be padded the first time, the padding is real data on the second pass, so the result will have extra empty values.

That is Excel rather than the file. It stops at about sixteen thousand columns and gets slow well before that. Transposing is for reshaping modest tables; a long export turned sideways is usually better handled by whatever is consuming it.

They are padded to the full width before the flip, otherwise the result has holes in the middle and values end up under the wrong label. You can pad with empty values or a dash, or drop those rows first.

No. Cells are moved, never parsed. Leading zeros, currency symbols and date spellings all come through exactly as they were.