Excel and Javascript for APIs

Question

I want to use JavaScript to access the Google Maps API from Excel. What is the best way to do this?

(Users will enter input data into Excel, and my JavaScript will query Google Maps for the corresponding values.)

I am not concerned about the JavaScript itself, just how to get the script's output into Excel.

What if I hosted the JS on a server, and queried that with an Excel connection?...

Answer 1

A good place to start is the Google Maps API Developer's Guide and Reference.

Answer 2

Check out How can I use JavaScript within an Excel macro?.

But personally, I'd rather look at Google Spreadsheets and the Functions for external data.