CSV transpose
Swap the rows and columns of a CSV table, including its heading row.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
How to use this tool
- Paste the complete table.
- Run to make each original column an output row.
- Shorter rows are padded with empty cells before transposing.
Things to know
- Processing happens on your device. Check the result before replacing your original data.
- Each CSV input accepts up to 25 MiB, 100,000 data rows, 10,000 columns and 1,000,000 cells. Expanded tables also count empty cells.
- Generated CSV text is limited to 25 MiB in total, including all split files.
You might also need
More in data & csvCSV row filter
Keep CSV records matching text or numeric conditions in a selected column.
CSV merger
Combine two CSV tables, aligning columns by their headings.
CSV viewer and editor
Inspect CSV as a table and edit an individual cell by row and column.
CSV joiner
Join two CSV tables on a shared key using inner or left joins.
CSV splitter
Split CSV data into smaller files while repeating the original headings.
CSV sorter
Sort CSV records by a named column while retaining all row values.
CSV column organiser
Select, reorder and rename CSV columns.
JSON to TypeScript types
Infer TypeScript types from a JSON example, including nested arrays and objects.
CSV deduplicator
Remove duplicate CSV records using all columns or selected key columns.