Free tool

Reorder CSV columns

Reorder CSV columns by listing the ones to keep in the order you want, like 3, 1, 2 or 2-4. Any column you leave out is removed.

The example is loaded. Paste your own list to replace it.

1
Reorder or remove columns

→ 2 lines

Columns are separated by

Columns to keep, in order

Your text

2 lines

Result

2 lines

What it does

Keep the columns you list, in that order (for example 3, 1, 2).

Settings you can change

  • Columns are separated by: Comma ,, Tab, Semicolon ;, Pipe |, Other (type it)
  • Other separator
  • Columns to keep, in order

When to use it

An import needs the columns in the order email, name, and nothing else.

Example: reorder CSV columns

Settings used: Columns to keep, in order: 3, 1.

Input

Result

Often used with

Keep one column of CSV or tab-separated rows.

Turn CSV into tab-separated text (for pasting into a spreadsheet), or the other way round.

Turn rows into JSON objects, using the first row as the names.

All free tools

Your text stays on this computer
The list editor works on your computer. The text you paste or open is not uploaded or stored by HeyScraper, and closing the page clears it. Saved recipes are kept in this browser only.

Got your list from a web page?

HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.

Get HeyScraper