Tutorial: Connect Excel with OData

Want your captured content in a spreadsheet that stays current? Connect Excel to a dataset's OData feed with Power Query, and it refreshes on demand — no manual exports.

Available on the Enterprise plan

OData feeds are an Enterprise feature. On other plans, export the dataset to Excel, CSV, or JSON instead. See the pricing page.

Before You Start

  • Microsoft Excel (with Power Query — built into modern Excel).
  • A dataset with some content, and its dataset key.

Steps

  1. Open the dataset's Excel tutorial in the dashboard and copy the OData URL — the key is baked into the URL, so treat the whole thing as a secret.
  2. In Excel, open the Data ribbon and launch Power Query.
Excel's Data ribbon with the Power Query tools — "Get Data" and "From OData feed" visible.
Excel's Data ribbon with the Power Query tools — "Get Data" and "From OData feed" visible.
  1. Choose Get Data → From OData feed and paste the OData URL.
  2. If Excel asks how to authenticate, choose Anonymous — the secret is already in the URL.
  3. Select and load the ContentDetails table.

Excel pulls up to 100 rows per request; Power Query pages through the rest automatically.

Verify the Result

The ContentDetails table appears in Excel with your dataset's content. Use Refresh to pull the latest.

Troubleshooting

  • If there's no URL to copy, generate a dataset key first.
  • If a working URL suddenly stops, the key was rotated — copy the new URL.
Contact us

Still need help?

Tell us what you want your website assistant to answer. We will help you map the right content, controls, and launch path.