Find and replace in CSV — without uploading your file.

Exact match: the entire cell value must match — "apple" replaces "apple" but not "green apple". Contains: any substring match — "apple" matches "green apple pie". Regex: full JavaScript regex, for patterns like ^Mr\.\s or \d{3}-\d{4}.

No, by default. Tick "Case sensitive" to make it exact. The default is case-insensitive because that's what users usually want ("usa" should find "USA").

When you replace "united states" → "USA" and the original was "UNITED STATES", preserve-case makes the replacement also uppercase ("USA"). If the original was "United States", the replacement becomes "Usa". Useful when your text has mixed casing conventions you want to respect.

Yes. Pick the column in the dropdown. Leaving it blank applies the replacement across every column, which is faster for bulk text cleanup but riskier — double-check with Preview first.

Use regex mode with the pattern ^$ (matches empty strings) and your replacement text. Or use the Filter tool to find empty cells first.

Yes, in regex mode. Example: find (\d{4})-(\d{2})-(\d{2}), replace with $3/$2/$1 to flip ISO dates to DD/MM/YYYY. In non-regex modes, $ is treated as a literal dollar sign — safe by default.

No. Unlike Excel's Find & Replace, this tool doesn't reinterpret your data. Text stays text, numbers stay numbers, dates keep their format. That's the point — Excel often "helpfully" converts "01/02" to January 2nd, corrupting phone numbers and IDs. This tool doesn't.

Click Preview — the tool scans and shows the count of matches. Verify the number makes sense before clicking Apply & download.

Per-cell only. You can't write a regex that spans row boundaries. If you need row-level transformations, use the Validate tool for structure or a code environment for complex logic.

"💾 Save settings" stores your match mode, case sensitivity, and output format. The find/replace text fields are NOT saved (they're usually unique per task).

Yes. As you type in the Find field, the preview table updates live — showing the first 10 rows where a replacement will occur, with modified cells highlighted in accent color. A counter above the table tells you the total number of replacements that will be made. You can confirm the change is what you intended before downloading.

Run Find & Replace three times in sequence, or use Regex mode with alternation: Find ^(USA|U\.S\.A\.|United States)$ (make sure Exact match is off and Regex is on), Replace with US. Point the column selector at your country column so you don't accidentally rewrite text elsewhere in the file. The preview shows exactly which rows will change before you commit.