Hi,
I have a list of image URLs outputted as a result of sitemap parse and in next column, i would wish to pull in each image's alt tag (if it exists).
I have tried this one =Dump(XPathOnUrl("http://tessin.se","//img","alt")) with certain tweaks but doesn't help!
Any suggestions?
The alt text is not part of the image link but is available as an attribute in the HTML tag which contains the image link
Really trying to understand how this works, but I cannot seem to replicate this. I also had a look at a previous question about this, and looked at instructions on the website, but I guess I just don't understand Excel and how this kind of formulas work.
Do I put this formula somewhere in Excel with the URL of the website I want to check? Or do I put it somewhere in SEOTools for Excel?
I think an instruction video (on YouTube perhaps?) would be helpful.
Cheers.
I have attached an example for one approach. See column C, it looks for the a tag with the src attribute matching the image link. Might need some adjusting depending on if your image links are full URL:s or relative.
=XPathOnUrl($A$1;"//img[@src='" & A3 & "']";"alt")
https://file.io/giBoSQ9ipz2P