Display data from pivot tables in Geckoboard

Geckoboard automatically interprets pivot tables from your Excel spreadsheets. For Google Sheets, you can retrieve pivot table data by using ImportRange to reproduce the pivot table in a new sheet.

  1. Add a new sheet to the Google Sheet that contains the pivot table. For reference, see our example.
  2. 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.
  3. Now when you connect this Google Sheet to Geckoboard you can use this new sheet to start building visualizations from the data.

If you need help using pivot tables in Google Sheets, see Google Sheets' support center 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.