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.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.