XPath query, IMPORTXML & Google Sheets - Advanced Tutorial

Video tutorial about XPath query & IMPORTXML function in Google Sheets and how to better use them for web harvesting.

In this tutorial we'll cover how to find child elements, direct child elements, classes, classes that contain partial strings, getting attribute values and much more.

Other functions used: SPLIT, INDEX, IMAGE.

Google Sheets

Website:

[baawaa]

Excellent tutorial! I like the way that it is composed where you encounter unexpected results (duplicates) and go through the troubleshooting process to correct them. Well done!

[Cc-vumr]

I just love this channel. It's perfect for me, I learn so much and improve instantly after seeing a video. The one thing I like the most is that it's done step by step and they're explained in detail.

[theanilbhattarai]

I watched almost 10+ videos on trying to scrape data from urls in Google sheets. This tutorial made it extremely clear on how to execute what I had planned. Awesome Video, Nicely Explained! Thank you so much ^_^

[josebarragan]

MY MANNN!! I'm a newbie and I have been trying to figure this out for hours... but you came through. Nice video your delivery is good. I had no idea I'd been watching this for almost an hour lol

[daytodatainc.]

What a great tutorial! explains everything from beginning to end. Great Job!!

[MK-ihwp]

32:00 I'm loving this SPLIT() function! And displaying the img right in the spreadsheet- SO useful.

[JordiRPuxench]

Awesome tutorial. It solved in minutes all the doubts I had with the XPath query. Congrats and tx!!

[MK-ihwp]

Loving ALL the videos on this channel! But this really is one of the best xpath videos I've seen on YT. Thank you!!

[salvadorperez]

Fantastic explanaton, and so detailed. I thank you for the time you spend to do such a useful video.

[skytechbits]

Thank you so much for actual troubleshooting and without any transitions while doing the tutorial.

[frederics]

Best tuto ever. You definitely have got a gift for explaining stuff man. Keep up the good work!

[takaakiyamada]

Wonderful tutorial about XPath! As I arrived at this video too late, the structure of the YouTube page had been changed. So it was impossible to get the data by the way this tutorial instructed. Anyway, this tutorial taught me a lot. Thank you so much. :-)

[mosesdunga]

Your explanation is awesome. You helped me to reach my goal... my heartfelt thanks

[tylercroskey]

The video was very helpful. Honestly to good to be on youtube and should be taught in a class.

[crzyofficial]

thanks this wasnt exactly what i needed but i managed to get the just of how to find the exact class i needed

[pablonicolasvillanueva]

Dude, you're amazing! So useful info. Thanks a lot!!

[PropertiDong]

This is a good tutorial for a newbie like myself, thank you... !

[idomnychireno]

Thank you. I do xml editing for work and your explanation of xpath is very useful for me. I would love to see you explain how to edit xml in mass I.e.all files in one folder and delete child elements that have an specific grand child. This will be very useful for me and others.

[tibolefevre]

What a great video. Awesone. Thanks a lot for your job !

[pedroivocubas]

thank you so much for teaching this in such level of didactic