Using OData Services with Microsoft Excel

1. Launch Microsoft Excel.
2. Open a blank workbook.
3. Select the Data tab at the top of the screen.
   
4. Select Get Data> “From Other Sources” > “From OData Feed."
   
5. In the OData feed window enter a URL to link to your MVP One Data. Use the format "https://customername.mvpplant.com/odataapi/v2"

Adding a Data Set

Use the following steps to connect to the site that you wish to pull the data from and finally load the data into Excel.

The following OData feed window will open after a URL is selected in the previous steps.

 

1. Select “Basic” on the left side and enter your username and password for your MVP One site. After entering your information select Connect. 

 

2. After connecting to your MVP One site you will be given several data options. These are all the types of MVP data that can be loaded into Excel. Select the data you wish to report on and Select "Load." For example select "Work Orders" and then select "Load."

 

 

After the data has been loaded it will appear in your Excel Worksheet as in the example below.