In Studio Pro, make sure to choose OData 3 as the OData version
In Excel, you go to Data > Get Data > From Other Sources > From OData Feed
There you connect to the service by copy-pasting the URL.
Yes, with OData 3 it works. But what is the purpose of the XML-file and how do I use it in Excel? :)