New Keyword List Cleaner Tool

Feb 26th

With many companies offering free keyword research tools I recently created a keyword list cleaner that can be used to help you format keyword data into a usable format. Use the SEO Book keyword list cleaner, grab the source code if you like it, or read here for background on the tool.

Published: February 26, 2007

Comments

samlowry
March 5, 2007 - 10:24pm

It's incorrect way to remove that numbers. For example, numbers very important in keywords like "web 2.0" or "firefox 3.0" :))

Usually searches number's row separated by tabs - you can use it for removing searches nums.

March 6, 2007 - 2:04am

Hello Sam
Number stripping is an OPTION...not something that is required for people to do to use this tool. Most keywords do not have numbers in them.

Alex
March 6, 2007 - 11:57am

Can you sort the keyword phrases into the correct gramatical order? For example: To reorder the keyword phrase when the overture suggestion tool brings back the keywords in alphanumeric order which don't make sense ie '16803 dryer machine repair washer' should read 16803 washer dryer machine repair'

Jacob Minett
February 26, 2007 - 3:28pm

After I clean my list with your tool, what about match type (for PPC)? Is their a tool that will take my new clean list and generate phrase and exact match type for each keyword?

Garrett
February 26, 2007 - 5:07pm

Jacob:

If your kw list is less than 65,000 rows, just use Excel to quickly create phrase and exact match versions of your list. You can concatenate "" or [] to your keywords in a few seconds w/ Excel.

February 26, 2007 - 6:43pm

Great tool Aaron. Thanks so much for sharing it!
I just blogged it to all my readers.

There's another FREE keyword tool that just came out that would be the PERFECT companion to your tool for people looking for additional sources to grab targeted keyword lists. I blogged about it last week. Here's an over view.

"...Immediately generate huge sortable keyword lists from any web page you're visiting - on the FLY! Basically, using this FREE script, you can use the Google keyword tool to analyze any page that you're currently visiting to extract and generate thematically related keywords, together with their prices in the Adwords system, sort a variety of meaningful ways, use a word cloud to do more KW research and output everything in a well formatted html table, which can be easily imported to any other application!"

NEW - Totally Hot Free Keyword Tool!

You really need to watch the video to understand how powerful it is.

So if you use that tool 1st, then your keyword cleaner it could be pretty dynamic and save folks a lot of time.

Steaprok
February 27, 2007 - 4:21am

Aaron-

I sadly never leave comments , but always use your tools and site for all of my research. You literally answer my prayers, thanks man. REALLY! You saved me,I had a 50,000 KW list and couldnt process it w/o your cleaner.

Steaprok
Manny Marrero
Subliminal Pixels

February 27, 2007 - 4:34am

Hi Jacob
I have a keyword list generator which allows you to wrap output phrases in quotes or boxes.

Hi Linda
The guys who made that tool also pitched it to me. It is pretty neat.

samlowry
March 4, 2007 - 7:14am

What for stripping numbers? Useless option, because SE interpret [A-Za-z0-9_]+ (and local letters) as words.

March 4, 2007 - 11:06pm

Why not give an option to strip numbers? Is a keyword campaign full of keywords with search volume estimates in it a keyword list of any value?

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Gain a Competitive Advantage Today

Your top competitors have been investing into their marketing strategy for years.

Now you can know exactly where they rank, pick off their best keywords, and track new opportunities as they emerge.

Explore the ranking profile of your competitors in Google and Bing today using SEMrush.

Enter a competing URL below to quickly gain access to their organic & paid search performance history - for free.

See where they rank & beat them!

  • Comprehensive competitive data: research performance across organic search, AdWords, Bing ads, video, display ads, and more.
  • Compare Across Channels: use someone's AdWords strategy to drive your SEO growth, or use their SEO strategy to invest in paid search.
  • Global footprint: Tracks Google results for 120+ million keywords in many languages across 28 markets
  • Historical data: since 2009, before Panda and Penguin existed, so you can look for historical penalties and other potential ranking issues.
  • Risk-free: Free trial & low price.
Your competitors, are researching your site

Find New Opportunities Today






    Email Address
    Pick a Username
    Yes, please send me "7 Days to SEO Success" mini-course (a $57 value) for free.

    Learn More

    We value your privacy. We will not rent or sell your email address.