In Excel; Data->From Web->Address (
http://bitcoincharts.com/)->Goif Script Error popup comes up then click No
click black right-pointing arrow in yellow box to select the Market table
click Import
click OK
to manually refresh; Data->Refresh
to automatically refresh periodically; right click on table cell->Data Range Properties->Refresh every
enter number of minutes (I use 1)->OK
I know this method to get data from a web page, thanks. But it will be nice to know how to import data from JSON into Excel, in that way we can have wider range of application!
Sorry to revive an old thread, is there anyone knows how to import API JSON data into Excel? I searched many places but all in vain...