12|07|2008 9:34 am EDT
Alexa releases top 1 million sites (free download)
Alexa now provides a free CSV download of their top 1,000,000 sites world wide, updated daily. The company used to charge $2,500 for access to this list via Amazon Web Services.
[via Randolf Jorberg (German)]
Related Posts
6 Comments
Rich Hill
December 7, 2008 @ 9:55 am EDT
The file does not completely load, just the first 65k listings.
I’m using ms Excel.
Frank Michlick
December 7, 2008 @ 10:09 am EDT
Excel is limited to 65k lines, you will have to import it into a database in order to work with all the data.
Rich Hill
December 7, 2008 @ 12:10 pm EDT
Thanks Frank, I should have remembered that.
Barry
December 9, 2008 @ 12:20 am EDT
Hi Frank. Thanks for pointing this out. After I read your post
today, I downloaded the Alexa top million sites file to a dedicated
server and wrote a tool to let me search/parse using my browser.
The data is pretty interesting. In addition to checking on competitors,
it’s possible to get a list of top trafficked domains by domain extension.
For example, I found…
565,805 sites using .com
70,640 sites using .net
48,810 sites using .org
13,135 sites using .info
3939 sites using .biz
3628 sites using .tv
3107 sites using .eu
227 sites using .mobi
If you would like to try the tool out, it’s located at http://www.popularity.info and can search the entire list in about 5-10 seconds.
Thanks again!
Frank Michlick
December 9, 2008 @ 12:22 am EDT
@Barry: Thank you for sharing the stats and providing the search tool.
jp
December 12, 2008 @ 3:34 am EDT
@Rich
Use Excel 2007. The limit in the new excel is 1M, or 2^20.