How to import JSON data into Google Spreadsheets in less than 5 minutes

  1. Create a new Google Spreadsheet.
  2. Click on Tools -> Script Editor.
  3. Click Create script for Spreadsheet.
  4. Delete the placeholder content and paste the code from this script.
  5. Rename the script to ImportJSON.gs and click the save button.
  6. Back in the spreadsheet, in a cell, you can type “=ImportJSON()” and begin filling out it’s parameters.

Was this useful to you? If so, would you please recommend this article so that others can benefit from it too? My other articles can be found here.

--

--

I’m into blockchains, decentralizing, and reversing climate change. CEO of https://nori.com. @paulgambill www.paulgambill.com

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Paul Gambill

Paul Gambill

796 Followers

I’m into blockchains, decentralizing, and reversing climate change. CEO of https://nori.com. @paulgambill www.paulgambill.com