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

New to the site? Join for Free and get over $300 of free SEO software.

Once you set up your free account you can comment on our blog, and you are eligible to receive our search engine success SEO newsletter.

Already have an account? Login to share your opinions.

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?

New to the site? Join for Free and get over $300 of free SEO software.

Once you set up your free account you can comment on our blog, and you are eligible to receive our search engine success SEO newsletter.

Already have an account? Login to share your opinions.

  • Over 100 training modules, covering topics like: keyword research, link building, site architecture, website monetization, pay per click ads, tracking results, and more.
  • An exclusive interactive community forum
  • Members only videos and tools
  • Additional bonuses - like data spreadsheets, and money saving tips
We love our customers, but more importantly

Our customers love us!






    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.