← All text tools

Transpose Rows and Columns of Text

Flips pasted rows and columns of text so lines become columns, with tab, comma, semicolon, pipe or space delimiters and a warning for uneven rows.

  • Free
  • No sign-up
  • Works on any device

About Transpose Rows and Columns of Text

Transposing swaps rows and columns: the first line becomes the first column, the second line the second column, and so on. Paste a table copied from a spreadsheet, a CSV, or any text where cells are split by tabs, commas, semicolons, pipes or spaces, and the tool detects the separator or uses the one you pick. It reads quoted cells, tolerates uneven rows by filling blanks and names the rows whose length differs, so you can spot a missing value.

How to use Transpose Rows and Columns of Text

  1. Paste the table or the lines of text.
  2. Choose the separator in your text, or leave it on automatic, and the separator for the result.
  3. Copy the transposed text or download it.

Why use this tool?

Also known as

Frequently asked questions

What happens when rows have different lengths?

Missing cells are left empty in the result, and the rows with a different count are listed so you can check them.

Can it read quoted CSV cells with commas inside?

Yes, when the quote option is on. A cell wrapped in double quotes can contain the separator, and quotes are added again in the output where needed.

Does it work with spreadsheets?

Copy cells from a spreadsheet and paste them in. They arrive tab separated, which the automatic detection recognises.

Is Transpose Rows and Columns of Text free?

Yes. Transpose Rows and Columns of Text on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put Transpose Rows and Columns of Text on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools