How to Scrap Data from Web to Excel

[Edo]

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.

[#2]

@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.