Connect your Excel spreadsheet using OneDrive for Business

Important note

If you're experiencing problems connecting your spreadsheet using OneDrive, please follow our guide to generate a direct link that Geckoboard can read.

Our Spreadsheets integration is a quick and easy way to transform your Excel files into beautiful dashboards. In this article, you'll connect and push data from your Excel spreadsheet hosted in OneDrive for Business.

Before you start

If your spreadsheet data has been imported from a third-party service (e.g. Google Analytics, Salesforce, Zendesk, etc.), check if we have a pre-built integration for it. They are by far the easiest way to quickly get your data onto your dashboards, with each integration containing a comprehensive list of widgets with predefined KPIs, making things even easier for you.

Alternatively, if you’re looking for complete control over how your data is displayed, you can use our Datasets API to send data from a database or third-party service to your dashboards.

To connect your Excel file from OneDrive for Business, follow these steps.

  1. Click Add widget, located in the top right of your dashboard.
  2. You'll see a scrollable list of Integrations. Click Spreadsheets.
  3. From the Choose File menu, click on the OneDrive icon.

    Important notes

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

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

    Choose your Excel file from your OneDrive for Business account
  4. If you haven’t done so already, create a connection to link your OneDrive for Business account with Geckoboard.

    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.

  5. And that’s it! You're now ready to prepare a visualization using your spreadsheet data.
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

    Kirby

    USA
  • Heather Customer Success Avatar

    Heather

    USA