File tools · CSV

Extract, reorder and rename CSV columns.

Keep only the columns an importer needs, put them in the order it expects and give them the exact header names it wants. The preview updates as you click.

Tick, rename, move: each column has a checkbox, an editable output name and up and down buttons. The same column can only be used once; the file never leaves your browser.

What you can do with the column list

Once a file is loaded, every column appears as a row: a checkbox to keep it, its original position and name, a text box holding the output name, and arrows to move it up or down. The output file contains the ticked columns in the order shown, with the header you typed. Renaming only changes the header line; the data underneath is untouched. Untick empty columns scans the data and clears the tick on every column whose cells are all blank, which is the quick way to drop the unused columns that spreadsheet exports are full of.

If the file has no header row, untick the header option: columns are then called Column 1, Column 2 and so on, the output has no header line, and your names are not used.

Your file stays on your device

Choosing, renaming and reordering happen on an in-memory copy of the file in this tab. The frame is sandboxed with no network access and the advertising on the page is outside it. That is useful when the file is a full customer or payroll export and you only want to pass a few columns on.

Worked example

A store export has the columns id, first, last, email, phone, notes, created and an email tool wants Email, First Name, Last Name. Untick everything, tick email, first and last, rename them to the three names above, and move them into that order. The output header is Email,First Name,Last Name and each row carries the matching three cells. A row that was shorter than the header, with no phone or later cells, gets blanks rather than shifting the columns left.

Details that matter

Duplicate output names are allowed, because some importers need them, but the page warns you since most do not. Trimming applies to every cell of the output after the columns are chosen, so it can be used on its own by leaving all columns ticked. Blank-row removal ignores the header row and counts a row as blank when every cell is empty or only spaces. Rows keep their original order; to change it use the CSV sorter.

Awkward files

Real exports are rarely tidy. If a row is longer than the header, the extra cells get generated names (Column 6, Column 7) so you can keep or drop them like any other column. If a header cell is blank it is called Column N rather than left empty, and if two headers match, the second is shown as, for example, email (2), so every column can be told apart in the list. Quoted cells that contain commas, quotes or line breaks are read as single cells and written back with the quotes they need. A 100,000-row, 10-column file loads and previews in a couple of seconds in a current desktop browser; the list scrolls once there are many columns.

Common mistakes

What this tool does not do

It does not compute new columns, split one column into two, merge two columns into one, filter rows by value or change formats. It cannot select a column by a regular expression. For removing repeated records, use the duplicate-row remover.

Frequently asked questions

How do I keep only some columns of a CSV?

Load the file, press Untick all, tick the columns you want and download. The preview shows exactly what the output will contain.

How do I change the column order?

Use the up and down arrows next to a column, or the Reverse order and Sort A to Z buttons. The output follows the order shown in the list.

Can I rename columns?

Yes. Edit the text box next to a column; only the header line of the output changes. If the file has no header, names are not used.

Is the file uploaded?

No. It is read and rewritten in your browser tab. The tool runs in a frame without network access.

What happens to short rows?

A row with fewer cells than a chosen column gets an empty cell there, so values never shift into the wrong column.

Can I use the same column twice?

Each source column appears once in the list. If you need a copy, keep it and rename the other; the tool does not duplicate columns.

Does trimming change my data?

Only if you tick it: spaces at the start and end of every output cell are removed. Spaces inside a value are left alone.

Sources

Check the header names

Importers are strict about header text. Compare the output header with the importer’s template before you upload the file there.

Advertisement
Advertisement