Hello,
I have a list of hundreds of URLs in a column in excel which are all in the following format, with the only changing variable being an ascending number in x:
e.g. https://www.mrexcel.com/board/forums/x
Each of these URLs open up a webpage with the exact same format as each other, however there is one line of text in each webpage which differs ever so slightly. Is there a way for me to create an automated process which opens up each of these URLs and scrapes/extracts the text on every webpage and formats this neatly within an excel document for me to later analyse?
Any help here would be really appreciated. Note I am not that experienced in coding.
I have a list of hundreds of URLs in a column in excel which are all in the following format, with the only changing variable being an ascending number in x:
e.g. https://www.mrexcel.com/board/forums/x
Each of these URLs open up a webpage with the exact same format as each other, however there is one line of text in each webpage which differs ever so slightly. Is there a way for me to create an automated process which opens up each of these URLs and scrapes/extracts the text on every webpage and formats this neatly within an excel document for me to later analyse?
Any help here would be really appreciated. Note I am not that experienced in coding.