Export data from a chart

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

  1. View the report.

  2. Hover over the chart that you want to export.

  3. Right-click on the chart or clickMore options.and select Export.

  4. 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.
  5. 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 theMore options.menu?

Sometimes other components on the page can obscure theMore options.menu. 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 (see below).

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 more .

Limits of exporting data from a chart

You can export up to 750,000 rows of data from a chart.

Embed a report

Create a Mobile Website
View Site in Mobile | Classic
Share by: