Ask a new question

Excel Web Data Query Invalid URL

I am trying to scrape data from an amazon product page to get the price and put that in an Excel spreadsheet. I have done this before with other URLs and it has been fine but the URL I am trying to use is this:

https://www.amazon.co.uk/dp/B01J2BK6CO/ref=gw_aucc_rk_qh_ec_wh?pf_rd_p=7747d414-88e2-4b25-addf-9fab03d0cf97&pf_rd_r=FGCBXTB3YDG1XC3MGKF5

I paste in the URL to the Get Data From Web function without changing any settings, although I have tried parsing in HTML headers with no success, and it tells me it is connecting for a few seconds, then tells me that the URL is invalid and says: "The supplied URL must be a valid 'http:' or 'https:' URL."

If i just try https://www.amazon.co.uk then it works and connects fine but if I try any product page it doesn't work at all. 

Any help will be greatly appreciated. 

Hi Elliot,

 

The error you encountered could be due to the content that the URL used contains or it could also be due to the data in the application getting corrupted. To assist in resolving your concern, kindly answer the questions below:

 

  • When did the issue start to occur?
  • Were there any changes made or updates installed prior to the issue occurring?
  • What troubleshooting steps have you completed?
  • Which version of Excel do you have?

 

We look forward to your response to our queries.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 13, 2025 Views 429 Applies to: