Sometimes the data comes in the wrong orientation: one row per month with metrics as columns when the chart tool needs one column per month, or a wide questionnaire that should be a tall list. Transposing swaps rows and columns, so the first row becomes the first column and vice versa, exactly like Paste Special > Transpose in Excel but without opening a spreadsheet.
Paste the CSV, click Transpose and copy the result. The operation runs in your browser and nothing is sent anywhere.
How to use Transpose CSV step by step
Paste the comma-separated CSV into the left box.
Click "Transpose". The rows become columns in the result box on the right.
Click "Copy" to place the transposed CSV on the clipboard.
Input and output example
Input
month,sales,costs
Jan,100,60
Feb,120,70
Output
month,Jan,Feb
sales,100,120
costs,60,70
Why use our Transpose CSV?
100% free and online: no payments, no software or extensions to install.
Privacy-first: processing happens in your browser, your data never leaves your device.
No sign-up: paste your data and get the result in one click.
Fast and reliable: handle small or large files in seconds, ready for Excel and other tools.
Common use cases
Turn a time series with dates as columns into rows so it can be plotted in Google Sheets or Data Studio.
Convert a wide comparison table (one product per column) into a tall list for a database import.
Reorient survey results where each respondent is a column into one row per respondent.
Swap axes of a small matrix before pasting it into a Markdown or LaTeX table.
Limits and tips
Cells are split on commas only; quoted values containing commas will be broken into extra cells and shift the matrix.
The number of columns is taken from the first row. Rows that are shorter produce empty cells, and extra cells in longer rows are dropped.
The output is not quoted, so if any cell contains a comma the result will not be a valid CSV.
Line endings in the result are LF; Excel on Windows still opens the file correctly.
Frequently asked questions
What does transposing a CSV mean?
Transposing swaps the two axes of a table: the value at row i, column j moves to row j, column i. The first row of the original becomes the first column of the result, so headers along the top become labels down the side.
How is this different from Excel's Transpose?
The result is the same as Paste Special > Transpose in Excel or Google Sheets, but no spreadsheet is needed and the values are not reinterpreted: 08001 stays 08001 and 1/2 stays 1/2, which Excel would convert to a number and a date.
Can I transpose a file with thousands of rows?
Yes, as long as your browser has memory for it. The result will have as many columns as the input had rows, which some spreadsheets cannot open beyond 16,384 columns.
Why are some cells missing after transposing?
The tool assumes every row has the same number of cells as the first one. If a row is longer, its extra values are discarded; if it is shorter, empty cells appear. Make the rows uniform before transposing.
Is the data uploaded?
No. The transposition is computed by JavaScript in your browser tab and the result stays there until you copy it.
Related tools
Other free utilities you may find useful
CSV Viewer and Editor — Open, search, sort and edit CSV files in a table; export to CSV, Excel or JSON.
Large CSV File Viewer — Open and browse CSV files too big for Excel, even several gigabytes.
Large Sample CSV Files — Download sample CSV files with 1,000 to 5 million rows of realistic data, generated in your browser.
Merge CSV Files — Combine several CSV or Excel files into one, matching columns by name.
Remove Duplicates from CSV — Delete duplicate rows from a CSV, comparing whole rows or selected columns.