Mobile SERP Preview
See your listing the way most people actually see it.
Deduplicate, trim and tidy a messy keyword export.
Treat as duplicates
Also do
The Keyword List Cleaner takes a merged export and removes exact duplicates, then the near-duplicates you choose to treat as duplicates: casing, punctuation, plurals and word order, each a separate toggle. Match type brackets are stripped and rows can be filtered by word count, which turns a morning of spreadsheet formulas into one paste.
Paste an export and the cleaner removes exact duplicates, then optionally the near-duplicates that differ only by casing, punctuation, plural form or word order. Match type brackets and quotes are stripped, extra whitespace collapsed, and rows filtered by word count or character length.
Every keyword export arrives dirty because it comes from several places. Keyword Planner uses one casing, Search Console another, a competitor scrape a third, and merging them produces a list where "Merino Socks", "merino socks" and "merino sock" are three rows that are one keyword. Cleaning that by hand in a spreadsheet is a morning's work with formulas; here it is one paste. The near-duplicate options are deliberately separate toggles, because whether a plural is the same keyword as its singular depends on the market you are in.
Exact, case-insensitive, punctuation-insensitive and plural-insensitive, each on its own toggle.
"socks merino" and "merino socks" collapse into one when you want them to, and stay apart when you do not.
A Google Ads export gives one keyword three times in three match types. Those become one row.
Drop the one-word heads or the eight-word tails, depending on what the list is for.
Every rule reports what it removed, so a surprising drop in count is traceable.
One per line. Exports from any tool work as they are.
Exact duplicates always go. Casing, punctuation, plurals and word order are separate choices.
Drop the one-word heads or the eight-word tails if this list is for a specific job.
The counts show exactly how much was removed and why.
It depends. Google often returns near-identical results for a singular and its plural, in which case they are one target. But "sock" and "socks" can have very different intent in some markets — one browsing, one buying. Check the results pages before merging them.
Google usually treats "socks merino" and "merino socks" as the same query, but the volumes differ and one may be the phrasing people actually use. Merging them is right for planning content and wrong for writing ad copy.
Because a Google Ads export gives you [merino socks], "merino socks" and merino socks as three rows that are one keyword in three match types. For content planning, the brackets are noise.
Only in the ways you tick. Trimming whitespace and collapsing double spaces are always applied because they never change meaning; everything else is a choice, and the report says exactly what was removed.
What people who use the Keyword List Cleaner think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
0 reviews
Newest first
No reviews yet
Be the first to rate the Keyword List Cleaner. It takes half a minute and no account.
Write the first reviewSee your listing the way most people actually see it.
Cross three lists of words into every combination.
See what your file actually weighs once it is compressed.
Single reviews and aggregate ratings as valid JSON-LD.
Break any URL into its parts, query string included.
Check JSON-LD for syntax errors and missing required fields.
Steps, tools and materials as HowTo structured data.
Wrap a keyword list in broad, phrase and exact match syntax.