Forum Discussion

amit Riar's avatar
amit Riar
Copper Contributor
Sep 03, 2018

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 from the website. I did some research that it can be done using get data from web but I am unable to get any further. Any help will be highly appreciated.

 

Website: https://www.mcmaster.com/

 

excel

5 Replies

    • Philip West's avatar
      Philip West
      Iron Contributor
      Sep 03, 2018

      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?

      • amit Riar's avatar
        amit Riar
        Copper Contributor
        Sep 03, 2018

        Thanks Philip, I got the direction from the following link.

        https://www.quora.com/How-do-you-extract-data-from-the-web-into-Excel

Resources