Download data from an OData Service into Excel Directly

[former_member1321]

Hi All.

This is my first blog post on SCN. I don't know if the members already know of this functionality but I was quite fascinated by this so I decided to share it anyway 🙂 .

I found this while playing around with MS Excel. It reads the data of an OData service directly into an Excel file (basically the Get_EntitySet data). Just follow the steps below:

==> Open MS Excel and create a blank workbook.

==> Click on the Data tab at the top and select From Other Sources->From OData Data Feed

 



==> Specify the link to the OData service in the next pop-up. In this case I am using the publically availaible Northwind OData Service. You can also take up your own OData service by providing necessary authentication details in the same popup. Then click Next



==> The wizard will fetch all the Entity Sets contained in the OData service. Select the one which you want to download to Excel. I selected PersonDetails here.



==> Click Finish and you will be asked for how you want the data to be displayed in Excel.



==> Select table and click OK. Wait for some time while your data is downloaded.



The data from the OData service is now availaible in Excel 🙂

This functionality also works fine for HANA Exposed OData services (xsodata).

Hope you all like this post.