A lot of good structured data is available through APIs like weather, ratings, currency rates and many more. APIs give you this data in JSON format and now it's possible to import JSON data directly into Google Sheet.

To be able to do it you need a custom function that called ImportJSON

  1. Open your Google Sheet -> Tools -> Script Editor
  2. Rename it to ImportJson.gs
  3. Delete the placeholder content
  4. Copy this script
  5. Paste to your script and save it (click save icon)




  6. Go back to your sheet and try to call the function from your cell:
    =ImportJSON("http://date.jsontest.com", "/date", "noInherit, noTruncate")

You should see something like this:



More information how to use it here . Thanks to @bradjasper who created it.