Copy data from a website to Excel

[swapnilk]

Hello everyone,

I want to copy the table from this link https://www.nseindia.com/option-chain to excel or if importing only the table is not possible then importing the entire webpage is also OK.
Even if the entire webpage is imported i can use a different sheet to copy only the data i require.
I tried using Web Query but it seems to download everything other then the table.

Please help with any form of solution (VBA, web query anything will do)

Thanks in advance!

 

[J.Ty.]

Terms of use of this page state:
You may not conduct any systematic or automated data collection activities (including scraping, data mining, data extraction and data harvesting) on or in relation to our website without our express written consent.

So the first step is to ask for written permission.

J.Ty.