OData for Excel Online
Get a RESTful OData API server for your Excel Online data and make it available to clients in just a few minutes with Skyvia!
Expose Excel Online Data via OData
While Excel Online provides its own web API for data access, using a widely accepted OData standard for data access over the Internet is preferred in many cases. OData is supported in a number of data-related applications and technologies, and it makes consuming real-time Excel Online data or integrating them with other applications much easier.
Make your Excel Online data readily available in BI tools, web and mobile applications, integration interfaces, etc. via Excel Online OData endpoints. Get OData API layer with no coding, in just a few minutes!
Skyvia supports all OData versions (OData 2.0, OData 4.0)
Share Data Easily and Securely
If you need to provide access to your Excel Online data to your colleagues, clients, or other people, Skyvia Connect can offer several advantages.
Learn more about connect
Access to Live Data
Skyvia Connect provides bi-directional access to live Excel Online data in real time.
Detailed Logging
Monitor all access events for an endpoint. See all the request details: users, IPs, queries, etc.
Additional Security Layer
Create users and define passwords in the endpoint itself — no need to give your Excel Online credentials. Limit access by IP if needed.
Data Can Be Shared Partially
Expose only the Excel Online tables and columns you need to share. Other tables and columns remain unavailable via the endpoint.
How It Works
Connect
Create a connection to your Excel Online.
Configure Endpoint
Select entities and fields to expose in convenient GUI. If necessary, create user accounts and specify IPs to allow access from.
Share the Link
Simply copy the result HTTPS link to your endpoint and share it with clients or paste to your OData consumer applications.
Share Excel Online data easily