Copy data from 10,000 urls in excel

i have list of all 10000 url's in excel sheet, is there easiest way i can make automation job to open each link and save the same data in excel sheet.

any advice is highly appreciated.