Difference between revisions of "SmartSimple OData Feed to Excel"
From SmartWiki
(→Using Excel Data Tab) |
(→Using Excel Data Tab) |
||
| Line 14: | Line 14: | ||
[[Image:OData-Excel2.PNG|400px]] | [[Image:OData-Excel2.PNG|400px]] | ||
| − | 5. Select the report (collection) to import. | + | 5. Select the report (collection) to import.<br/> |
[[Image:OData-Excel3.PNG|400px]] | [[Image:OData-Excel3.PNG|400px]] | ||
| − | 6. Click '''Next''' and then '''Finish''' | + | 6. Click '''Next''' and then '''Finish'''<br/> |
[[Image:OData-Excel4a.PNG|400px]] | [[Image:OData-Excel4a.PNG|400px]] | ||
| Line 24: | Line 24: | ||
[[Image:OData-Excel4b.PNG|400px]] | [[Image:OData-Excel4b.PNG|400px]] | ||
| − | 7. Data from report will be imported into Excel. | + | 7. Data from report will be imported into Excel.<br/> |
| + | |||
| + | [[Image:OData-Excel5.PNG|400px]] | ||
=See Also= | =See Also= | ||
Revision as of 12:39, 22 May 2018
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
4. From the dialog box 'Data Connection Wizard , enter the endpoint link and the credentials if using the private endpoint link.
5. Select the report (collection) to import.
6. Click Next and then Finish
7. Data from report will be imported into Excel.
