FILTER CSV

How Do You Write a Filter Expression?

A filter expression is a short rule that each row either passes or fails. It is a small language built for this page, not SQL. You name a column, an operator, and a value, then combine tests with AND, OR, NOT, and parentheses. An example: price > 10 AND state = "NY".

• Comparisons: = != > >= < <=. Numbers compare as numbers, dates as dates, anything else as text ignoring case.
• Text tests: contains, starts with, ends with, and matches for a regular expression written as /re/flags or in quotes.
• Lists and blanks: in (NY, NJ), is empty, and is not empty. Put NOT before any test to reverse it.
• Column names with spaces go in [square brackets] or backticks, and values with spaces go in quotes.

What Happens When You Type Plain Words?

If the bar holds plain words with no operator, the filter becomes a text search across every column. A row matches when all of the words appear somewhere in it, in any column and any order. Typing smith boston finds rows that mention both, which is often quicker than writing a full rule.

Which Filters Come Up Most Often?

The example chips under the bar are built from your own column names, so they are ready to edit instead of typed from nothing. Common rules include finding rows where an email column is empty, keeping only one state or region, pulling orders above a dollar amount such as $1,250.00, and matching a pattern with a regular expression.

A filter also feeds other tools. The CSV splitter splits only matching rows when a filter is on, and Remove rows accepts a filter expression to delete rows that match it.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.