Skip to main content

Get Data into Excel

The Virtual Data Platform Office Add-In enables you to retrieve data via Virtual Data Platform and interact with it in Excel. Using the Add-In, you can work with your various functions and models directly in Excel by simply using a Function. Additionally, a wizard supports you in configuring your requests and selecting your parameters. The VDP Add-In can be used in Excel Desktop as well as in Office online.

Load the Add-In into Excel​

To load the Add-In initially go to tab 'Insert' and select 'My Add-Ins' in the Ribbon bar.

My Add-Ins

In case you do not find it, the 'My Add-Ins Menu' can also be located in tab 'Home' of the Ribbon bar on the very right corner.

In the 'Office Add-Ins' dialog select the 'ADMIN MANAGED' section.

Admin Managed

note

You may not see the VDP Add-In yet, but a message, that there are no Add-Ins currently available. This will disappear after the next step.

Click on 'Refresh' in the upper right corner.

Refresh

Now you can select the Add-In 'VDP Wizard'

Add-Ins Refreshed

and click 'Add' to load the Add-In.

Add Add-In

If the Add-In was loaded successfully, you can see an additional tab in the Ribbon bar.

Add-In Ribbon

Now you can start to use the VDP Add-In. Therefore, click 'Open Wizard' on the upper left of the ribbon bar to open the VDP Wizard in the taskpane. After clicking the login button in the taskpane to connect to VDP, you can start exploring all the Virtual Datasets available for you.

note

The pop-up dialog window is used to connect you to the platform and may ask you to enter your credentials. Enter or select the username and password of the account, you are using to connect to VDP.

Insert a Formula to Load Data​

The Excel formula used to retrieve data from Virtual Data Platform is the following:

=VDP.GetData("WEB", "GDP")

In this case, we use the simple Function 'GDP' we have defined in the 'Getting started' section within Configure the First Function. Since we have not configured specific Parameters, entering 'WEB' as Category and 'GDP' as Function is sufficient. Copy this into an Excel cell and execute it via 'Enter'. The GDP data will be loaded and displayed after a few seconds.