Connect your Excel spreadsheet to Geckoboard

Depending on where your Excel .xlsx file is located, choose from the following options for instructions on how to connect it to Geckoboard:

Connect your Excel .xlsx file uploaded to Google Drive:

  1. Add a new Excel spreadsheet widget from your dashboard.
  2. If you haven’t done so already, create a connection to link your Google Drive account with Geckoboard. From the Choose File menu. Once connected, select the spreadsheet you want to connect from the list.connect your chosen cloud-based service directly from the Spreadsheets panel

    Tip

    After connecting to your Google Drive account, you may see the 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.

  3. And that’s it! For guides to creating spreadsheet dashboard widgets, select from the following visualization types:

Connect your Excel .xlsx file from Dropbox:

  1. Add a new Excel spreadsheet widget from your dashboard.
  2. From the Choose File menu, click on the Dropbox icon.connect your chosen cloud-based service directly from the Spreadsheets panel
  3. If you haven’t done so already, create a connection to link your Dropbox account with Geckoboard.
  4. Once connected, select the file you want to connect from the list.
  5. And that’s it! For guides to creating spreadsheet dashboard widgets, select from the following visualization types:

Tip

Install the Dropbox desktop app and you'll be able to automatically sync edits to your Excel spreadsheet file with Geckoboard, just so long as the file name doesn't change.

Connect your Excel .xls file from OneDrive for Business:

  1. Add a new Excel spreadsheet widget from your dashboard.
  2. From the Choose File menu, click on the OneDrive for Business icon. connect your chosen cloud-based service directly from the Spreadsheets panel
  3. If you haven’t done so already, create a connection to link your OneDrive for Business account with Geckoboard.
  4. Once connected, search for the spreadsheet you want to connect. For guides to creating spreadsheet dashboard widgets, select from the following visualization types:

Link your Excel file to Geckoboard using our Get Direct Link tool:

  1. Using Share settings, make sure access is set to Anyone with the link can edit.
  2. Click Copy Link to copy the link to your clipboard. You'll need this copied link for our Get Direct Link tool.Copy link on Sharepoint
  3. Paste the copied link into our Get Direct Link tool and click the Get direct link button to copy a new link that you'll need to use in Geckoboard
  4. Switch to Geckoboard and add a new Excel spreadsheet widget from your dashboard.
  5. In the Link to file field, paste the copied link to your hosted file. Our integration will do the rest.Choose your Excel file from the direct link field
  6. And that’s it! You're now ready to prepare a visualization using your spreadsheet data.
  7. And that’s it! Each time you make changes to your hosted .xlsx spreadsheet in Sharepoint, those changes will automatically sync with Geckoboard through the generated link. You'll be able to see your changes on your dashboard when the widget refreshes (every 15 minutes).

    For guides to creating spreadsheet dashboard widgets, select from the following visualization types:

Link your Excel file to Geckoboard using our Get Direct Link tool:

  1. If you haven't already, you'll need to generate a direct download link in Excel. Open the file you want to share, then select Share.
  2. In the the Send Link window that appears, make sure access is set to Anyone with the link can edit.
  3. Click Copy Link to copy the link to your clipboard. You'll need this copied link for our Get Direct Link tool.Copy link on Sharepoint
  4. Paste the copied link into our Get Direct Link tool and click the Get direct link button to copy a new link that you'll need to use in Geckoboard
  5. Switch to Geckoboard and add a new Excel spreadsheet widget from your dashboard.
  6. In the Link to file field, paste the copied link to your hosted file. Our integration will do the rest.Choose your Excel file from the direct link field
  7. And that’s it! Each time you make changes to your hosted .xlsx spreadsheet in Sharepoint, those changes will automatically sync with Geckoboard through the generated link. You'll be able to see your changes on your dashboard when the widget refreshes (every 15 minutes).

    For guides to creating spreadsheet dashboard widgets, select from the following visualization types:

We don’t allow customers to upload a spreadsheet file directly from their desktop. This is because Geckoboard needs to periodically access your spreadsheet in order to push any changes to dashboard widgets powered by it.

Instead we recommend uploading your file to one of the cloud-based services listed above and following the instructions. If you don’t already have an account with one of these services, you may need to create it now in order to use them.

Note

The file size limit for uploaded spreadsheets is 5 MB.

If you're seeing the error message WARNING: This worksheet is too large to import and your .xlsx file is under the 5 MB upload limit, 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.

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.