Maybe you could do it using the following API:
https://kc.humanitarianresponse.info/api/v1/data/1314.xls
Here you will need to find the 1314 number as outlined in the support article Pulling Data Into Excel Power Query. Once you find this number you could replace the number and then place the same in the browser to directly download your data.
