Exports from shops, CRMs and bank portals often have dozens of columns when you need four. Import screens, on the other hand, can be strict about which columns they accept and in what order. This tool keeps only the columns you name, in the order you name them.
How do I choose the columns?
Type the column names, exactly as they appear in the header row, separated by commas. email,first_name,last_name gives you a file with those three columns in that order, whatever order they had before. Every other column is dropped.
Names must match the header, including capitals and spaces; spaces around the commas you type are ignored. Names that do not exist in the file are skipped. If none of them match, the tool tells you which columns it found, so you can copy the right names.
Can I rename columns at the same time?
No. The header keeps its original names. If an import needs different names, edit the first line of the result in a text editor, which is quick since it is only one line.
Does it change the data?
No. Every row is kept, and every value in the columns you keep is copied as it is. Nothing is converted, trimmed or re-formatted.
Which files work?
CSV and TSV files with a header row. The separator is detected from the start of the file: commas, semicolons, tabs and pipes all work, and the result uses the same separator as the original. UTF-8 files are read correctly, including those Excel saves with a byte order mark.
What happens to my upload?
The tool runs on our server. Your file is uploaded over an encrypted connection, processed in Germany and deleted automatically within two hours. That is worth knowing for customer lists: dropping the columns you do not need, such as phone numbers or addresses, before you pass a file on is also a simple way to share less personal data.
How big can the file be?
Files up to 50 MB are free without an account, within a daily allowance of 20 server jobs; Pro takes 500 MB. When the same export arrives every week, save the column list as a preset in the pipeline builder and run it on each new file. You can try pipelines on up to 3 files for free.
How to select CSV columns
- Drop your .csv or .tsv file onto the drop zone.
- Type the columns to keep, in the order you want, separated by commas.
- Click Apply.
- Download the new CSV.
FAQ
How do I see the column names?
Open the CSV in a text editor; the first line lists them. Or submit a guess, and the error message lists the columns found.
Can I just reorder without dropping anything?
Yes. List every column in the new order.
Can I filter rows too?
Yes, with Filter CSV, before or after selecting columns.
Does it work on Excel files?
Convert them with Excel to CSV first.