PapiralPapiralPixelForgePixelForgeTabularTabular
TabularTabular
HomeCSV ToolsTranspose

Transpose CSV — Flip Rows and Columns

Rotate your data 90°: rows become columns and columns become rows. Instantly reshape wide data into tall format or vice versa.

Pro feature

Upgrade to Pro to use the Transpose tool and process files up to 50 MB.

See Pro plans

What this tool does

Sometimes your data arrives sideways — metrics as rows when you need them as columns, or time periods as columns when you need them as rows. Transposing fixes that instantly. Tabular rotates your entire table, and optionally uses the first column as the new column headers — ideal for pivoting summary exports from reporting tools.

Problems it solves

  • Pivoting a wide report from a BI tool into tall format
  • Rotating metrics-as-rows into metrics-as-columns
  • Converting time-series column headers into row values
  • Reshaping data for import into a tool that expects a different orientation
  • Fixing copy-pasted data from a transposed source

Example

Rows and columns rotated 90°. Original headers become the first row of data.

Before

MetricJanFebMar
Revenue10001200900
Users506055

After

Col1Col2Col3
MetricRevenueUsers
Jan100050
Feb120060
Mar90055

Frequently asked questions

What happens to the original column headers?

By default, the original headers become the first row of data and new generic headers (Col1, Col2, ...) are assigned. Enable 'Use first column as headers' if your first column contains your desired new header names.

Is this a Pro feature?

Yes. Transpose is available on Pro and Business plans.

Will my data download as CSV or XLSX?

The output format is whatever you selected for your job — CSV by default, or XLSX if you converted format.

Is there a row or column limit?

Transpose works within your plan's file size limit. Very wide tables (thousands of columns) will transpose into very tall tables, which is fine as long as the total data fits within your limit.

Related guide

How to Transpose a CSV File (Flip Rows and Columns)

3 methods — browser tool, Excel, and Python

Related tools

Reorder Columns

Pro

Choose which columns to keep and in what order. Drop unwanted fields and reorder the rest before your import.

Open tool

Sort Rows

Sort your CSV or Excel file by any column — alphabetically or numerically, ascending or descending.

Open tool

Filter Rows

Pro

Keep only the rows that match your criteria — filter by column value, text match, or emptiness. No formulas needed.

Open tool