Import JSON data to a Google Sheet

Importing JSON is a powerful way to get data via APIs. In order to import JSON data to Google Sheets, follow the steps below.

  1. Create a new Google Sheet
  2. Click on the Tools menu and select the option Script editor.
  3. Delete the placeholder content.
  4. Copy and paste the code from this script to the Script editor.
  5. Select File > Save
  6. Name your code "ImportJSON"
  7. Close the Script editor and navigate back to your Google Sheet
  8. In cell A1, type =ImportJSON("xxx"). Replace xxx with your API endpoint. For example http://api.openweathermap.org/data/3.0/measurements (be sure to keep the quotes and parenthesis)
  9. Press enter. Your Google Sheet should now populate with your JSON data

ImportJSON.gif

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Kirby

    USA
  • Heather Customer Success Avatar

    Heather

    USA