Replacing one word is easy. Replacing fifty words, names, or codes across a long document is not. Bulk find and replace lets you swap many items at once instead of hunting through text line by line. This guide shows you how to do it safely, in the right order.
What bulk find and replace means
Normal find and replace swaps one search term for one replacement. Bulk find and replace works from a list of pairs: old word one becomes new word one, old word two becomes new word two, and so on. You run the whole list in a single pass.
People use it to update product names, fix repeated typos, rename terms in a report, or clean up data copied from a spreadsheet.
Step-by-step: replace text in bulk
- Make a list of pairs first. Write each old term next to its new term, one pair per line.
- Sort the list longest-first. If “New York City” and “New York” are both on the list, replace the longer phrase first, or the shorter one will break it.
- Decide on case matching. Matching case avoids changing words you did not mean to touch, such as turning “mark” into “Mark” inside “market”.
- Decide on whole-word matching when you can. Replacing “art” without it would also change “part” and “start”.
- Run the replacements in order, then read the result. Check the first and last matches of each term.
- Keep a copy of the original text. If one rule goes wrong, you can start again instead of untangling the damage.
Ordering pitfalls
Order is where bulk replacement usually fails. Replacing A with B and then B with C turns every original A into C. If that is not what you want, chain the rules carefully or use placeholders. Another trap is overlapping terms: “color” and “colorful” must be handled longest-first, or “colorful” becomes “colourful” only in part.
Watch out for replacements that create new matches. If a replacement word itself appears as a search term later in the list, it will be replaced again.
Try it the faster way
The tool below runs your whole pair list at once, in the order you set.
Prefer the full page? Open the bulk find and replace tool directly.
Quick tips
- Test your rule list on a small sample before running it on the full document.
- Count matches before and after, so you can spot a rule that matched nothing or too much.
- For names and codes, use whole-word matching to protect longer words that contain them.
Bulk replacement saves real time, but only when the rules are ordered well. Sort longest-first, check case and whole words, and always keep the original.
Frequently asked questions
What happens if two of my rules overlap? The first rule runs first and changes the text, so the second rule sees the changed version. For example, replacing “color” with “colour” and then “colour” with “color” again undoes the first change. Order your rules so later rules never match earlier replacements, or use temporary placeholders.
Should I use case-sensitive replacement? Use it when the case carries meaning, such as proper names or code identifiers. For ordinary prose cleanup, case-insensitive matching catches more instances, but check each match, since it can also change words inside other words.
How do I undo a bad bulk replacement? You cannot undo it from the output alone, because the original words are gone. That is why you always keep the original text saved separately before running bulk rules.
Worked example
Suppose a report mentions “Acme Corp” 40 times and the company rebrands to “Acme Group”. A bulk list with one pair, Acme Corp to Acme Group, fixes every mention at once. But if the list also renames “Acme” alone to “Acme Group”, order matters: run the longer phrase first, or the short rule will turn “Acme Corp” into “Acme Group Corp” before the long rule ever sees it. Test the list on one paragraph first, confirm the count of changes matches your expectation, then run it on the full document.