Neatbo.

Transpose CSV

Swap rows and columns in a rectangular delimited table.

Browser-local processingInputCSVOutputCSVUp to 10 MiB per file · File limit: 1
  1. 1Add input
  2. 2Adjust settings
  3. 3Get your result

Tool input and files are processed in this browser without being uploaded.

Your input

Inputs are kept temporarily in this tab when switching tools. Refreshing or closing clears them; large results may need to be regenerated.

⌘ / Ctrl + Enter to run
Delimited text source
0 characters · 0 bytes

Read the source table

Choose the delimiter used in your input. The download uses comma-separated CSV.

Preparing the tool…

Before you start

Turn each row into a column without assuming a header row. Paste text or choose a UTF-8 file, select its delimiter, preview the shape and download the full CSV.

How to use this tool

  1. Paste a rectangular table or choose one UTF-8 file.
  2. Select the input delimiter, then choose Transpose CSV.
  3. Check the input and output dimensions and the preview; copy or download the complete CSV.

Supported inputs and limits

Paste up to 1 MiB or use one UTF-8 CSV, TSV or TXT file up to 10 MiB; at most 200,000 cells.

Every row must have the same number of columns. Empty and repeated values in the first row are allowed.

Processing happens in this browser; possible spreadsheet formulas are preserved as text.

Worked example

Example input

name,age
Mori,3
Aya,2
Example options
{"delimiter":","}

Example output

name,Mori,Aya
age,3,2

When something does not work

Paste up to 1 MiB or use one UTF-8 CSV, TSV or TXT file up to 10 MiB; at most 200,000 cells. Every row must have the same number of columns. Empty and repeated values in the first row are allowed.

Frequently asked questions

Does the first row have to be a header?

No. Every row is treated as data. Empty and repeated cells in the first row are valid.

Does this pivot or group data?

No. It only swaps row and column positions. It does not aggregate, group by a key, or infer headers.

Which delimiters are supported?

Input can use commas, semicolons, tabs or pipes. Output is comma-separated CSV with quoted cells where needed.

Is my table uploaded?

No. Conversion runs in your browser. Save the result before closing the tab.

Documentation & further reading

Related tools