Since the start of the new Google Analytics version (V5) we're unable to export more than 500 rows to for instance Excel. I figured there must be a solution to raise that number to 10.000 or more, so I started coding.
In the old Google Analytics there was the "&limit=10000" parameter that you could add to the export URL. In the new interface you can select the amount of rows below the table:
And after everything is loaded you can export those 500 with the usual export button.
Read more: How to export more than 500 rows in new Google Analytics interface »