Fetch option Chain (Equity Derivatives) and quotes from NSE India in a simple Google Sheets template.
How does it work?
It uses the ImportJSON add-on that we built.
ImportJSON provides a simple function to import JSON formatted data from different sources and turn it into a two-dimensional table you can easily manipulate.
Copy the template
To properly set yourself up to extract thousands of data points from NSE India, the first thing you need to do is copy the template:
Install ImportJSON add-on in the copied spreadsheet
Then, simply install the tool into your Google Sheets from the Google Workspace Marketplace following the step-by-step instructions indicated by the add-on.
From there, you can access the tool by clicking “Add-ons” and activating ImportJSON within the spreadsheet, you are ready to go!
See how the info displays in the ‘Tool’ tab

Did you find this tool useful?
We’d love to hear all of your feedback so that we can keep providing the best information on web scraping!