CSV column selector

Keep only the columns you need

Exports usually contain far more than you need: dozens of columns when you want three, internal identifiers, empty fields, columns full of personal data that should not be shared. Before you send a file to a colleague, upload it to a system or load it into a tool, it is often better to trim it down. Doing it in a spreadsheet means opening the file, deleting columns one by one and hoping nothing gets reformatted. This tool makes it a matter of ticking boxes.

What you can do

• Choose columns. Every column of the file is listed with a checkbox. Untick the ones to leave out, or use select none and tick only the few you want.
• Reorder them. Use the arrows to move a column up or down so the result matches the order the receiving system expects.
• Rename them. Edit the name of any column. That is handy when an import needs specific header names.
• Preview. The first rows of the result are shown as you make changes.

Sharing less data

Removing columns is one of the simplest ways to protect personal data. If a colleague only needs order numbers and totals, they do not need names, addresses or phone numbers. Choose only the columns required and share the smaller file.

What stays the same

Cell values are copied exactly as they are, so numbers, dates and leading zeros are not reformatted. That is not guaranteed when a file is opened and saved in a spreadsheet, which may turn a code like 00123 into 123. The output is UTF-8 with a marker that helps Excel display accents correctly, and you can change the separator.

Limits

The tool works on whole columns. It does not filter rows, merge or split columns or calculate new ones. Files of up to 60 MB are accepted and everything is processed in your browser. To clean spaces and duplicates afterward, use the CSV cleaner.