Forum Discussion

Edo's avatar
Edo
Copper Contributor
Sep 25, 2019

How to Scrap Data from Web to Excel

Hello.

 I want to scrap data to excel from this https://digikey.com for example in search bar of this site to put ERJ-P06D20R5V  this id and to get attributes  , how can i do it.

excel
Excel for web
Macros and VBA

1 Reply

  • wsantos's avatar
    wsantos
    Brass Contributor
    Dec 19, 2019

    Edo Go to Data / from Web and enter this: 

    https://www.digikey.com/products/en?keywords=ERJ-P06D20R5V

    You'll be able to select which table to import.

     

    after you find out what you need you can record a macro and change it so the product code comes from a cell in the spreadsheet and it refreshes when you click a button.

     

Resources