View source for SmartSimple OData Feed to Excel

=Overview=
There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query.
Example below shows how to pull OData feed via the Excel Data Tab.

=Using Excel Data Tab=
1. Go to the '''Data''' tab<br/>
2. Click '''From Other Sources'''<br/>
3. Choose '''From OData Feed''' from the dropdown list

[[Image:OData-Excel1.PNG|400px]]

4. From the dialog box ''''Data Connection Wizard ''', enter the endpoint link and the credentials if using the private endpoint link.

[[Image:OData-Excel2.PNG|400px]]

5. Select the report (collection) to import.

[[Image:OData-Excel3.PNG|400px]]

6. Click '''Next''' and then '''Finish'''

[[Image:OData-Excel4a.PNG|400px]]

[[Image:OData-Excel4b.PNG|400px]]

7. Data from report will be imported into Excel. 

[[Image:OData-Excel5.PNG|400px]]

=Troubleshooting=
<!--see ticket 69942 - OData with https gives error-->
1. TLS1.2 security protocol should be enabled on your local machines before you can import OData with HTTPS link. By default, MS Office do not accept this protocol by default.

=See Also=
* [[Reports]]
* [[Odata Overview|OData Overview]]
* [[OData Connector]]
* [[SmartSimple OData Feed to SQL Server Database]]