Google Lets Users Download More Data from Search Console, Including Data Behind the Charts
https://webmasters.googleblog.comYou’ll now be able to download the complete information you see in almost all Search Console reports (instead of just specific table views). When exporting data from a report, for example AMP status, you’ll now be able to export the data behind the charts, not only the details table (as previously). This means that in addition to the list of issues and their affected pages, you’ll also see a daily breakdown of your pages, their status, and impressions received by them on Google Search results. If you are exporting data from a specific drill-down view, you can see the details describing this view in the exported file.
If you choose Google Sheets or Excel (a new feature) you’ll get a spreadsheet with two tabs, and if you choose to download as csv, you’ll get a zip file with two csv files. These changes are live as of now, so you can try it out right now.
Before you get all exicited they still cap it at 1000 rows, if you need more you can look at things like Analytics Edge, here is a good post on the topic by Glenn Gabe.