Skip to content
Allin
Sign up · Sign in

CSV transpose

Swap the rows and columns of delimited data. Paste the text or drop the file; nothing leaves the page either way.

Related tools

All JSON, XML & formats tools →
CSV to JSON converterParse CSV text (with header row) into a JSON array of objects, handling quoted fields. Drop a file in rather than pasting it — it is read in your browser and never uploaded.CSV to Markdown tableTurn CSV into a Markdown table, quoting and all: a field may hold the delimiter, a line break or a pipe and the table still lines up. Comma, semicolon (French Excel), tab or pipe, detected or forced.JSON to CSV converterTurn a JSON array of objects into comma-separated values with a header row. Takes a whole file, so a long log does not have to go through the clipboard.CSV / JSON / YAML converterConvert between CSV, TSV, JSON and YAML, and see the rows as a table.CSS BeautifierReformat minified or messy CSS into clean, properly indented rules — or minify it back.CSS minifierShrink CSS by removing comments and unnecessary whitespace.HTML BeautifierTurn minified or tangled HTML into cleanly indented, readable markup — or minify it.ISO 8601 Date FormatterTurn any date, time and UTC offset into ISO 8601, RFC 3339, week/ordinal date, RFC 2822, HTTP date and Unix timestamps.

CSV transpose works straight from this page — free, instant, nothing to install. It sits under JSON, XML & formats in our catalogue, alongside CSV to JSON converter and CSV to Markdown table.

How to use it

  1. Open the tool — no signup or install needed.
  2. Enter your input or adjust the available options.
  3. Get your result instantly, then copy or download it.

Frequently asked questions

What is CSV transpose?

Swap the rows and columns of delimited data. Paste the text or drop the file; nothing leaves the page either way.

When would I actually use this?

Making a machine-generated blob readable, finding the character where a parse fails, and shrinking a file before it ships.

What is the most common mistake?

Assuming valid means correct. A document can parse cleanly and still have the wrong shape for whatever will read it — validation checks the syntax, not the schema.

How is CSV transpose different from CSV to JSON converter?

They sit next to each other but answer different questions: CSV to JSON converter is the one to open when you need it to parse CSV text (with header row) into a JSON array of objects, handling quoted fields. Drop a file in rather than pasting it — it is read in your browser and never uploaded. Pick whichever matches what you're starting from — both are free.

Is there a tool for the next step?

CSV to Markdown table is the closest one after this: Turn CSV into a Markdown table, quoting and all: a field may hold the delimiter, a line break or a pipe and the table still lines up. Comma, semicolon (French Excel), tab or pipe, detected or forced.

Where do the figures come from?

Parsing and serialisation follow each format's specification. Key order and whitespace are not semantically meaningful in JSON or YAML, so a reformatted document is equivalent even when the bytes differ.

Further reading

All guides →
GuideTransposing a Table Whose Rows Should Have Been ColumnsWhat happens to the header row, what happens to rows of unequal length, what happens to types — and the one thing transposing is regularly mistaken for and cannot do.ExplainerCSV to JSON: The Five Cases That Break Every ConverterQuoted delimiters, embedded newlines, ambiguous types, duplicate headers and encoding. Each one was run through the converter and the exact output is printed here — including the two cases it does not rescue.GuideBeautify or Minify: What Each Is For, and What It Does to the WeightFour real stylesheets run through the minifier, measured raw and after gzip. Stripping every space saved 48, 103, 104 and 147 compressed bytes; stripping comments saved 57, 1 358, 2 420 and 1 042. Plus the five inputs this minifier breaks.ExplainerJSON to CSV When the Structure Is Nested: Why There Is No Right AnswerThe same two orders come out as five columns from one converter and ten from another, and neither is wrong. Dotted paths, arrays of scalars, arrays of objects and records with different keys — four decisions, made for you, usually silently.How-toHow to Convert JSON to CSV: Flattening Arrays of Objects into Rows and ColumnsA practical guide to turning a JSON array of objects into a clean CSV file, including how to flatten nested fields and handle the tricky edge cases.How-toBuilding a Markdown Table From Scratch, Without Counting Dashes by HandThe smallest thing that is still a table is two lines: a header row and a delimiter row. Here is why the second one is mandatory in GitHub Flavored Markdown, where pipe tables do not exist at all, and what a generator does that hand-typing cannot.