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

Step 1

Connect

Create a connection to your Excel Online.

Step 2

Configure Endpoint

Select entities and fields to expose in convenient GUI. If necessary, create user accounts and specify IPs to allow access from.

Step 3

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