Import JSON Api to Excel

I am trying to import the following JSON APi link http://pubapi.cryptsy.com/api.php?me...ata&marketid=3 into an excel spreadsheet via a macro. How can I do this?

why is this marked as solved??

You must have inadvertently marked it as solved, you can change it in the thread tools at the top of the page.

What should this look like on the spreadsheet? There isn't just one set of data here, there's different bits that relate to different things

Interesting. I had to mark it as solved, and then go back and mark it as unsolved. Anyway, I'm looking to just dump this data into different columns. Almost exactly how it is setup now when you go to that link. Does that make sense?

Did you ever make any progress on this.
I can pull public data in using the public API, but I don't know how to structure the private API request.
Have tried a lot of different things, including trying to use curl for the request, but I don't know about accessing web data to pull it off.

Did you ever make any progress on this.
I can pull public data in using the public API, but I don't know how to structure the private API request.
Have tried a lot of different things, including trying to use curl for the request, but I don't know about accessing web data to pull it off.