This tutorial is outdated, please follow this newer one.
Connect on portal.azure.com
From here, go to “Cost management + Billing”
Then, go to the “cost analysis” tab
To get the location of the instances, you have to select “CostByResource” and group by Resource, for the 12 last months.
You can then download the table as an Excel, that should look like this :