Tool 03 · Transpose

Transpose CSV Online

=TRANSPOSE()

Paste or open your data and rows become columns straight away.

Step 01

Your table

100% in-browser

Revision Q&A

(click a question) Lab module 03
Q1: What does transpose mean? expand_more

Transposing swaps rows and columns: the first row becomes the first column, and so on. It is useful when data arrives sideways.

Q2: How do I transpose in Excel? expand_more

Use =TRANSPOSE(A1:D10) in an empty cell and the result spills into place. Without a formula, copy the range and use Paste Special, then tick Transpose.

Q3: Does it work with CSV and Excel files? expand_more

Yes. Paste CSV or tab-separated data, or open a .csv or .xlsx file. Download the result as CSV or Excel.

Know someone fighting with a spreadsheet? Send them this page.