How to link to an Excel Spreadsheet stored on your computer locally

To link your Excel spreadsheet file on your computer to Geckoboard, follow these steps:

  1. Make sure your file is an Excel .xlsx file, not a .csv.
  2. Open your Excel file and click the Share button in the top right hand corner of your screen.share button on Sharepoint
  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 Geckoboard's Direct Link Tool
  7. Switch to Geckoboard and hover your cursor over an empty area of your dashboard and click the + button.

    Alternatively, click Add widget in the top right of your dashboard.
  8. You'll see a scrollable list of data sources. Click Excel.
  9. In Geckoboard, 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
  10. And that’s it! You're now ready to prepare a visualization using your spreadsheet data.

    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).

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.

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