Home

How to Scrap Data from Web to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-874180%22%20slang%3D%22en-US%22%3EHow%20to%20Scrap%20Data%20from%20Web%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874180%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3BI%20want%20to%20scrap%20data%20to%20excel%20from%20this%26nbsp%3B%3CA%20title%3D%22Web%22%20href%3D%22https%3A%2F%2Fdigikey.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdigikey.com%3C%2FA%3E%26nbsp%3Bfor%20example%20in%20search%20bar%20of%20this%20site%20to%20put%26nbsp%3B%3CSTRONG%3EERJ-P06D20R5V%26nbsp%3B%3C%2FSTRONG%3E%20this%20id%20and%20to%20get%20attributes%26nbsp%3B%20%2C%20how%20can%20i%20do%20it.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-874180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1074982%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Scrap%20Data%20from%20Web%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1074982%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406165%22%20target%3D%22_blank%22%3E%40Edo123451%3C%2FA%3E%26nbsp%3BGo%20to%20Data%20%2F%20from%20Web%20and%20enter%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.digikey.com%2Fproducts%2Fen%3Fkeywords%3DERJ-P06D20R5V%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.digikey.com%2Fproducts%2Fen%3Fkeywords%3DERJ-P06D20R5V%3C%2FA%3E%3C%2FP%3E%3CP%3EYou'll%20be%20able%20to%20select%20which%20table%20to%20import.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eafter%20you%20find%20out%20what%20you%20need%20you%20can%20record%20a%20macro%20and%20change%20it%20so%20the%20product%20code%20comes%20from%20a%20cell%20in%20the%20spreadsheet%20and%20it%20refreshes%20when%20you%20click%20a%20button.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

1 Reply
Highlighted

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

 

Related Conversations
Multiple Conditional Formatting
Ray_Ray in Excel on
0 Replies
IF Function
Zaharyshka8 in Excel on
0 Replies
Changing Data Source
cjkim92 in Excel on
0 Replies
Convertion d'heure
Philaos-49 in Excel on
0 Replies
Copying work sheet form with formulas
Allsons in Excel on
1 Replies
excel help
RussWill227 in Excel on
2 Replies