Good day excel geniuses!
I am trying to write a formula, which I believe would be written with ImportXML, to pull info from a website.
Link to source website here.
The info that I want to scrape from the site is the H3, H4 class='price', and p class='small' for each item listed.
In Excel I would want it to look as such;
I'm having trouble just getting any basic information to import to Excel. Anyone able to help me with this?
I am trying to write a formula, which I believe would be written with ImportXML, to pull info from a website.
Link to source website here.
The info that I want to scrape from the site is the H3, H4 class='price', and p class='small' for each item listed.
<div class="card-wrapper"><h3>Accu-Chek Aviva Plus</h3>
<img src='[URL]https://www.diabeticstrips4cash.com/2/images-comp/Aviva-50-min.jpg[/URL]' alt='sell unused Accu-Chek Aviva Plus strips' class='img-fluid icon'>
<h4 class='price'>$30</h4>
<p class='small'>Retail Qty. 50 </p></div></div>
In Excel I would want it to look as such;
Name | Price | Amount |
Accu-Check Aviva Plus | $30 | Retail Qty. 50 |
I'm having trouble just getting any basic information to import to Excel. Anyone able to help me with this?