How to use
- Drop an
.xlsx,.csvor.tsvfile, or paste cells copied from Excel. This page opens with the Find & replace step already added. - Enter the text to find and the text to replace it with. Leave the replacement empty to delete what is found.
- To replace only in certain columns, choose them; with none chosen, every column is searched.
- Turn on case sensitivity, whole-cell match or regex as needed.
- The result preview highlights changed cells and reports something like
Replaced in 3 cells. Check it, then download as xlsx, csv or json.
Options
| Option | Behavior |
|---|---|
| Columns | Empty means all columns; otherwise only those (headers are never changed) |
| Case sensitive | Off by default |
| Whole cell | Replaces only when the cell is exactly the search text |
| Regex | Reads the search text as a regular expression and lets the replacement use $1, $2 groups |
With regex off, the search text is literal: ., ( and * are ordinary characters. $1 in the replacement is read as a group only when regex is on.
Examples
In a table with the headers Name, Phone, Note, the Note column holds Seoul office, SEOUL, seoul, 서울, and Phone holds 010-1234-5678, 010-9999-0000, 02-123-4567 and an empty cell.
| Setting | Result |
|---|---|
Find seoul → replace 서울 (defaults) |
3 cells replaced; Seoul office becomes 서울 office |
| Same, case sensitive | 1 cell (only lowercase seoul) |
| Same, whole cell | 2 cells (SEOUL, seoul); Seoul office is not an exact match and stays |
Same, limited to the Name column |
No matching cells |
- → empty in Phone |
3 cells replaced: 01012345678, 01099990000, 021234567 |
Regex (\d{3})-(\d{4})-(\d{4}) → $1$2$3 |
2 cells; 010-1234-5678 → 01012345678 (02-123-4567 has a different shape and stays) |
Same regex → $3-$2-$1 (Phone) |
5678-1234-010 |
Good to know
- Number cells: removing
0from the xlsx number100leaves1, still a number. Removing-from a text cell like010-…keeps it as text, so the leading zero survives. - Empty cells are left alone, and an empty search text changes nothing.
- An invalid regex (for example
() only shows an error and leaves the table as it was. Patterns are limited to 200 characters, and a regex that takes too long is stopped. Regex steps run in a separate worker thread so the page does not freeze. - Several replacements: stack more than one step and they apply from the top down, for example removing
(Inc.)and then(Ltd.). - Unlike Excel’s own Find & Replace, formulas are not involved. Formula cells are read as their calculated values, so saving writes values.
- Excel’s
?and*wildcards are not supported; use regex (.,.*) instead.
Related tools
- Several steps at once: Excel & CSV Workbench
- Replacing in plain text: Find & Replace
- Practice regular expressions: Regex Tester
- Space cleanup: Remove Blank Rows & Columns
Your file is processed only in your browser and is never sent to a server.