Transpose CSV: flip rows into columns and columns into rows
In short: Upload or paste a table and get it back flipped, with the first column of the original as the new header row, ready to download. Limit: It treats the header row as an ordinary row.
Upload a CSV or .xlsx file, or paste it with a header row. The tool flips the table: each row becomes a column and each column becomes a row, with the header row counted as the first row. The first column of your original becomes the header of the new file. Download the flipped CSV.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
A 4 by 4 example table is flipped: the new header is Metric, Sent, Bounced, Replies, with one row each for Mon, Tue and Wed.
- Rows now
- 4
- Rows before
- 4
- Columns before
- 4
What this means for you
Flipping a table does not show which addresses exist; a check does.
- Rows to columns
- Nothing summed
- Uneven rows padded
- Flip back anytime
- Transpose
- CSV
- Flip
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Flipped a list of contacts? Check the addresses before you use it.
- Download the file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I transpose a CSV file?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Check the counts: the rows and columns before and after.
- Read the preview, where the first column of your file is now the header row.
- Download the transposed CSV.
Example
- You enter
- A table of 4 rows and 4 columns: Metric, Mon, Tue and Wed as the header, then Sent, Bounced and Replies with a number for each day.
- You get
- 4 rows and 4 columns flipped. The new header is Metric, Sent, Bounced, Replies, followed by one row for Mon, Tue and Wed.
- Limits
- Runs in your browser; nothing is uploaded. It only turns the table on its side; it does not add up or summarise values.
When do you need to transpose a table?
Reports often come with one row per metric and one column per day, while the tool you want to load them into wants one row per day. Flipping the table fixes the shape without retyping a cell. It also helps when a form export puts each answer in a column and you want to read one person's answers down the page.
The header row counts as an ordinary row, so Metric, Mon, Tue, Wed becomes the first column of the new file.
What happens to uneven rows?
If some rows have fewer cells than others, the missing cells become blanks so every row in the new file has the same width. Nothing is dropped. The count of rows and columns before and after is shown so you can check the shape.
Flipping twice returns the original table. To rename or reorder the columns afterwards, use the CSV column editor.
Is this the same as a pivot table?
No. A pivot table summarises values, adding them up by a category. Transposing only turns the table on its side and keeps every value. To count how often each value appears, use the count unique values tool; to put several rows into one cell, use group rows and join values.
Who uses this tool, and for what?
- Marketers
- Turn a weekly report with one column per day into one row per day for a dashboard.
- Researchers
- Read one respondent's answers down a page instead of across a wide row.
- Developers
- Reshape a small data file before loading it into a script or a sheet.
What can’t this tool tell you?
- It treats the header row as an ordinary row.
- It does not add up, count or summarise values.
- A very wide table makes a very long one that is slow to scroll.
- Only the first sheet of a workbook is read.
Common questions
- Does it keep every value?
- Yes. Every cell moves to its flipped position and nothing is added up, changed or dropped.
- What is the header row of the result?
- The first column of your original file. Blank header cells are named column_1, column_2 and so on in the preview.
- What if a row is shorter than the rest?
- Missing cells become blanks, so every row in the new file is the same width.
- Can I flip it back?
- Yes. Transposing the result again returns the original table.
- Is there a size limit?
- No fixed limit, but a very wide table makes a very long one, and the preview shows only the first rows. The download holds all of them.
- Is my file uploaded?
- No. It is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.