happytails.ai

CSV row filter

Open CSV row filter on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.

Tool capabilities

{
  "id": "csv-row-filter",
  "category": "data-tools",
  "built": true,
  "requirements": "Paste CSV with a header row, then enter one rule per line as column,operator,value. Use All to require every rule or Any to keep a record that matches at least one. Column names must match exactly. Quote a value containing a comma, just as you would in a CSV cell. Text rules support exact matches, contains, prefixes, suffixes and empty cells. You can turn off case-sensitive text matching. Numeric rules compare signed decimal strings exactly, including integers larger than JavaScript's usual safe integer range. Spaces and exponent notation are not interpreted as numbers; non-numeric comparisons are counted separately. The preview retains leading zeros, spaces, quoted line breaks and long identifiers. Download the filtered CSV and a JSON processing report. The default export prefixes formula-like cells with an apostrophe, which changes those exported strings. Choose Preserve original cells for trusted machine processing. Spreadsheet applications can still infer numbers and dates when opening CSV.",
  "implementation": {
    "fields": [
      {
        "key": "delimiter",
        "label": "Input CSV separator",
        "value": ",",
        "type": "select",
        "values": [
          ",",
          ";",
          "\t"
        ]
      },
      {
        "key": "rules",
        "label": "Filter rules",
        "value": "country,equals,Portugal\nscore,number-gte,80",
        "type": "textarea",
        "help": "One rule per CSV record: column,operator,value. No header. Quote values containing commas. Up to 20 rules. Operators: equals, not-equals, contains, not-contains, starts-with, ends-with, is-empty, is-not-empty, number-gt, number-gte, number-lt, number-lte."
      },
      {
        "key": "match",
        "label": "Keep records matching",
        "value": "All",
        "type": "select",
        "values": [
          "All",
          "Any"
        ]
      },
      {
        "key": "caseSensitive",
        "label": "Case-sensitive text matching",
        "value": true,
        "type": "checkbox"
      },
      {
        "key": "exportMode",
        "label": "Spreadsheet formula handling",
        "value": "Protect formulas",
        "type": "select",
        "values": [
          "Protect formulas",
          "Preserve original cells"
        ]
      }
    ],
    "live": true,
    "presentation": "metrics",
    "note": "Filter multiple columns with explicit All or Any conditions. Numeric rules compare signed decimal strings exactly, including large integers; non-numeric cells are reported as skipped comparisons. Empty means an empty string, not spaces or zero. Use a header row with unique column names. Up to 1,000,000 input characters, 10,000 data records, 100 columns and 100,000 cells. Strings and spaces are preserved. Output CSV uses commas and quotes every cell. Protect formulas prefixes risky output cells with an apostrophe; choose Preserve original cells only for trusted machine processing. Runs on your device.",
    "experience": {
      "automatic": true,
      "single": false,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "label": "CSV",
      "placeholder": "name,score\nAda,98\nSam,92",
      "help": "Include a header row. Quote cells that contain commas or new lines. Results update as you type. Up to 1,000,000 characters.",
      "helpParts": [
        "Include a header row. Quote cells that contain commas or new lines.",
        "Results update as you type.",
        "Up to 1,000,000 characters."
      ],
      "action": null
    },
    "mode": "automatic",
    "interactive": false
  },
  "execution": "Browser interface",
  "api": null,
  "browser_agent": {
    "supported": true,
    "name": "run_current_tool",
    "discovery": "WebMCP on the human page in a supporting browser",
    "verification": "See audit/API-AUDIT.md; availability is not verification"
  }
}

Page guide

Keep the CSV records you need with clear rules across multiple columns. Preview the matches and download a new CSV.

How to use CSV row filter
  1. Paste CSV with unique column names and choose its separator.
  2. Enter filter rules and choose whether all or any must match.
  3. Review the kept-record count and table, then download the CSV and report.

Useful next steps

CSV cell expansionCSV unpivotDataset value mapperCSV to JSON

What to expect

Keep the CSV records you need with clear rules across multiple columns. Preview the matches and download a new CSV. Paste CSV with a header row, then enter one rule per line as column,operator,value. Use All to require every rule or Any to keep a record that matches at least one. Column names must match exactly. Quote a value containing a comma, just as you would in a CSV cell. Text rules support exact matches, contains, prefixes, suffixes and empty cells. You can turn off case-sensitive text matching. Numeric rules compare signed decimal strings exactly, including integers larger than JavaScript's usual safe integer range. Spaces and exponent notation are not interpreted as numbers; non-numeric comparisons are counted separately. The preview retains leading zeros, spaces, quoted line breaks and long identifiers. Download the filtered CSV and a JSON processing report. The default export prefixes formula-like cells with an apostrophe, which changes those exported strings. Choose Preserve original cells for trusted machine processing. Spreadsheet applications can still infer numbers and dates when opening CSV.

Try a small example

country,score,name
Portugal,90,Ana
Portugal,70,João
Spain,95,Bea
Portugal,n/a,Lee