The NSE website hosts a CSV file that comprises the current list of F&O (Futures and Options) stocks along with their corresponding lot sizes.

You can view the CSV directly in a Google Sheet using a built-in function called `IMPORTDATA`. Here’s how you can do it:

  1. Open a Google Sheet where you want to import the CSV data.
  2. In the cell where you want to display the imported data, enter the following formula:
  3. Press Enter.
Here, You can find a YouTube video demonstrating the step-by-step procedure in just one minute.

Join The Conversation?