SmartSimple OData Feed to Excel

Revision as of 12:19, 22 May 2018 by Lalaine Songalia (talk | contribs) (Using Excel Data Tab)

Revision as of 12:19, 22 May 2018 by Lalaine Songalia (talk | contribs) (Using Excel Data Tab)

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
2. Click From Other Sources
3. Choose From OData Feed from the dropdown list

OData-Excel1.PNG

4.

See Also