Web query - pull only specific data from a HTML page

Question

Hi,

I'm trying to pull a piece of data from a webpage. Yes, I can build a web query no problem and it pulls the data into the spreadsheet fine, but I want just a single piece of data from the page and not the entire website. I'm aware that you can select what data you want from the page, but most of the time it doesn't provide you with the option to choose exactly what you want and loads all the rest of the 'rubbish' on the page.

Example

I want to pull just a price of a product from a page. I don't want anything else from this page. Within the HTML code, the price is contained like this:

</span>
                <span class="price-including-tax">
                    <span class="label">Incl. VAT:</span>
                    <span class="price" id="price-including-tax-9">
                        £8.22                    </span>
                </span>
                        
        </div>Is there a way to to modify the URL I use to create the web query so that it only picks up this single item? Many thanks for your help. Rob

Answer 1

Thank you Aravinda. I've posted it there.

Rob

Answer 2

Hi Rob,

Since your issue involves pulling data from web query into Excel, your query is best addressed in Excel IT Pro forum:

http://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

Hope the link provided is helpful.