Alexa 1 Million Top-Sites CSV (worth 2500$) download for free

December 7, 2008

Alexa seriously tries do defend Google’s recent data publishing attack (releasing Trends for Websites and Insights for Search) and stumbled across this ad on alexa.com:

The linked download is quite impressive. Not only the Top 500 (or country-based Top 100), but the top 1 million trafficked sites by Alexa ranking is now available for download (top-1m.csv.zip 9,5 MB Zipfile, ausgepackt 21,4 MB) and it appears to be recent data too (November 24th says the file-timestamp). This list would set you back 2500 US$ via Amazon’s Web Services and unlucky you are only if you recently bought it or you work with MS Excel 2003 where you’re limited to the first 65536 Entries…

Some observations about the content: Subdomains from wordpress.com, blogspot.com, blog.br, blogs.com and others are now counted seperately. While this might be old news to some I just observed it today as well as the fact that they do also seperately track it when your folder-structure contains a ~username (old UNIX standard used at some universities) or my.domain.tld/user/name. This also causes some errors, assome Domains using Feedburner MyBrand appear in the stats with their feeds.domain.tld/~r/ redirect URLs.

Beside these minor flaws just a sincere Thank You to the Alexa Team for this early christmas present 🙂

Also see my original german post about this christmas present from Alexa.

6 responses to Alexa 1 Million Top-Sites CSV (worth 2500$) download for free

  1. Thanks for making everyone aware of this! I learned about your post today via DomainNameNews.com.

    I just finished writing an browser based tool to help me search the data (since my version of Excel was only able to open the first 65,000 records). Instead of manually reviewing the list, I can now enter in a keyword phrase to show all sites in the
    Alexa top million which contain this phrase.

    The data is very interesting. In addition to checking on competitors,
    it’s possible to get a list of top trafficked domains by domain extension
    or country code.

    For example, I found…

    565,805 .com sites
    70,640 .net sites
    48,810 .org sites
    54,309 .de sites
    3,599 .za sites

    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.

  2. hey Barry – THIS IS COOL! Thanks for that tool…

  3. Recently Alexa added new features in their Top http://www.alexa.com/data/details/main?url=www.fortunehotels.in Sites Lists. These features have come to be extremeley well recieved by the web professionals.

  4. thank you..

Trackbacks and Pingbacks:

  1. Weihnachtsgeschenke von Alexa - 1 Million Top-Sites CSV for free » Das Randolf Jorberg Blog - December 7, 2008

    […] read my english translation on randolf.jorberg.com […]

  2. Download Top 1 Million Websites from Alexa & Quantcast | Webanalyticsbook - Web Analytics - December 14, 2008

    […] 10k…, while Alexa charged a whopping $2500k for pretty much the same data. Today I saw over a Randolph’s blog, that Alexa just opened up their database and offered the Alexa top million websites for free. […]