How can i get all the stocks in NSC with its type and sector details

I wanted to create my own report of my portfolio for this i want to know each shares i invest its type (large/small) and sector it belong so i can create my report in my excels sheet.

I wanted to dowlnoad this detail.

https://www.niftyindices.com/indices/equity/sectoral-indices

If Zerodha customer , can go to console - portfolio - holdings - in overview ,click equity then click sectors , it will show stocks in that sector and also capwise .