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.

Did this answer your question?