The CData Excel Add-In for Microsoft Dynamics 365 models Microsoft Dynamics 365 entities in relational Tables, Views, and Stored Procedures. The table definitions are dynamically obtained from the OData service you connect to. Any changes in the metadata, such as added or removed columns or changes in data type, can be loaded by reconnecting.
Views describes the available views. Views are statically defined to model PicklistAttributeMetadata, MultiPicklistAttributeMetadata and more.
Stored Procedures are function-like interfaces to the data source. They can be used to perform additional operations that fall outside of the standard CRUD model such as retrieving an OAuth access token.