Which language use to automatize the data extraction from websites to Excel? : <p>I would like to import data from specific websites to one or different Excel file(s).</p>

<p>The different websites are the following :</p>

<ul>
<li><a href="https://www.cmegroup.com/trading/equity-index/us-index/e-mini-dow_quotes_settlements_futures.html" rel="nofollow noreferrer">https://www.cmegroup.com/trading/equity-index/us-index/e-mini-dow_quotes_settlements_futures.html</a></li>
<li><a href="https://www.cmegroup.com/trading/equity-index/us-index/e-mini-nasdaq-100_quotes_settlements_futures.html" rel="nofollow noreferrer">https://www.cmegroup.com/trading/equity-index/us-index/e-mini-nasdaq-100_quotes_settlements_futures.html</a></li>
<li><a href="https://www.eurexchange.com/exchange-en/market-data/statistics/market-statistics-online/100!onlineStats?productGroupId=13394&amp;productId=34642&amp;viewType=4&amp;busDate=20191018" rel="nofollow noreferrer">https://www.eurexchange.com/exchange-en/market-data/statistics/market-statistics-online/100!onlineStats?productGroupId=13394&amp;productId=34642&amp;viewType=4&amp;busDate=20191018</a>  (I didn't find any direct link, please change the part at the end of the link with the current date !)</li>
<li><a href="https://live.euronext.com/fr/product/index-futures/FCE-DPAR/settlement-prices" rel="nofollow noreferrer">https://live.euronext.com/fr/product/index-futures/FCE-DPAR/settlement-prices</a></li>
</ul>

<p>Each day, the websites give, for each contracts (DEC19, MAR20, JUN20 etc) some values (open, high, low, last, settle, volume etc.)</p>

<p>I would like to automaticaly extract/copy/import (in an .csv or Excel file for example), everyday, for each product (DOW, NASDAQ, CAC and DAX) and only for the contract which has the highest volume, the values.</p>

<p>Somebody told me it could be done by using C# language.. However I have absolutely no knowledge in C#.</p>

<p>I've also tried to use Excel and the function Data>Import data from a website, however the "table" is empty, maybe they protected their data ?! (I wanted to create a macro in Excel to automatize this process but it didn't work).</p>

<p>So the main question is : which language will allow me to automatize the data extraction from these websites to excel ? </p>

<p>Thank you very much ! </p>
