XML web site return into Excel

Hi,

I'm not sure what I'm doing at the moment. XML importing is all brand new to me, so I may be entirely off topic.

Two questions:

1. Am I doing this the right way?
2. Why am I only getting partial results?

https://geocode.maps.co/search?q=555...pi_key=PRIVATE API KEY&format=xml

This is an address-to-lat/long request through OpenStreetMaps. I enter it into a browser address bar (with my private API key), and what's returned is an XML output, I guess. I'm not familiar with XML. In the link, it returns the lat/long of a Barnes & Noble bookstore in New York City - it's just an example. Take note that it returns a lot of data.

XML Test.png

Regarding question 1, I have a thousand of these to do. And I'm choosing OpenStreetMaps to convert addresses to lat/long because it actually returns lat/long in a format that I can keep on-hand, unlike Google Maps who do not share that data. So, with Google, each time I want to see the lat/long of an address, Google Maps gets the info again which will eventually become expensive whereas with OpenStreetMaps I only need to get the lat/long once and I can keep that info such as in the above screenshot.

Ok, so I have a thousand of these to do. I'm trying to use the method presented at this site: https://geocode.maps.co/ where I URL-query an address every second, get the response into Excel automatically somehow and repeat. By the way, the above Barnes & Noble example is the example from that maps.co link.

Am I doing this the right way one at a time with some sort of macro that gets XML into Excel somehow?

And second question, when in Excel I choose Data > Get Data > From Other Sources > From Web, it only imports part of the XML data - like the first third of the data, and that's it. That's why I said to take note of the amount of data it returns. Most of it is not imported into Excel, including the lat/long info.

Why?

Thanks.