Display data from pivot tables on your dashboards

Pivot tables are powerful functions available both in Excel and Google Sheets. In this article, we'll explain how to get them to work with Geckoboard.

What is a pivot table?

A pivot table is a table that summarizes data from another table and is made by applying an operation such as sorting, averaging, or summing to data in the first table, typically including grouping of the data.

You can use pivot tables to narrow down a large data set or see relationships between data points.

You can also use Pivot Tables to restructure your data. Below, the invoice number is shown in the first column with a column for each fruit type. Each cell then shows the number of each type in each order.example of a pivot table

Take a look at the Google Sheet used in this example.

You can find a lot more help for pivot tables in Google Sheets support center.

For Excel

Geckoboard will automatically interpret pivot tables from your Excel spreadsheets – no extra work needed.

For Google Sheets

Currently, Geckoboard isn't able to retrieve pivot table data from a Google Sheet without using ImportRange to reproduce the pivot table in a new sheet.

  1. Navigate to the spreadsheet that contains the pivot table.
  2. Add a new sheet.
  3. Use ImportRange on this new sheet to reproduce the pivot table.

    For this, you'd type IMPORTRANGE(range_string), where range_string is the entire range of your pivot table, in cell A1. This will import all the data in your pivot table.
  4. Now when you connect this spreadsheet to Geckoboard you can use this new sheet to start building visualizations from the data.

Get help

If you need help using ImportRange, check out the ImportRange article or get in touch.

Using Spreadsheets as part of your free Geckoboard account? Unlock all our data sources when you try Pro for free.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Heather

    USA