How To Export More Than 5000 Rows in Google Analytics

  • Share on Google Plus
  • Share on Linkedin

Export 5000 rows in Google Analytics dashboard - Screen Shot 2013-04-10 at 16.38.16

You CAN NO LONGER display and export more than 5000 rows in Google Analytics. You used to be able to, using the hack I list below:

When you select 5000 rows you will have a URL like this

…once you could just change that last number from 5000 at the end of that URL to 50000 (add an extra zero) and hey presto – you saw much more in the dashboard, too.

The MAXIMUM amount of rows you can see in the Dashboard in 2015 is 5000 rows, whichever number you specify at the end of that URL.


Google Sheet add-on to download data in multiple blocks of 10K:

Free add-in for Excel which will download up to a million rows:

Real Time Analytics

I highly recommend CLICKY Real Time Web Analytics for real time website visitor analysis. Easy to install, Clicky is also easier to use than Google Analytics. Disclosure: I am a customer and affiliate.

Find Out More