Transpose TSV Files Online
Transpose TSV files — flip rows and columns — directly in your browser. No upload, no server.
How to transpose TSV files
- Drop your file onto the upload area. The tool shows the row and column count and previews the first 200 rows.
- Check the notice above the preview. Files with more than 500 rows are transposed using only the first 500 rows.
- Click Transpose. Each original column becomes a row, and the counts update to show the new shape.
- Review the transposed table, then click Download CSV. The result is always saved as a CSV file named after your input with _transposed added.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A web team keeps quarterly visit totals with one row per region. A slide template needs the quarters running down the page and the regions across the top.
Input (TSV)
region q1_visits q2_visits q3_visits
North 1840 2105 1990
South 960 1130
West 2410 2290 2675Settings
- No options. The first 500 rows are transposed (this file has 3).
Result
| Field | Row_1 | Row_2 | Row_3 |
|---|---|---|---|
| region | North | South | West |
| q1_visits | 1840 | 960 | 2410 |
| q2_visits | 2105 | 1130 | 2290 |
| q3_visits | 1990 | 2675 |
Three rows and four columns become four rows and four columns. The old header names move into a new first column called Field. The new headers are Row_1, Row_2 and Row_3, not the region names. Every value is written as text, and the missing Q3 figure for South becomes an empty cell.
Frequently Asked Questions
What do the column headers look like after transposing?
The first column is called Field and holds your original column names. The other columns are named Row_1, Row_2 and so on, one per original row. The values in your first column do not become headers.
Is there a row limit?
Yes. Only the first 500 rows are transposed, which gives at most 501 output columns. The tool warns you before you click Transpose if your file has more rows than that.
What format is the transposed file saved in?
Always CSV, whatever format you uploaded. All values are written as text and empty values become empty cells.
Related Tools
Rename Columns in CSV Files Online
Rename columns in CSV files instantly in your browser. No upload, no server — your data stays on your device.
Unpivot CSV Files Online
Reshape CSV files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
Manage Columns in CSV Files Online
Drop or select specific columns from CSV files directly in your browser. No upload required.
Transpose CSV Files Online
Transpose CSV files — flip rows and columns — directly in your browser. No upload, no server.
Transpose Excel Files Online
Transpose Excel files — flip rows and columns — directly in your browser. No upload, no server.
Transpose Parquet Files Online
Transpose Parquet files — flip rows and columns — directly in your browser. No upload, no server.
Transpose JSON Files Online
Transpose JSON files — flip rows and columns — directly in your browser. No upload, no server.
TSV Viewer Online
View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.