Before we talk API I wanted to make sure you are aware of the export function in Method. In the GUI you can export the data you are looking for in csv format and easilly open it in Excel.
However, since you mentioned API you are probably looking for more of a real-time interface. https://www.methodintegration.com/MethodAPI/Service.asmx?op=MethodAPITableListV2 . If you fill in the form you will get the XML reponse
The Method API is based on the SOAP protocol which primari ly uses HTTP POST for interaction. If you pasted the URL you provided in a browser you will not get the reponse you are looking for (I think that is what you have indicated). A browser uses HTTP GET to return web pages. HTTP POSTs are typically generated when you submit a form on the Interne t . You can do exactly that here:
The hard part is getting the data into
Excel. You can save the reponse from the call above and with a little editing end up with an XML document that Excel will open without issue. However, that involves manual effort which I'm guessing you want to avoid.