User / Excel

Excel OData Connector

Last updated on 22-Feb-2021 by Jakob Jakobsen Boysen
Jakob Jakobsen Boysen

Platform Lead

Scifeon offers an OData interface for interacting with data from Scifeon in other applications, e.g. Excel. A few steps is needed in order to retrieve data from Scifeon in Excel:

Step 1

Select Data > Get Data > From Other Soruces > From OData Feed:

Step 2

Enter the Scifeon OData URL for your company, e.g.

Step 3

In the next window, select "Basic" on the left, and enter your username and password for Scifeon and click "Connect":

Step 4

Click "Connect" and see the following Navigator pane, where all kinds of data can be found. Find the relevant data, select it, and click "Load":

Step 5

After you've clicked "Load" you will see a new sheet in the Excel workbook containing the data from Scifeon: