DataHandler REST API which uses the DataHandler and a variety of drivers to access Import.io, Fusion, Sheets, Drive, Parse.com, orchestrate.io , scriptDb and maybe some others that I've added after this post.

The VBA JSON and cDataset libraries in the latest version of cDataSet.xlsm

You would normally have created your own copy of DataHandler REST API so you could access your own files, but for the purposes of this example, since we are still in beta, the webapp accessed by Excel can write to testbases for each of the formats. Since others will have access to it, do not put any sensitive or private data there, and I will be clearing it out regularly.

Once you have played around with this, you can set up your own environment fairly easily, as described in DataHandler REST API

I have implemented Google Oauth2 VBA authentication which will allow you to protect your private sheets. You'll see from the example how to implement that for your PC.