User Guide Help Center Documentation User Forums Training
Looker
Downloading Data

This page discusses how to download the data or a visualization from a Look or from the Explore page in a variety of formats. Downloading dashboards is discussed separately on the Viewing Dashboards in Looker page.

To download merged results queries, you can save the query to a dashboard and then download the dashboard as a PDF.

To download data from a Look or an Explore page, click the gear dropdown in the upper left and select Download:

File Formats

Data can be downloaded in the following formats:

While choosing your data format for downloading, if you don’t see the HTML or PNG (Image of Visualization) options (for Looks) or the PDF formats (for dashboards), check with your Looker admin about installing PhantomJS for your Looker instance.

Results

In the Results section, choose whether you want visualization settings applied to your data download:

Values

In the Values section, choose how you want the downloaded query results to appear:

Limit

You can choose how much data you want to download as follows:

All Results

When you click Run in a Look or an Explore, Looker checks your permissions and determines whether the complexity of the query and the database dialect will allow the entire query to be downloaded:

If you have the permissions and if Looker determines that your entire query can be downloaded, the All Results option will be available in the Download window. Otherwise, the All Results option will be unavailable and you can instead use the Custom option to specify the maximum number of rows allowed with your permissions.

Even when the All Results option is available, you should still use caution when downloading all results. Some queries are very large, containing thousands or millions of rows, which can overwhelm most spreadsheet programs. If you do not see the All Results option, talk to your Looker Administrator about permissions.

Remove All Sorts from Query

When you select All Results, you may also see the option to Remove all sorts from query. This option prevents sorting on your query before downloading the results. Selecting this option may speed up your download, since sorting a query can be costly to performance for certain database types.

The Remove all sorts from query option is not supported for pivoted results.

Download or Open in Browser

Once you’ve selected your options, you can click the Download button to download a file to your computer, or click Open in Browser to view the file in the browser.

For Admins: Enabling Downloading Data for Your Looker Instance

See important information about CSV files on this page.

Certain downloading options require that the Looker admin has installed PhantomJS for your Looker instance. Read more about installing PhantomJS for rendering image-based data formats when downloading data on this page.

Top