Exporting Entire Set of Results in Google Analytics

Posted on 2007-07-31
Last Modified: 2013-12-07
The new version of Google Analytics does not allow you to export your entire set of results into a spreadsheet. It caps the limit of results that can be exported to 500 (which is the maximum number of rows that one can see in the interface). The old version allowed you to export the entire set of results.

Does anybody know how to get around this and export the entire set of results from GA?
A couple of people have posted a way to get around this:
But I don't think what they suggested works anymore (it doesn't work for me atleast)
Question by:Igiwwa
    LVL 16

    Expert Comment

    by:Serena Hsi
    Well, if you are exporting it to CSV format, there's Excel vba code out there to splice it all back together into one workbook (one sheet per csv file) or into one sheet (provided that you have Excel 2007 for 1 M rows, or Excel 2003 for 65,536 rows).
    LVL 44

    Accepted Solution

    "Does anybody know how to get around this and export the entire set of results from GA?"

    No, google has deliberately limited you to this limit, you cannot get around it, that is their design -- and the old pages giving ways to get around it are outdated.  Google is out for revenue, remember, just like MS.

    You can try scrolling through the pages, and export from a different starting location, if that doesn't work, then it will not work at all, and that is my understanding of the new google limitations.

    Author Comment

    so what about the hack that is posted on the link I mentioned? was that just a temporary thing?

    Featured Post

    Training Course: Adobe Dreamweaver CC 2015

    Adobe Dreamweaver Creative Cloud is used by web designers and front-end developers and allows you to visualize your site in real-time as you code. This course covers exam objectives for the Adobe Certified Associate (ACA) certification.

    Join & Write a Comment

    Suggested Solutions

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    The viewer will learn how to count occurrences of each item in an array.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now