Instructions for Importing JSON into Google Sheets

This guide provides a clear overview of google sheets, including Use the Free Importjson Script. Use it to understand the topic, compare the available options, and make a more informed decision.

Use the Free Importjson Script

1. Open Google Sheets

Open a new or existing Google Sheets page.

Tip : You can go to sheet.new page in your browser if you want to create new Google Sheets

2. Open the script editor

On Google Sheets, in the menu at the top, click Extensions > Apps Script.

3. In the script editor, remove the placeholder content

If any placeholder code is entered into the script editor, you can delete it.

4. Copy and paste the open source code

Visit: https://gist.github.com/paulgambill/cacd19da95a1421d3164

Copy all the code for 'import_json_appsscript.js' and paste the code into the Google Sheets script editor.

This is a free, open source script created by someone to import JSON into Google Sheets.

There are also other free importjson scripts available online if you are looking for them.

5. Save and name the script

After you copy and paste all the scripts into the editor, click the save button and give your project a name.

You can name the project whatever you want, but something like 'ImportJSON' will make it easier to remember.

6. Back to Google Sheets

After saving your project in the script editor, you can now close the script editor tab in your browser and return to your Google Sheets.

Now, in any cell on your Google Sheets, start typing '=import' (without the quotes) and you'll see an 'ImportJSON' pop-up as an option. This is the script you saved in the editor.

Click the 'ImportJSON' option.

7. Add JSON API URL

After opening the JSON input formula, you will need to add your JSON API URL.

If you want to use the free JSON API URL for testing, you can use one of the following URLs:

• Chuck Norris Jokes: https://api.chucknorris.io/jokes/random
• Current price of Ethereum: https://api.coinbase.com/v2/prices/ETH-USD/buy

Enter your URL like this:

=ImportJSON("https://api.example.com")

There should be "double quotes" around the URL and single quotes around the quotes.

In the URL is where you will specify your endpoint and add any other parameters to fetch the data you need.

8. Import JSON data

The final step to enter JSON, after entering the JSON URL, into your Google Sheets is to press the Enter button on your keyboard and wait for the JSON data to populate the spreadsheet.

Import JSON into Google Sheets demo

Conclusion

Understanding Google Sheets makes it easier to compare options, avoid common mistakes, and apply the information in this guide more effectively. Review the relevant requirements before making changes or choosing a solution.