You can try DeepMiner. It is good for scrapping, rank position, generating long tails and keyword suggestions. You can export the data to document for later analytics. You can find popular keywords that people are searching for. 7 major engines are supported, Google, Yahoo, AOL, Amazon, YouTube, Ask, Bing. It supports multi-threading so it is very very fast scrapper. BTW you must use proxy list if you plan to scrap thousands and thousands of keywords.
Customize the data that LTP is going to fetch with pre-filters like “Suggested Bid” (or Cost per Click [CPC], i.e. the amount of money an advertiser is willing to pay for a click on their AdWords ad that is targeting that specific keyword), “Local Search Volume” (average number of monthly searches for a specific keyword), “Advertiser Competition” (the amount of advertisers competing for a specific keyword) and “Number (of) Words” (very important when you’re trying to find long-tail keywords).
But it’s still very useful for getting search volume data (provided your account still shows this), which is helpful when choosing which of the many keywords you’ve found to focus on (although you should take these estimates with a pinch of salt, they are still useful in indicating the relative search volumes of different keywords, even if the absolute estimates are a little off).
Taking this site as an example, “home working” is a pretty important keyword. I’d love it if I could be at the top of Google for that phrase. However, despite pouring heart, soul and a great many man-hours into creating a useful resource for home workers, I’m not yet anywhere near the first page of Google’s search results. (I’m actually languishing depressingly on the 11th page of results at the time of writing!)
SEMrush is a very useful tool for both researching competitors when starting a site or for growing an established site. I really like to find weaker niche sites that still seem to be ranking for lots of keywords; SEMrush helps me see what they are ranking for and what I can potentially target. You can also see what keywords you’re on the cusp of ranking for with your established site - another very useful feature.
The limit on manual keywords could be higher. I personally wish we could input 10,000 keywords at a time, instead of 200. However, I understand the costs that Long Tail Pro has to maintain each time a new manual keyword is input. Not a deal breaker, I just wish the limit was higher. (To be fair, I don't think most keyword tools have a bulk manual option at all).