Toolgebra/Tools/Data Operations

CSV Column Filter

Select or remove specific columns from your CSV file

Data Operationscsvfiltercolumnsselect
Input

Upload a CSV file to filter columns

0 / 1,000,000 characters

Parameters

Choose whether to include or exclude columns

Select columns to include or exclude

No options available yet. This will be populated after you upload a file.

Output

Output will appear here after executing the tool

Processing happens entirely in your browser - your data stays private

Documentation

How to Use

Upload a CSV file and choose which columns to keep or remove. **Include Mode (Whitelist):** Select specific columns to keep in the output. All other columns will be removed. **Exclude Mode (Blacklist):** Select specific columns to remove from the output. All other columns will be kept. The tool preserves the order of rows and handles different CSV formats (comma, tab, semicolon separated).

Examples

Keep only Name and Email columns

Extract contact information from a larger dataset

Input:

Name,Email,Phone,Address
John Doe,john@example.com,555-0100,123 Main St
Jane Smith,jane@example.com,555-0101,456 Oak Ave

Parameters:

{
  "mode": "include",
  "columns": [
    "Name",
    "Email"
  ]
}

Expected Output:

Name,Email John Doe,john@example.com Jane Smith,jane@example.com

Remove sensitive columns

Remove SSN and Password columns before sharing data

Input:

ID,Name,SSN,Password,Email
1,John Doe,123-45-6789,secret123,john@example.com
2,Jane Smith,987-65-4321,pass456,jane@example.com

Parameters:

{
  "mode": "exclude",
  "columns": [
    "SSN",
    "Password"
  ]
}

Expected Output:

ID,Name,Email 1,John Doe,john@example.com 2,Jane Smith,jane@example.com

Reorder columns

Select columns in a specific order

Input:

ID,Address,Name,Email
1,123 Main St,John Doe,john@example.com

Parameters:

{
  "mode": "include",
  "columns": [
    "Name",
    "Email",
    "Address"
  ]
}

Expected Output:

Name,Email,Address John Doe,john@example.com,123 Main St
Notes & Tips

**Tips:** - Use Include mode when you know exactly which columns you need - Use Exclude mode when you want to keep most columns and remove a few - Column names are case-sensitive - Empty cells are preserved in the output - The tool automatically detects CSV delimiters (comma, tab, semicolon) **Limitations:** - Maximum file size: 10MB (configurable in tool settings) - Large files may take longer to process

Category
data
Version
1.0.0
Processing
Client-side
Max File Size
10 MB
CSV Column Filter - Free Online Tool | Toolgebra