NSE Option Chain in Xls

Respected Members,

I’m not able to extract NSE Option chain into google spread sheet. Please help me.

I have used importhtml function.

@ Respected Lotus,

Please help


You can download FNO Bhavcopy from -


It has the option chain inside, filter with “OPTIDX”

1 Like

Thank you for reply, I have put the query regarding automation as I don’t want to download it manually.

Just download in python and shoot back with Gspread module.

I am doing the same.

Check -

There is NO other way to import into Gsheet from NSE because NSE blocked Gservers.

great thanks for your response.

how can we connect