How to import data from the web into Excel: If you manually copy and paste…