Forum Discussion
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.
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.