HandyjarFind a tool

Developer tools

CSV Transpose

Swap rows and columns. Keep every value.

Turn each input column into an output row, without converting text to numbers.

Processed in your browser

Paste CSV, or open a UTF-8 file.

Enable JavaScript to transpose CSV.

First row and first column are ordinary data and always included. Blank or duplicate header-like values keep their positions.

Options

Auto-detect tries these four delimiters. Check the input preview and choose explicitly if needed.

Padding makes a rectangular result. Original empty fields and newly padded cells are identical in the output.

Off preserves values. Enabling this changes matching cells, including negative numbers; the export reports how many. Spreadsheet applications may interpret formulas when opened.

How it works

  1. Add your data

    Paste CSV or open a UTF-8 file. Choose its delimiter and how to handle missing cells.

  2. Transpose

    Swap rows and columns, then compare the input and transposed previews.

  3. Save your result

    Choose an output delimiter, then copy or download the complete result.

Good to know

Values and formatting

Quoted commas, quotes, Unicode and embedded newlines are preserved as field text. Output quotes every field, uses CRLF record separators and writes UTF-8 without a BOM. A final record terminator does not create an extra row. Text pasted into the editor follows the browser’s LF convention; use a file to preserve embedded CRLF.

Browser resources

There is no fixed input size limit. The input and transposed table must fit browser memory. Processing runs in your browser; Cancel stops processing and clears its result while retaining your input. Reset clears input too. Previews show windows of rows and columns; exports include all cells.

Frequently asked questions

What happens to headers?

All records are data. The first row becomes the first column, and the first column becomes the first row. Headers are never renamed or deduplicated.

What if some rows are shorter?

The default pads their missing fields with empty strings and reports the count. Require equal field counts instead to stop with an error before producing output.

Does transposing twice restore my input?

For rectangular data, transposing twice restores the field values and their positions. CSV quoting, delimiters and record separators may differ. Padding and optional apostrophe prefixes change values and are not automatically undone.

Are files sent anywhere?

CSV processing happens in your browser. This tool does not upload or store your input. Copy explicitly writes the output to your clipboard, and Save writes a file to your chosen destination.

CSV Viewer JSON to Table