Troubleshooting the Spreadsheets data source

If you’re having trouble with our Spreadsheets data source, learn more about common issues and how to troubleshoot.

This worksheet is too large to import

If you're seeing the error message WARNING: This worksheet is too large to import, first check to see if the actual size of your .xlsx file exceeds the 5MB limit. If it's under 5MB, then it's likely the compressed .xml files contained in it exceed the file limit.

Please see our guide to finding out why your worksheet file exceeds the limit. If you are not able to reduce the file of your spreadsheet, you may want to consider using Google Sheets’ ImportRange function.

Error fetching the list of spreadsheets

After connecting to your Google Drive account, you may see the error message: there was an error fetching the list of spreadsheets. If so, you need to allow Google Drive permission to share data with Geckoboard.

To do this, open the Google Apps control panel and navigate to Apps > Google Apps > Settings for Drive, and make sure "Allow users to install Google Drive apps" in the "Data Access" menu is enabled.

Excel file not appearing in OneDrive

Ensure that your file resides in the main OneDrive folder. Files placed within additional folders might not display.

Additionally, for OneDrive personal accounts, when using Share settings, make sure access is set to Anyone with the link can edit.

Also, only the .xlsx file extension is supported for Excel files. .xls files won't show in your folder.

X-Axis dates not display correctly on charts

This often occurs when X-Axis dates are being calculated by a formula e.g. =today() or when they're coming from another sheet =Sales!A1.

Unfortunately our Spreadsheets data source cannot display these dates due to a limitation of the Google Sheets API. When the data comes through the API into Geckoboard, it's no longer recognized as a date.

We recommend to create another column with manually entered dates that Geckoboard will use to populate your charts.

  1. In the example below, the dates in Column A are coming from another Google Sheet. This means our Spreadsheets data source isn't able to display these dates in the X-Axis of the chart.FAQ_X-axis_dates_don%27t_display
  2. To fix this, copy the dates from Column A, then go to Edit > Paste Special > Paste Values Only to paste them into another column.
  3. To format these as dates, go to Format > Number > Date. Alternatively, you can manually enter the dates.
  4. In Geckoboard, set your Spreadsheets widget to use this new column of dates as the X-Axis of your chart.FAQ_X-Axis_dates_display_answer

Manually refresh Spreadsheets widgets

Yes you can force the values to update on the edit widget screen's breadcrumbs menu. Click the downward arrow beside the name of your widget.Edit widget breadcrumbs

Deleted spreadsheet on Google Drive still powering widgets

When you delete a spreadsheet from your Google Drive account, it will automatically be placed inside your Trash folder. Items in your Trash folder are still, in effect, regarded as active documents until emptied. To ensure your spreadsheet will no longer power your widget, go to your Trash folder and manually delete the spreadsheet.

Get help

If you're still having trouble with errors on your Spreadsheets, get in touch.

Cannot read property 'offsetWidth' of undefined

This error will occur if you only have one row of data to select from. Check if you have selected the Use row 1 as header option. Keep in mind that values must be consecutive to use them within a widget.use first selection cell as header

Pivot Table sheet is empty

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

Please check our guide on how to workaround this

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