Forum Discussion
Get Data from Web
Hello, Can anyone please help me to link excel to McMaster Carr website. As seen in the picture below, I have part numbers in a column and I want to get its description and price in adjacent columns...
Does anyone know a solution?
I had a quick look, but I cant see anything that suggests there is any kind of API you can plug into to get this information automatically.
Where did you see that it can be done? Did they suggest how?
Thanks Philip, I got the direction from the following link.
https://www.quora.com/How-do-you-extract-data-from-the-web-into-Excel
I see. I dont think that excel will be able to do what you want it to here... what you need is a web scrapping service to read each page and extract infomation.
