1. Home
  2. Spreadsheets & Data
  3. Find & Replace in Excel

Find & Replace in Excel

Find and replace across chosen columns at once, with regex support.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
Enter what to find and what to replace, and limit the columns if needed. Changed cells are highlighted in the result preview.

Operations

Replace in the chosen columns (all if none). Regex runs in a worker with a time limit.
Columns
Leave empty for all columns
Files are processed in your browser and never sent to a server.

How to use

  1. Drop an .xlsx, .csv or .tsv file, or paste cells copied from Excel. This page opens with the Find & replace step already added.
  2. Enter the text to find and the text to replace it with. Leave the replacement empty to delete what is found.
  3. To replace only in certain columns, choose them; with none chosen, every column is searched.
  4. Turn on case sensitivity, whole-cell match or regex as needed.
  5. 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 0 from the xlsx number 100 leaves 1, still a number. Removing - from a text cell like 010-… 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.

Your file is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.