Find and Replace in Excel
Change text across a whole spreadsheet in one pass, with case, whole-cell and regular expression options. It runs in your browser and nothing is uploaded.
- Free, no sign-up
- Files stay on your device
- Regular expressions
- All sheets at once
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Find and replace spreadsheet values in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your file
Choose your Excel, ODS or CSV file, or drag it onto the page. Leave the sheet box empty to search every sheet.
- STEP 02
Enter find and replace
Type the text to find and what to put instead. Leave the replacement empty to delete the text.
- STEP 03
Set the matching and download
Choose Match case, Whole cell only or a regular expression. The note reports how many matches changed.
What Find and replace spreadsheet values does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Plain or regexPlain text is matched literally. Tick the regex box for patterns, with $1, $2 for captured groups.
- Case and whole-cell controlSearch is case-insensitive by default. Whole cell only matches only when the entire cell equals your text.
- Numbers handledNumeric cells can be changed too. If the result still looks like a number, it stays a number.
- Formulas and dates left aloneFormula cells and real date cells are skipped, so they cannot be broken.
- Layout stays putNothing moves, so merged cells, column widths and formulas remain.
Good to know
- No styling keptColors, fonts and borders are lost when the workbook is rewritten.
- Not found means no fileIf nothing matches, the tool tells you instead of returning an unchanged file.
- One find-and-replace per runTo make several changes, run it again on the result. Spaces alone can be cleaned with Trim Excel whitespace.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Find and replace spreadsheet values
Fix a typo everywhere
Correct a misspelled city or brand across thousands of rows.
Change decimal marks
Swap commas for points, or the other way round, in text numbers.
Update codes
Replace an old prefix with a new one.
Reformat values with regex
Wrap phone numbers or strip units like kg from text.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Plain text versus regular expressions
Leave the regex box unticked and special characters such as a dot or a bracket are treated as ordinary text. Tick it when you want patterns, for example \d+ for any number or (\w+)@ to capture the part before an at sign.
Examples
A few common jobs:
- Delete all dashes: find -, leave Replace with empty.
- Remove a unit: find \s*kg$, tick regex.
- Swap order: find (\w+), (\w+), replace $2 $1, tick regex.
- Exact match only: tick Whole cell only to change N/A without touching N/A-2.
Other helpers
After replacing, Convert numbers stored as text turns cleaned values into real numbers, and Compare Excel files shows exactly what changed.
Tip: try a small file first to see how the pattern behaves. The note reports how many matches were replaced and in how many cells, which makes a wrong pattern easy to spot.
Questions, answered
How do I find and replace across all sheets in Excel?
Add the workbook, leave the sheet box empty, enter your text and download.
Does my spreadsheet leave my device during replace?
No. The replacement is done in your browser.
Can I use regular expressions?
Yes. Tick the regex box and use $1, $2 in the replacement to reuse captured groups.
Will formulas be edited?
No. Formula cells are skipped so they keep working.
Is it case sensitive?
Not by default. Tick Match case to change that.
Does it work on a phone or a Mac?
Yes, on iOS, Android, macOS and Windows browsers.