To export more than 5,000 rows of data from Google Analytics, use the Google Analytics API. Open the report that is to be exported. Analytics will export the report as it is displayed on the screen. Select one of the export formats: CSV. TSV. TSV for Excel. Lastly, Click Export.