CSV Transposer
Swap CSV rows and columns and download the result
CSV Transposer — what it does
Swap rows and columns so the first column becomes the header row and each original row becomes a column. Transposing is the fix for data that arrived in the wrong orientation — metrics running across the page instead of down it — which no amount of filtering or sorting can correct.
When this tool helps
- Reorienting a report where each month is a column and each metric is a row, into one row per month.
- Converting a wide survey export into the tall format most analysis and charting tools expect.
- Turning a single-record vertical listing of field names and values into a normal tabular row.
How to use it
- Choose the CSV file.
- Press transpose.
- Check that the new header row reads correctly.
- Download the transposed CSV.
Accuracy, limits, and good practice
- The first column becomes your header, so make sure its values are unique — repeated labels create duplicate headers downstream.
- Transposing a file with many rows produces a file with many columns, which spreadsheets handle badly beyond a few hundred.
- Mixed data types end up sharing a column after transposition, so a column may hold both dates and amounts. Check before aggregating.
Frequently asked questions
Is transposing reversible?
Yes. Transposing the result again returns the original layout, apart from any header renaming the first pass introduced.
Do blank cells cause problems?
No, they transpose as blanks. Rows of differing length are padded so the resulting grid stays rectangular.
Why does my data look wrong afterwards?
Usually the source had no meaningful first column to serve as headers. Add a label column before transposing.
Related tools on this site
- Excel Row Sorter — Sort worksheet rows by a selected column
- JSON Key Renamer — Rename matching object keys recursively throughout JSON data
- CSV Duplicate Remover — Remove duplicate rows using a selected key column
Everything above runs inside this page. CSV Transposer needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 行列互換能做什麼
交換列與欄，讓第一欄變成標題列，原本的每一列變成一欄。當資料的方向本來就錯了——指標橫著排而不是直著排——再多的篩選或排序都救不回來，行列互換才是解法。
什麼時候用得上
- 把「每月一欄、每個指標一列」的報表，轉成每月一列的格式。
- 把寬式問卷匯出檔轉成多數分析與繪圖工具偏好的長式格式。
- 把單筆紀錄的直式欄名與值清單，轉回正常的表格列。
使用步驟
- 選擇 CSV 檔案。
- 按下行列互換。
- 確認新的標題列是否正確。
- 下載互換後的 CSV。
精確度、限制與實務建議
- 第一欄會變成標題，請確認其值唯一；重複的標籤會在下游造成重複標題。
- 列數很多的檔案轉換後會變成欄數很多，超過數百欄時試算表的處理體驗會很差。
- 互換後不同型別的資料可能落在同一欄，例如日期與金額混在一起，彙總前請先確認。
常見問題
行列互換可以還原嗎？
可以，再互換一次即回到原本配置，只有第一次造成的標題改寫需自行還原。
空白儲存格會有問題嗎？
不會，空白照樣互換；長度不一的列會補齊，確保結果維持矩形結構。
為什麼互換後資料看起來怪怪的？
通常是原始檔案的第一欄不適合當標題。請先加上一欄標籤再互換。
本站相關工具
- Excel 資料列排序 — 依指定欄位排序工作表資料列
- JSON 鍵名批量重新命名 — 在整份 JSON 中遞迴重新命名符合的物件鍵名
- CSV 重複資料移除 — 依指定欄位移除重複資料列
以上步驟全部在這個頁面內完成，CSV 行列互換 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。