How to scrape from a list of links?

I have a list of links i want to scrape data from.

Tried pasting them in google sheets and scraping it. Didn't work

Also, tried to create a html file with the list of the links but am unable to scrape.

WS currently does not support local (desktop) html files. You can upload them to a web hosting service or run your own web server from your desktop (URL would be http://127.0.0.1/mylinks.html or similar). I have used AnalogX Simple Server previously to do this.

Alternatively, if the list is not too long, just add the URLs manually in the Start URL section. This can be found in your sitemap dropdown -> Edit metadata. Remember to click Save Sitemap after you have added URLs.