Can anyone help me bring data into excel from a web search?

**TK11373** · 03-27-2023, 01:56 PM

I am trying to import search results from glassdoor.com into excel but do not know how.

Is there a way i could import all the results across all the pages from the search results?

Would appreciate any help if possible.

thank you

**Zahid srabon** · 03-27-2023, 02:32 PM

Hi
First, go to the website page from where you want to get data copy the URL
and then open excel and go to data tab and then you will see an option called from web select that option then paste your URL three and press ok select which table or object you want to get and then press load, It will automatically load your data in excel table
note: if the website updates the information and you press refresh it will automatically update according to the new data.

**TK11373** · 03-27-2023, 06:39 PM

Hi Zahid, thank you for reply. I did try that but what am I doing wrong? It doesn't load the data from webpage.

I just see the below cells and nothing else:

Kind Name Text
Element HTML

I would attach a screenshot but the site wont let me.