User Guides / Using Data / Excel

Excel OData Connector

Last updated on 15-Aug-2023 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 3.1

If you are not using username and password when signing in to Scifeon, follow this guide:

First a Personal Access Token (PAT) needs to be generated to get access:

  1. Open your user profile: go to https://{your-company}
  2. Click "New PAT" and copy the PAT generated and shown in the dialog (starts with PAT).
  1. Paste the PAT as your password, and use your email as username.

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: