Excel Add-In for OneDrive

Build 20.0.7695

Data Model

The add-in models the OneDrive API as relational tables. Any changes to the remote data are immediately reflected in your queries; the table definitions are dynamically retrieved. When you connect, the add-in connects to OneDrive and gets the list of tables and the metadata for the tables by calling the appropriate Web services.

Key Features

  • The add-in models OneDrive entities like Files and Folders as relational views, allowing you to write SQL to query OneDrive data.
  • Stored procedures allow you to execute operations to OneDrive, including retrieving the access token and keeping it refreshed in OAuth 2.0.
  • Live connectivity to these objects means any changes to your OneDrive account are immediately reflected when using the add-in.


Views shows definitions from a sample OneDrive site. The actual data model will be obtained dynamically based on your user credentials and site.

Stored Procedures

Stored Procedures are function-like interfaces to OneDrive. They can be used to search, update and modify information in OneDrive.

Collaborative Query Processing

The add-in offloads as much of the SELECT statement processing as possible to OneDrive and then processes the rest of the query in memory (client-side).

This is done through the SupportEnhancedSQL property, which is enabled by default. You can disable it in order to turn off client-side execution. This will return the information unfiltered, so the results might be incorrect.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695