ImportXML from PHP Website

[sprigelz]

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

 

[sandy666]

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

there is nothing like you show except

 

[sprigelz]

Good evening Sandy,

Thanks for your response. Scroll down to the "What We Buy" section, or click here. Sorry for the confusion.

The above code was pulled from the HTML. Right click the webpage and click Inspect.

 

[sandy666]

I think you will need vba

btw. these strips are expensive

 

[sprigelz]

I was able to solve this by utilizing the following formula.

Source link: here

A1 = Link above
B1 = =importxml(A1,"/html/body/div[5]/div[2]")

 

[sandy666]

Glad you solved it