Transpose

Transpose Table

Flip a table on its side — useful when data arrives with dates across the top instead of down the side. Paste cells or upload a file, check the transposed preview and download it. Everything is processed in your browser; your data is not uploaded.

Back

1. Table

Local only

Processed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.

2. Transposed table

Live preview

CSV downloads use safe export by default: cells starting with =, +, -, @, a tab or a carriage return get a leading apostrophe so spreadsheet apps treat them as text.

Transpose is limited to 250,000 cells (for example 500 rows × 500 columns) so the page stays responsive.

About this tool

About Transpose Table

Transpose Table swaps the rows and columns of a CSV, TSV or pasted table, so the first row becomes the first column. Uneven rows are filled with blank cells, the original and new dimensions are shown, and the result downloads as CSV or TSV.

Data sometimes arrives sideways — months across the top, items down the side — when a tool expects the opposite. Transposing in a spreadsheet can be awkward for pasted text or large tables. This tool handles quoted cells and Unicode correctly and stops with a clear message if a table is too big.

How to use

Step by step

  1. Upload a file or paste the table (cells copied from a spreadsheet work).
  2. Check the detected delimiter.
  3. Review the original and transposed dimensions and preview.
  4. Choose CSV or TSV and safe or raw export.
  5. Download the transposed table.
Key features

What it offers

  • Rows become columns and columns become rows
  • Uneven rows filled with blanks safely
  • Original and transposed dimensions shown
  • CSV, semicolon CSV or TSV download
  • Quoted cells, Hindi and emoji preserved
  • 250,000-cell limit with a clear message
Best practices

Tips for best results

  • Paste directly from a spreadsheet for quick conversions.
  • Check the dimensions before downloading.
  • Use TSV when values contain many commas.
  • Transpose before other cleaning steps if headers are in the first column.
Benefits

Why people use it

Quick

Flip a table in one step.

Exact

Every value keeps its text, including quotes and line breaks.

Private

Processed on your device only.

FAQ

Common questions

Row 1 becomes column 1, row 2 becomes column 2, and so on. A table with 3 rows and 5 columns becomes a table with 5 rows and 3 columns. The header row is transposed like any other row.
Shorter rows are filled with blank cells so every column has the same length; the page tells you how many rows were filled. No value is moved into the wrong position.
Yes. Cells with commas, quotes or line breaks, and text in any language, including Hindi and emoji, are kept exactly and quoted correctly again in the download.
Yes. Choose CSV (comma), CSV (semicolon) or TSV (tab) as the output format.
Yes, 250,000 cells. Larger tables show a clear message instead of freezing the page.
Safe export (on by default) adds an apostrophe in front of any cell that starts with =, +, -, @, a tab or a carriage return, so Excel, LibreOffice and Google Sheets show it as text instead of running it as a formula. This includes values such as -5. Choose raw export only for files read by programs; the preview always shows exactly what will be downloaded.
No. The table is transposed in your browser and nothing is stored.
Private by design

This runs entirely in your browser

No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.

Install Toolisco Add it to your device for offline, one-tap access.