Keyword Wrapper Tool for Bulk Match-Type Formatting
PPC specialists and SEOs managing bulk lists reach for this wrapper when an ad group needs every term in a single match type. The usual moment is a client export landing as plain text, an old spreadsheet headed for migration, or a search term report that has to become negatives before tomorrow launches. Paste the list, pick broad, phrase, exact, negative, or all three columns, and each line leaves wrapped in the right syntax with duplicate and flag counts beside it. Typing quotes and brackets by hand across hundreds of terms is slow, and one missed bracket makes the import editor reject the row.
How It Works
Splitting happens first. The delimiter menu offers lines, commas, tabs, and auto, and auto counts the tabs, commas, and line breaks in the paste, then splits on whichever appears most: tabs win when a spreadsheet row was copied, commas win for CSV text, and newlines stay the fallback. Each piece is trimmed of surrounding spaces, empty pieces are counted and dropped, and the survivors form the input number shown in the stats. That is why a paste full of blank rows raises the empty count while leaving the input count alone.
Dedupe then runs over a Set of lowercased terms, so the first spelling stays and each repeat adds one to the duplicates counter instead of the output. The same pass inspects every term for a double quote, an opening bracket, or a closing bracket and records matches in the flagged list, because those characters mean the keyword arrived already formatted. Wrapping itself is a per-mode string build: broad leaves the term bare, phrase adds quotes, exact adds square brackets, and negative puts a minus sign in front of the bracket pair. Since the job is wrapping rather than substituting, no regex escaping is involved and characters inside your terms pass through untouched.
Mode all skips the single-wrapper path and prints a tab separated table with a Broad, Phrase, and Exact header, one row per keyword, which pastes straight into Sheets or Excel for side-by-side review. Everything is plain string work inside the tab: no request carries your list, no copy is kept, and reloading clears the input and the output together.
Before and After
input
running shoes
blue shoes
Running Shoes
output
[running shoes]
[blue shoes]
stats
inputCount 3, outputCount 2
duplicatesRemoved 1, emptyRemoved 0
flagged 0Broad Phrase Exact
coffee "coffee" [coffee]Use Cases
| Developer | Production | Workflow |
|---|---|---|
| Wrapping a generated term dump once instead of writing a formatter into a script | Turning last week's converting search terms into negative exacts | Agency bulk imports where the client sheet arrives as plain lines |
| Feeding a staged ad group file to a pipeline that expects bracketed terms | Migrating BMM-era sheets that still carry plus signs into phrase syntax | Staging exact-match ad groups one match type at a time |
| Checking a wrapper diff before a keyword export is committed | Re-running a query report cleanup after each weekly pull | Spreadsheet QA of exported term lists using duplicate and flag counts |
Common Mistakes and Troubleshooting
- Pasting keywords that already carry quotes or brackets. They are reported as flagged and then wrapped again, producing nested syntax the editor refuses, so strip the old symbols first and rerun.
- Leaving the delimiter on lines while pasting a comma list. The whole line becomes one giant keyword, which is a sign to switch the menu to auto or commas and wrap again.
- Expecting the wrapper to singularize, stem, or reorder words. Terms are formatted verbatim, so best running shoes review comes out exactly as typed inside its brackets.
- Reading negative mode as a campaign-level setting. It outputs exact negatives such as -[running shoes], which belong in the negative keyword list, while phrase and campaign negatives are configured in the Ads interface.
- Copying from Excel that inserted curly smart quotes. Those are different characters from straight quotes, so phrase output looks odd to the editor; replace them with straight quotes before pasting.
- Judging a paste by its height rather than the counters. Blank lines never enter the input count and land in the empty counter instead, so a tall box with a small input number is working as designed.
Best Practices
- Run one match-type pass per ad group so every keyword in that group shares the same syntax and bidding rules.
- Leave dedupe switched on before upload, since repeated terms split impressions across near-identical rows and muddy the reporting.
- Keep master lists plain in the repo and wrap them only at export time, which preserves one clean source for every account.
- Use the all mode table when a client wants to review broad, phrase, and exact side by side in a sheet before choosing one column.
- Pair this with a clustering tool when terms are new, because clustering decides which keywords group together while wrapping only writes them.
- Save the plain list alongside the wrapped export under version control, so a disputed keyword change can be traced to the pass that produced it.
Frequently Asked Questions
What do the quotes, brackets, and minus sign do?
A bare term such as running shoes is broad match, so ads can show on queries Google reads as related to your words. Quotes give phrase match, which keeps the words in order while allowing terms around them, and square brackets give exact match, where the query has to be the same search. A minus sign in front of the bracket pair makes the keyword an exact negative that blocks the term instead of bidding on it. The wrapper applies one shape to every line you paste, and the all mode prints broad, phrase, and exact columns side by side.
Why did the broad match modifier disappear?
Google Ads retired the broad match modifier in September 2021 and folded its behavior into phrase match, so a phrase keyword now also covers close variants that once needed a plus sign in front of each word. Reach did not shrink: phrase and exact both pick up close variants such as plurals and reordered words, which is why the change was presented as simpler rather than narrower. The plus syntax still shows up in old spreadsheets, migration notes, and Microsoft Ads imports, where a client may want the original intent recorded. This tool never adds a plus sign, so paste legacy terms as they are and let phrase mode produce the current syntax.
How do I bulk-wrap a list pasted from a spreadsheet?
Copy a column or a row out of Excel or Google Sheets and paste it into the input box, where a copied column arrives line separated and a copied row arrives tab separated. Set delimiter to auto and the splitter counts tabs, commas, and line breaks, then splits on whichever appears most, so a CSV export and a sheet paste both land correctly without a setting change. Spaces around each term are trimmed by default, and blank cells are dropped into the empty counter instead of wrapping into empty lines. Leave dedupe on unless the sheet repeats a term on purpose.
How does the output import into Google and Microsoft Ads?
Each mode prints one keyword per line, which is the shape the Google Ads editor and Microsoft Advertising Editor want when you paste multiple keywords into an ad group. Open the ad group, choose to add keywords, and paste the whole block; brackets and quotes survive because they are plain ASCII characters. The all mode behaves differently, emitting tab separated columns under a Broad, Phrase, and Exact header, so paste it into a sheet first and pick the column to upload. Negative output belongs in the negative keyword list, where the editor reads -[term] as an exact match exclusion.
How does duplicate handling work?
Dedupe is on by default and compares lowercased copies of each term, so Running Shoes and running shoes count as one keyword rather than two rows competing for the same query. The stats region reports input count after blanks are removed, duplicates removed, empty entries dropped, and the final output count, which makes a messy client list quick to audit. Switch the checkbox off when a sheet repeats a term across sections on purpose. Counts rise once per extra copy, so three occurrences of one term show two removed.
What does the flagged count mean?
The flagged count rises when a keyword already contains a double quote, an opening bracket, or a closing bracket, because wrapping it again produces nested syntax that the import editor rejects. The flagged terms are listed below the stats so you can strip the old symbols and rerun the wrap. Flags never block output: the term is still wrapped exactly as typed, so read the list whenever the count sits above zero. Terms coming from a previous export or another formatting tool are the usual source.
How is this different from keyword clustering?
Wrapping formats terms you already collected, while clustering groups a larger raw set into thematic buckets so you know which terms belong in the same ad group. Run clustering first when the list comes from a search console export or a seed list, then bring each cluster here to receive its match type. The two jobs do not overlap: one decides which keywords sit together, the other decides how each keyword is written for the editor. Using only the wrapper leaves unrelated terms sharing an ad group, and using only clustering leaves you typing brackets by hand.