Edit CSV Columns

Import templates are strict. A mailing tool wants Email first, a shop system expects columns named sku, title and price, and an accounting program refuses files with extra columns. Exports from other systems rarely match. This tool lets you keep only the columns you need, rename them and put them in the right order, with a preview of the result before you download it.

Loading the data

Drop a CSV, TSV, TXT or Excel file, or paste cells copied from a spreadsheet. The separator and text encoding are detected automatically and can be changed under the file name. For workbooks with several sheets, choose the sheet to edit.

Keeping or removing columns

Every column appears as a row in the list with a switch. Switch off the ones you do not need: internal notes, personal data you should not share, helper columns from a previous step. Removed columns are greyed out and disappear from the preview at once. The panel title counts how many columns are kept.

Renaming headers

Type a new name into any column’s field. This is how you match the names an importer expects exactly, translate headers, or turn cryptic names like cust_eml_addr into Email. If your file has no header row, switch off “First row is a header”: the columns get placeholder names you can replace, and the downloaded file gains a proper header.

Changing the order

Use the arrow buttons to move a column up or down in the list; the top of the list is the first column in the result. Many importers ignore order and match by name, but some, especially older systems and fixed templates, read columns by position, and then order matters.

Checking before you download

The preview below the list shows the result with your changes applied, including row numbers. Check the first rows against the template you are matching. If something went wrong, Reset puts every column back as it was.

Values are not touched

Only columns are removed, renamed or moved. Every cell value is copied character for character, so leading zeros in IDs and ZIP codes, long numbers and dates in any format arrive exactly as they were. When saving to Excel, plain numbers become real numeric cells while codes with leading zeros stay text.

Saving

Download the result as CSV, Excel or TSV. For CSV, choose the separator the destination expects and whether to add a byte order mark for Excel.

Typical jobs

Preparing a contact list for a newsletter tool, cleaning a product export before a shop import, removing personal columns before sharing a file with a colleague, or reordering columns to match a fixed accounting template.

Working with very wide files

Some exports have a hundred columns or more, of which you need five. Switching off ninety-five columns one by one is tedious; instead keep the list scrolled to the columns you need and check the panel title, which counts how many are kept. The preview shows the first 60 columns, enough to confirm the layout before downloading.

Related tools

To change values inside columns, use CSV Find and Replace. To split a name column into first and last names, use Split Names. For calculations and formulas, open the file in the Online Spreadsheet.