User Guides / Using Data / Excel

Excel OData Connector

Last updated on 15-Aug-2023 by Jakob Jakobsen Boysen
Jakob Jakobsen Boysen

Platform Lead
boysen@scifeon.com
On this page

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. https://your-company.scifeon.cloud/odata

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}.scifeon.cloud/#/user/profile
  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:

On this page