CSV Tools

Transpose CSV

Swap rows and columns in your CSV

CSV Input

Try a sample:

CSV Output

Paste or upload CSV input above to see the transposed result...

More Options

CSV Format

Input

Note: transpose treats every row identically, so there's no separate "header row" toggle. If your input has headers in the first row, those values will appear as the first column of the output.

How to Use This Tool

This tool transposes a CSV — it swaps rows and columns. A 4×10 CSV becomes a 10×4 CSV. Useful for restructuring metric tables, pivoting wide-format data into long-format inputs for other tools, and quickly changing the orientation of small lookup tables.

  1. Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab.
  2. Review the output — The transposed CSV renders instantly. If your input had ragged rows, a warning shows how many rows were padded.
  3. Download — Copy the result to your clipboard or save it as a .csv file.

FAQ

3 questions
Does this tool upload my data?
No. Transposition runs entirely in your browser using JavaScript. Your CSV data is never sent to a server.
What happens to the header row?
Transpose treats every row identically — it's a pure matrix flip. If your input has headers in the first row, those values become the first column of the output.
What if my rows have different numbers of columns?
Short rows are padded with empty cells to match the longest row before transposing. The output panel shows a warning telling you how many rows were padded.

More Transform Data Tools

2 tools

One-Hot Encode Column

Convert categorical values into binary columns

Extract Date Parts

Pull year, month, day, and more from date columns

More CSV Tools

92 tools

Add Header Row

Add a header row to a CSV that doesn't have one

Anonymize Columns

Replace sensitive column values with fake data

Compare Files

Compare two CSV files and highlight the differences

Column Counter

Count the number of columns in your CSV

CSV to Excel

Export CSV data to .xlsx spreadsheets

CSV Viewer

View and explore CSV files in a sortable table

CSV to YNAB

Convert CSV bank statements into YNAB-compatible import format

Extract Email Addresses

Find and extract all email addresses from your text or CSV

Filter Rows

Keep only rows that match your criteria

Merge CSVs

Combine multiple CSV files into one

Remove Columns

Delete one or more columns from your CSV

Column Stats

Get data type, null count, unique count, and common values per column

CSV to Xero

Convert CSV bank statements into Xero-compatible import format

Excel to CSV

Import .xlsx files and convert to CSV

Extract Columns

Keep only the columns you need from your CSV

Extract Phone Numbers

Find and extract all phone numbers from your text or CSV

Find Missing Rows

Find rows in one file that are missing from another

Redact Columns

Mask or remove sensitive values from selected columns

Remove Header Row

Remove the header row from your CSV

Sort CSV

Sort rows by any column, ascending or descending

Split CSV

Break large CSVs into smaller chunks

Change Header Case

Switch headers between camelCase, snake_case, kebab-case, and more

Calculate Dimensions

Get the row count, column count, and size of your CSV

CSV to JSON

Convert CSV files to clean, structured JSON

CSV to QBO

Convert CSV bank transactions into QuickBooks format

Extract URLs

Find and extract all URLs from your text or CSV

Find Common Rows

Find rows that appear in both CSV files

Remove Duplicates

Find and eliminate duplicate rows

Rename Columns

Change the header names of your CSV columns

Split by Column Value

Split a CSV into multiple files based on column values

JSON to CSV

Convert JSON arrays to downloadable CSV

QBO to CSV

Convert QuickBooks QBO files into CSV format

Remove Empty Rows

Delete rows that are completely empty

Reorder Columns

Rearrange the column order in your CSV

Row Counter

Quick count of rows, columns, and empty cells

Sample Rows

Pick a random sample of rows from your CSV

Add Column

Add a new column with a default value to your CSV

Count Values

Count the number of non-empty values in each column

CSV to QFX

Convert CSV bank transactions into Quicken format

CSV to XML

Transform CSV into well-formed XML documents

Fill Missing Values

Replace empty cells with a default value

First N Rows

Extract the first N rows from your CSV

Find and Replace

Search for values in your CSV and replace them

Last N Rows

Extract the last N rows from your CSV

One-Hot Encode Column

Convert categorical values into binary columns

QFX to CSV

Convert Quicken QFX files into CSV format

Summary Statistics

Get count, mean, min, max, and percentiles for numeric columns

XML to CSV

Convert XML data with repeating elements into CSV

CSV to OFX

Convert CSV financial data into Open Financial Exchange format

CSV to TSV

Convert comma-separated values to tab-separated format

Extract Date Parts

Pull year, month, day, and more from date columns

Slice Rows

Extract a range of rows by start and end position

Split Column

Split one column into two columns by a delimiter

Sum Column

Calculate the total of all values in each numeric column

Trim Whitespace

Remove leading and trailing spaces from all cells

Add Row Numbers

Add a sequential row number column to your CSV

Average Column

Calculate the average of all values in each numeric column

Merge Columns

Combine two columns into one using coalesce logic

OFX to CSV

Convert OFX financial files into CSV format

Remove HTML Tags

Strip HTML tags from cell values in your CSV

TSV to CSV

Convert tab-separated data into comma-separated CSV

Count Unique

Count the number of distinct values in each column

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to QIF

Convert CSV financial data into Quicken Interchange Format

Map Column Values

Replace column values using a visual mapping table

Remove Comments

Remove comment lines from your CSV

Reverse Rows

Reverse the order of rows in your CSV

HTML to CSV

Extract table data from HTML and convert to CSV

QIF to CSV

Convert Quicken QIF files into CSV format

Remove Whitespace

Strip all unnecessary whitespace from your CSV

Running Total

Add a cumulative sum column to your CSV

Shuffle Rows

Randomly reorder all rows in your CSV

Uppercase Column

Convert all values in a column to uppercase

Compress CSV

Minify your CSV by removing unnecessary whitespace and formatting

CSV to YAML

Transform CSV data into clean, readable YAML documents

Lowercase Column

Convert all values in a column to lowercase

Percentage of Total

Add a column showing each row's share of the total

CSV Validator

Check your CSV for formatting errors and structural issues

Rolling Average

Calculate a moving average over a sliding window of rows

Swap Column Data

Swap the data between two columns in your CSV

YAML to CSV

Convert YAML lists into CSV format

CSV to Markdown

Convert CSV data into GitHub-flavored Markdown tables

Duplicate Column

Create a copy of an existing column

Markdown to CSV

Convert Markdown tables into CSV format

CSV to JSON Lines

Convert CSV rows into newline-delimited JSON (JSONL/NDJSON)

JSON Lines to CSV

Convert JSONL/NDJSON data into CSV format

CSV to SQL

Generate SQL INSERT statements from CSV data

CSV to Fixed Width

Convert CSV data into fixed-width column format

Fixed Width to CSV

Convert fixed-width column data into CSV format

CSV to LaTeX

Generate LaTeX table markup from CSV data

Parquet to CSV

Convert Apache Parquet files to CSV format

Feather to CSV

Convert Apache Feather/Arrow files to CSV format