Inventory on homepage > Manage Inventory
From here a new screen appears that is shown below:
Select any Item here from the list just by Single clicking on that Item, which again opens a pop-up with location-wise availability of items as shown below:
The records visible on this screen can be exported to excel using a down arrow button on the top right of the pop-up.