How to Scrap Data from Web to Excel

New Contributor


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

1 Reply

@Edo123451 Go to Data / from Web and enter this:

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.