OpenToolDesk.
English
All tools/Excel & CSV
Excel & CSV

Filter CSV rows by column

Filter a CSV file by a value in one column. Keep matching rows, review the other rows, and download both CSV files without losing quoted commas or original column order.

Upload a file

Drag and drop files here

CSV

One file · 5 MB per file

Use a direct public file link up to 20 MB, or the smaller limit shown above. The download service retrieves the file; sign-in links are not supported.

    Download an example file

    or

    CSV input

    Paste text or upload a file. If you select a file, it takes priority.

    Filter CSV rows by column

    Need only the support tickets, orders for one region or survey responses containing a phrase? Upload a CSV and name the column to inspect. Choose an exact, partial, prefix, suffix or empty-cell condition. The tool keeps every source column, writes matching and other rows to separate downloads, and lets you invert the rule. Review both outputs before replacing an original spreadsheet export.

    How to use this tool

    1. Upload a UTF-8 CSV, drag it into the dropzone, import a direct public CSV URL, or paste a short CSV after the upload options. Try the included team example.
    2. Enter the exact column header and choose contains, equals, starts with, ends with, empty or not empty. Choose case matching and whether to keep matching or nonmatching rows.
    3. Download matching-rows.csv and other-rows.csv. Check row counts and sample values before replacing your source file.

    Supported input formats

    • CSV

    Available settings

    • Column name
    • Filter conditionContainsEqualsStarts withEnds withIs emptyIs not empty
    • Value to match
    • Letter caseIgnore caseMatch case
    • Keep rows thatMatch the conditionDo not match the condition

    Output and limitations

    Filter a CSV file by a value in one column. Keep matching rows, review the other rows, and download both CSV files without losing quoted commas or original column order.

    Upload one UTF-8 comma-separated CSV up to 5 MB, 10,000 data rows and 100 columns, or paste up to 12,000 characters. Enter a header name exactly as it appears. Choose contains, equals, starts with, ends with, empty or not empty; matching ignores case unless selected otherwise. The inverse option keeps rows that do not match. Each output keeps the source column order and complete rows. Blank means an empty cell, not a cell containing spaces. Formula-like cells are protected in downloaded CSVs. Excel workbooks, numeric comparisons and multi-condition filters are not supported.

    Will filtering change CSV columns or spreadsheet formulas?

    No columns are removed or reordered. Each output contains the complete source rows for its side of the rule. CSV files do not calculate formulas; formula-like values receive a leading apostrophe in the downloaded files to prevent execution when opened in a spreadsheet. Keep your original export for comparison.

    Can I filter numbers or combine several conditions?

    The first version compares text in one column. It does not calculate numeric ranges or combine conditions. For numbers, an exact text match works only when the cells have the same representation. You can run a second filter on the first download, keeping a copy of the original CSV.

    What if processing fails?

    Check the supported formats and file limits, then try a smaller file. Keep an original copy. A clear error message will explain an unsupported input or an unavailable processing service.

    All tools →

    ICS to CSV converter

    Convert ICS calendar files to CSV for Excel or Google Sheets. Export event titles, dates, time zones and recurrence details, with JSON data and a review report.

    Open tool →

    CSV column profiler

    Profile CSV columns for empty cells, distinct values, repeated entries and whitespace differences. Download column statistics, value frequencies and JSON.

    Open tool →

    CSV encoding converter

    Convert a CSV or TSV from Windows-1252, UTF-16, Shift JIS and other selected text encodings to UTF-8 for Excel and spreadsheet imports.

    Open tool →
    Show more

    CSV to Excel converter

    Convert CSV to XLSX online while preserving leading zeros, long IDs, phone numbers and postal codes as text in Excel.

    Open tool →

    CSV to VCF contact converter

    Convert a contacts CSV or TSV into a vCard VCF file for phone and address-book import, with explicit first-name, surname, phone and email column mapping.

    Open tool →

    Unpivot CSV to long format

    Unpivot wide CSV or TSV data into a tidy long-format table while repeating chosen identifier columns beside each field name and value.

    Open tool →

    HTML table to CSV converter

    Extract a real HTML table from a web page or saved HTML file into a spreadsheet-ready CSV, including rows with merged cells.

    Open tool →

    Excel formula finder

    Find every cell formula in an XLSX workbook, including hidden sheets, and export sheet names, cell addresses and likely external workbook references to CSV.

    Open tool →

    Join CSV files by key

    Join two CSV files using matching ID columns. Choose an inner, left or full outer join and download unmatched rows separately.

    Open tool →

    Compare CSV files

    Compare two CSV files by a unique key. Download added, removed and changed cells with an original-versus-updated report.

    Open tool →

    CSV file merger

    Combine spreadsheet exports by matching column names, with an optional source filename column.

    Open tool →

    CSV duplicate finder

    Find repeated records by selected columns and download unique rows and duplicates.

    Open tool →

    Keep latest row per ID in CSV

    Remove duplicate CSV records by one or more ID columns while keeping the row with the latest or earliest date. Download selected, removed and review rows with a decision report.

    Open tool →

    CSV to SQL INSERT statements

    Convert a CSV file into a downloadable SQLite or PostgreSQL script with CREATE TABLE and INSERT statements. Keep every value as text, or explicitly export blank cells as NULL.

    Open tool →

    CSV to JSON

    Convert CSV rows into JSON objects while preserving text values.

    Open tool →

    JSON to CSV

    Convert a JSON array of objects into a spreadsheet-ready CSV.

    Open tool →

    CSV row splitter

    Split a CSV into smaller files with repeated headers and download them together as a ZIP.

    Open tool →

    CSV column selector

    Keep selected CSV columns and place them in a chosen order.

    Open tool →

    Transpose CSV

    Swap the rows and columns of a CSV table.

    Open tool →

    CSV delimiter converter

    Change comma, semicolon, tab or pipe separators for Excel and Sheets imports.

    Open tool →

    CSV header mapper

    Rename spreadsheet column headers to match an import template.

    Open tool →

    Survey spreadsheet cleaner

    Convert multi-select survey answers from Google Forms or Microsoft Forms CSV exports into separate yes/no columns without duplicating respondents.

    Open tool →

    CSV date format converter

    Normalize dates in CSV columns to YYYY-MM-DD, DD/MM/YYYY or MM/DD/YYYY. Preserve original values and review ambiguous or invalid dates in a separate report.

    Open tool →

    Excel to CSV converter

    Convert an XLSX workbook to separate CSV files for each worksheet. Choose formatted or raw saved values, include hidden sheets, and download a ZIP, JSON and review report.

    Open tool →