Connect your Excel Spreadsheet stored locally

  1. Save your Excel file as .xlsx, if it isn't already.
  2. Click the Share button in the top right hand corner of your screen.
  3. If your file has already been saved to Microsoft 365, OneDrive, or Sharepoint, skip to the next step. Otherwise, make your choice from from the list of Places and click Save.Choose which cloud service to share your Excel file
  4. From the Share settings window, make sure access is set to Anyone with the link can edit.
  5. 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
  6. 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.
  7. Switch to Geckoboard, Add a new Excel spreadsheet widget from your dashboard.
  8. From the Choose File menu, click on the link icon and paste your sharing link URL in the Link to file field.Choose your Excel file from the direct link field 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.
  9. 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:
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.