Import JSON to Google Sheets

Looking for how to convert your Google Sheet to JSON? We have a guide for that here.

In this guide we'll cover how to import JSON into an existing Google Sheet.

There are several ways you can achieve this, which are:

• Manually write code to connect to the Google Sheets API to import your data.

  This involves lots of work and time. Not the best if you want to do this quickly and easily.

• Write a Google Sheet app script to import your data.

  Once again, this involves coding something up yourself.

Another more straight forward way is to use sheet2api. In this post, we'll cover how to take your JSON and import it into your Google Sheet via sheet2api.

First, let's start with some JSON, here's an example JSON blob:

                    
[{
    "Name": "Bugs Bunny",
    "Favourite Thing": "Carrots",
    "Image": "Bugs.png"
}, {
    "Name": "Elmer Fudd",
    "Favourite Thing": "Chasing Rabbits",
    "Image": "Elmer.png"
}]
                    
                

Now, head over to Google Sheets and create the spreadsheet you'd like to import your JSON into.
The first row of the spreadsheet needs to must the keys within your JSON as columns, they must match exactly, like so:

Great, now copy the Share Link to that spreadsheet. (Not sure how? watch this video).

Head over to sheet2api and Create your Spreadsheet API.

Click create.

Then your API will be listed.

Great, that's the hard work done.

Finally, click "Copy" next to your API URL to proceed to the final step.

Enter the details of your API URL along with your Google Sheet Share Link into the form below. This will automatically import all of your JSON into your Google Sheet!