Home

Google Sheets with Import XML – get name data from this website

I’d like to import the following info from this page into a Google Sheet: https://www.seditionart.com/artists/date/desc/curated

-Names of all the artists

-Link to each artist page

I’ve tried a number of variations on:

=importxmL("https://www.seditionart.com/artists/date/desc/curated", "//a/@href")

for links to their artist page, and

=importxmL("https://www.seditionart.com/artists/date/desc/curated", "//img[@alt")

for the image alt text to get their names.

Please let me know what I’m doing wrong. New to this. Thanks.

Asked on July 17, 2020 in XML.
Add Comment
Cancel
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.