Don't miss a single post about Developing your Niche Store or Website! Subscribe today and start Making Money!
February 21, 2008
Sorry, I don’t have any tips … but I’m hoping that you do!
Calling all Excel spreadsheet pros!
After doing keyword searches at either WordTracker or Wordze, you will likely end up with a rather large list of all those wonderful long-tail keywords. But is there an easy way to separate out keyword-specific keyword phrases without doing massive amounts of cut-and-paste? 
Working within an excel spreadsheet, I’m sure you can do some type of “sort” to make this a simple process … but I sure can’t figure it out. I’d like to be able to pull out all the keyword phrases for a particular brand/manufacturer name and put them onto a separate sheet. If there was an easy way to do this with the correctly spelled names, then I could just go back and manually pick out the misspelled names and add them to the new sheet.
Anybody care to share how they do this? Somebody (is it you?!) most likely has a very easy method of doing this that the rest of us would appreciate knowing about. 
Thanks!
Cindy
3 Responses to “Tips On Sorting Through A Huge Keyword List”
Got something to say?
Posting tweet...
Use a filter to isolate keyterms that contain the brand. The menu is data->filter->autofilter.
Set the custom filter criteria to something like contains “sony” or whatever word you want.
Great tip Freeagent
Thanks
Not directly related but I use ebay Marketplace Research to download a few hundred to several thousand auction titles when I am researching niches. I do this to get ideas for keywords that I might have missed. I then paste all of the auction titles into Notelab Pro and then click “Text Statistics”. Within about a second I can see exactly how many times each word was used in the auction titles.
The nice thing is that it picks up every word regardless of their postion in the title, so it gives some really good, thought provoking ideas.
This also works when writing content because it gives the number of times each word is used AND the percentage of the total for each word.
Sometimes it’s tough to think like the people who are running auctions…….