You can use Looker Studio to gain insights about your data, and then you can export that data for use in other tools.
To export data from a chart
-
View the report.
-
Hover over the chart that you want to export.
-
Right-click on the chart or click More optionsand then select Export.
-
Enter a name for your export and select an Export Asoption:
- CSVcreates a comma separated text file.
- CSV (Excel)creates a comma separated text file where non-ASCII characters are encoded properly for use in Excel™.
- Google Sheetssends your data directly to Sheets.
-
Select the Keep value formattingoption if you want to retain the number and date formats that are applied in Looker Studio in the exported data.
Can't see the More optionsmenu?
Sometimes other components on the page can obscure the More optionsmenu. If you can edit the report, try increasing the space around your charts.
It's also possible the owner of the report has prevented exporting the data.
How data export works
Data export saves the information from a chart to the file format you select. (Data export doesn't save an image of the chart, just its data.)
Data export is available in view mode. You can export data from only one chart at a time. Only the data available to you in that chart is exported. Any filters, date range controls, or Google Analytics segments are also applied to the exported data.
Export from tables
You can control how much data to export from a table using the Show paginationoption , located in the table's STYLE tab, and the Rows per pageoption, located in the DATA tab.
- When Show paginationis enabled, all data in the table is exported. The number of rows per page has no effect on the amount of data exported.
- When Show paginationis disabled, only the number of rows shown in the table are exported.
Prevent others from exporting data
You can prevent other people from exporting data from your report as part of the report's sharing options. Learn how to stop sharing your reports and data sources .
Limits of exporting data from a chart
You can export up to 750,000 rows of data from a chart.
