Find & Replace

A text editor's find-and-replace changes every match in the file, including header names and columns you did not mean to touch. Here you pick the columns to search. Replacing N/A with an empty value in a price column then leaves a product actually named "N/A" alone. With no columns selected, every column is searched. Header names are never changed; rename columns with Column Tools.

After each run the tool reports how many matches were replaced and in how many cells, which is a quick check that the pattern did what you expected.

Plain text (the default) replaces every occurrence of the search text inside each cell, ignoring case unless you turn on Case sensitive.

Whole cell only replaces a cell only when its entire content matches. Use it to recode values, such as turning Y into Yes, without also changing every Y inside other words.

Regex treats the search text as a JavaScript regular expression. Capture groups can be reused in the replacement, so (\d{2})/(\d{2})/(\d{4}) replaced with $3-$2-$1 turns 15/01/2026 into 2026-01-15. Combining Regex with Whole cell only and the pattern ^$ fills empty cells with the replacement value. An invalid pattern shows the browser's error message instead of changing anything.

Choose CSV, TSV, or JSON for the input; the result is written in the same format. Values are matched as text, so in JSON input a number such as 30 is matched as the string 30, and the output keeps every value as a string. Nested JSON objects are matched against their JSON text.