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.
Keyword everywhere is another useful keyword tool. You can install it on either Firefox or Google Chrome. The tool will be able to show you competition data, cost per click, and Google Keyword search volume of multiple websites and keywords. This free extension can help you to save a lot of time. It can assist you to find long-tail phrases including their precise search volume, competition data, and CPC.