Free tool Find and replace many terms at once
A dozen terms to change in one article, inconsistent UTM values across a list of links, product titles with wording you need to drop: write the rules one per line (or paste two columns straight from a spreadsheet) and replace them all in one go. You see how many times each rule matched and exactly which lines changed.
- Many rules in one pass
- Regex supported
- Runs in your browser
Write the rules, replace in one go
Paste your text at the top and write one rule per line below: find => replace, or two columns copied from a sheet (find, then replace, separated by a tab). A rule with nothing to replace with deletes the match.
It stays in this browser tab and is never uploaded.
Separate with =>, → or a tab. Lines starting with # are comments.
Replacements
4
Spots actually changed, across all rules.
Rules that changed text
3
Rules with at least one replacement.
Lines changed
3
Lines that differ after replacing.
Rule check
Replacements per rule
Rules that changed nothing are orange; the usual cause is a case, spacing or punctuation difference.
| # | Find | Replace with | Result |
|---|---|---|---|
| 1 | Tap Cub | TapCub | 1 replaced |
| 2 | tapcub | TapCub | 2 replaced |
| 3 | e-mail | email | 1 replaced |
Preview of changes
Only changed lines: struck-through text was removed, green text was inserted.
- 1Try
TapcubTapCub free for 14 days! - 2
Tap CubTapCub shows visitors, sources and conversions, and every plan includes live chat. - 3Questions? Send us an
e-mailemail before you sign up forTAPCUBTapCub.
Try TapCub free for 14 days!
TapCub shows visitors, sources and conversions, and every plan includes live chat.
Questions? Send us an email before you sign up for TapCub.Version v1.0Updated Update history
Check the counts, then the preview
Bulk replacing has two failure modes: something you meant to change was missed, or something you didn’t mean to change was hit. The counts and preview catch both.
Replacements per rule
A rule that changed nothing is flagged orange; usually the text is written slightly differently (case, a hyphen, an extra space). More matches than you expected means the rule may be hitting places it shouldn’t.
Preview
Each changed line, with removed text struck through and inserted text in green. If a replacement adds or removes line breaks, the preview shows the whole text instead.
In order vs simultaneously
In order, rule 2 runs on the output of rule 1, so “A → B” then “B → C” turns A into C. Simultaneously, each spot is replaced once by the first rule that matches there, which lets you swap two terms.
Rule check
An invalid regex is reported with its line number and the error; that rule is skipped and the rest still run. Syntax that GA4’s RE2 engine doesn’t support (lookarounds, backreferences) is flagged too.
Once a regex works here and you want to use it in GA4, check it against RE2 rules and real values with the regex tester.
Bulk replace in three steps
Type rules by hand, or keep them as two columns in a spreadsheet and paste the block in.
-
1
Paste the text
An article, a list of product titles, a list of URLs, code.
-
2
Write the rules
One per line,
old => new. Put longer, more specific rules first so a short rule doesn’t break them up. -
3
Check, then copy
Review the counts and the preview, then copy or download the result.
How to write rules
By default rules are plain text and every symbol is literal; tick “Use regular expressions” to run them as JavaScript regex.
- A tab (two columns from a sheet) takes priority as the separator, then
=>and→. Spaces around the separator are dropped; to match a leading space use regex\sor\x20 - Regex mode always uses the
g(replace all),u(Unicode) andm(^and$match at each line) flags - Replacements support
$1…$99,$<name>,$&(the whole match) and$$(a literal dollar sign), the same as JavaScript’sString.replace - Empty matches (a lone
^or\b) are not replaced, so a rule can’t insert text at every position by accident
| Goal | Rule | Options |
|---|---|---|
| Change a term | e-mail => email | — |
| Delete a term | [AD] (nothing after it) | — |
| Commas to line breaks | , => \n | Understand \n |
| Normalize a UTM source | utm_source=(fb|facebook)\b => utm_source=facebook | Regex + ignore case |
| Remove trailing spaces | [ \t]+$ => | Regex |
| Mask the middle of a number | (\d{3})\d{4}(\d{4}) => $1****$2 | Regex |
Making a brand name consistent
The default example: three lines of copy with four spellings of the product name and one “e-mail”, three rules applied in order, ignore case and whole words on.
| # | Rule | Matches | Notes |
|---|---|---|---|
| 1 | Tap Cub => TapCub | 1 | Line 2 |
| 2 | tapcub => TapCub | 2 | “Tapcub” in line 1 and “TAPCUB” in line 3 (ignore case). The “TapCub” that rule 1 just wrote also matches, but replacing it with the same text is not counted |
| 3 | e-mail => email | 1 | Line 3 |
4 replacements, all 3 lines changed. Only real changes are counted: a match replaced with identical text doesn’t add to the total. With overlapping rules, order matters: put the longer, more specific one first.
Where bulk replacing goes wrong
A bulk replace changes a lot of text at once, and mistakes are easy to miss.
Short rules before long ones
Replace “sale” before “sale price” and the longer rule never matches. Put long, specific rules first.
Swapping terms in order
“A → B” then “B → A” in order turns everything into A. Use “Simultaneously” to swap.
Changing part of a word
Replacing cat with dog turns category into dogegory. Tick “Whole words only” for English terms.
Unescaped regex characters
In regex mode ., ? and ( have special meanings; write \. for a literal dot. For plain replacements, leave regex off.
Consistent names keep reports in one row
The most common “one thing shows up as several rows” problem in analytics comes from inconsistent spelling: utm_source=Facebook vs fb, or old and new event names. A bulk replace before you publish links or ship tracking fixes it at the source.
Marketing analytics
Visitors and conversions by UTM source, medium and campaign; consistent link tagging keeps each channel on one row.
Learn moreData quality
Unexpected event names, missing properties and wrong value types are flagged; events and properties can be merged, renamed or retired.
Learn moreEvent analytics
Consistently named events roll up correctly in event analysis and funnels.
Learn moreFind and replace FAQ
Still have a question?
Chat with the team behind TapCub — we usually reply within a few hours on business days.
How do I replace multiple words at once?
Write one rule per line in “Rules”, like “old => new”, as many as you need. Or keep the pairs as two columns in a spreadsheet and paste them in; the tab between columns works as the separator.
Does it support regular expressions?
Yes. Tick “Use regular expressions” and rules run as JavaScript regex, with $1 etc. in the replacement. GA4 and Looker Studio use RE2, which has no lookarounds or backreferences; the tool tells you when a rule uses them.
What is the difference between “in order” and “simultaneously”?
In order runs each rule over the whole text before the next, so later rules see earlier replacements. Simultaneously scans the text once and replaces each spot with the first rule that matches there; replaced text is never touched again, so you can swap two terms.
How do I replace commas with line breaks?
Use the rule , => \n with “Understand \n and \t” ticked. To go the other way, use \n => ,.
How do I delete a word?
Write only the word, without => or a replacement. It is replaced with nothing.
Why does a rule show no changes?
Usually the text is written slightly differently: case, a hyphen, curly vs straight quotes, an extra space. Tick “Ignore case”, or tidy the text first with the text cleaner (collapse spaces, convert full-width characters).
Is my text uploaded?
No. Replacing runs in your browser; neither the text nor the rules go into the URL or to TapCub.
Update history
New features, fixes and data refreshes for this tool, newest first.
-
· v1.0
LaunchedFirst release.
Missing something or found an error? Tell us — requests that come up often go into the next update. All tool updates
With UTM values cleaned up, compare channels
With TapCub installed, see visitors and conversions by UTM source, medium and campaign.