User Guide Getting Started Help Center Documentation Community Training
Looker
Public Sharing, Importing, and Embedding

Only admins and those with the create_public_looks permission may enable public access for a saved Look. Additionally, Public URLs must be enabled on your instance by an admin, described below.

Giving Public Access to Specific Looks

Public access allows you to share your Look with a broader audience. When public access is enabled on a Look, Looker provides a list of shortened public URLs that are accessible by anyone that you share them with (but are otherwise unguessable). These include:

To enable public access for a saved Look:

If your Looker admin has enabled the Homepage + Spaces Labs feature, Spaces will look different.

Click here to see

The table view with visual thumbnails is set up the same way as in the image above, but for the grid view, you need to hover over a Look’s thumbnail to see the gear menu:

  1. If you are in Development Mode, click Exit Development Mode.
  2. Click the Browse menu and navigate to the space containing your Look.
  3. Click the Look’s gear icon (alternatively, open the Look itself and click the gear in its upper right).
  4. Select Edit Settings.
  5. In the Look Settings window, turn on the Public Access option.
  6. Click Save. This will make the previously greyed out URLs accessible, providing several public URLs that you can copy and use.

Accessing Look Results Through a Public URL

To access data through a public URL, copy and use the URL from the URL section. The 32-character hash that appears in the URL should make it unguessable, so no one will be able to access this data unless you explicitly provide them with this URL. However, anyone who has the URL will be able to access the data without logging in to Looker.

Changing the Format

You can access the data in text, JSON, CSV and HTML formats by changing the format extension. For example:

Default Application of Visualization and Value_Format Settings

Looker applies any value_format settings that you’ve put in place. Looker also applies some visualization settings to your public URLs, causing your data to appear similar to a table chart. Any of the following Plot and Series visualization menu settings for the Look will be applied to the public URLs:

Removing Visualization or value_format Options

The application of visualization options shows up in the URL as the apply_vis=true argument. If you do not want visualization options applied, simply remove the apply_vis=true from the URL.

The application of any value_format settings shows up in the URL as the apply_formatting=true argument. If you do not want value_format settings to be applied, remove the apply_formatting=true from the URL.

The example URL below shows both arguments (scroll to see the full text):

https://mycompany.looker.com/looks/JRJTR5dDYZRVX56vyrmnpKn2HRbnhsMq.txt?apply_formatting=true&apply_vis=true

Public Embedding with iframe Tags

You can embed a Looker chart or table into a website using an HTML iframe tag.

If you would like to embed the chart that is saved with your Look, use the Embed Visualization iframe code.

If you would like to embed the table that is saved with your Look, use the Embed Data Table iframe code.

Importing to Google or Excel Spreadsheets

You can also pull the results of a Looker query directly into a Google spreadsheet or Excel, without having to download it first.

Google Spreadsheets

To import the data into a Google spreadsheet, copy the Google Spreadsheet formula. Paste the formula into the cell of the Google spreadsheet where you would like the upper-left cell of your data to appear, then hit Enter.

Excel

To import the data into Microsoft Excel, you will need to download a .iqy file by completing these steps:

  1. Enable public access for the Look as described above.
  2. Save these settings. The Look Settings option for Excel Web Query File will now show a download link next to it.
  3. Click Download to download the .iqy file to your computer.

Read the instructions below for more information on how to use the .iqy file depending on your version of Excel.

Both Google and Excel will only interact with servers that have valid SSL certificates. If your Looker instance is hosted by Looker this will not be a concern. However, if your Looker instance is self-hosted, your admins will need to have followed these instructions when they initially set up Looker.

Tips and Notes for Google Spreadsheets

There are some things to keep in mind when using Looker in combination with Google spreadsheets:

1. You May Need to Force Data Updates

Google spreadsheets uses a peculiar caching mechanism that makes it hard to predict when data will refresh itself. You can force a data update by adding random parameters to the URL. For example, adding cache_bust=123 to the URL will force an immediate update. If there are no parameters already you’ll need to add a question mark to the end of the URL first, like this:

=ImportXML("https://demo.looker.com/looks/ab1cd2.html?cache_bust=123", "//tr")
                                                     ^^^^^^^^^^^^^^^

If there are some parameters, such as apply_formatting, you’ll need to add an ampersand to the end of the URL first, like this:

=ImportXML("https://demo.looker.com/looks/ab1cd2.html?apply_formatting=true&cache_bust=123", "//tr")
                                                                           ^^^^^^^^^^^^^^^

You may also want to consider a refresh script (see more in this Community topic).

2. The URL Points to the Look

If you overwrite a saved Look, the new format will begin to populate your Google spreadsheet. The URL Looker provides is a reference to the saved Look, not a specific query. This adds a nice layer of flexibility, where you can change the data flowing into a Google spreadsheet. However, you will need to be careful about not accidentally changing a Look on which a spreadsheet relies.

3. Embed Each Looker Query on Its Own Sheet

We’ve found things generally work best if you only import a single Looker query to any given sheet in your Google spreadsheet. Google’s array functions - like VLOOKUP, HLOOKUP, and ARRAYFORMULA - can help you filter, extract, and copy data between sheets. It’s also fairly easy to place query results on separate sheets, then build one main sheet that graphs it all.

Tips and Notes for Microsoft Excel Spreadsheets

There are some things to keep in mind when using Looker in combination with Excel spreadsheets, either on a Mac or Windows:

Mac Office 2011

Follow the instructions below to import and refresh data when using a Mac.

Initial Data Import

  1. Download the .iqy file to a known location on your computer.
  2. From the Data drop-down menu in Excel’s menu bar, select Get External DataRun Saved Query.
  3. From the Enable drop-down menu in the prompt, select Query Files.
  4. Navigate to the saved .iqy file.
  5. Click Get Data.
  6. Select location in spreadsheet to place data and click OK.

Refresh Data

  1. Click on Excel’s Data tab.
  2. Click the Refresh Data button.

Windows Office 2013

Follow the instructions below to import and refresh data when using Windows.

Initial Data Import

  1. Download the .iqy file to a known location on your computer.
  2. Click on the Data tab in Excel.
  3. Click on the Existing Connection button.
  4. Click on Browse for More.
  5. Navigate to the .iqy file.
  6. Click Open.
  7. Select location in spreadsheet to place data.

Refresh Data

  1. Click on Excel’s Data tab.
  2. Click the Refresh Data button.

For Admins: Enabling Public URLs

For any of the above features to work, you will need to enable Public URLs in your Admin settings. Please consider the security implications of this feature before enabling it. Although the URLs that Looker generates can’t be guessed or searched, anyone who receives the URL will be able to see the data. That person could theoretically give it to another that you did not intend, so you should evaluate your level of trust with anyone who receives a public URL.

Top