XPath query, IMPORTXML & Google Sheets - Advanced Tutorial

[@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 ^_^

[@baawaa1949]

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!

[@skytechbits]

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

[@josebarragan9227]

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

[@Cc-vu9mr]

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.

[@MK-ih6wp]

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

[@MK-ih6wp]

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

[@hamzarafiq2459]

I would like the proper Xpath to use in Google Sheets such that =IMPORTXML("services.rsna.org/playbook/v1/playbook/complete/cpt/71250",xpath) returns RPID16. Or for example 74177 would return RPID145. You can try IMPORTDATA will the same URL to get the entire XML. In fact, I think the answer is close to something like "//*[local-name()='PlaybookTerm']/@radlexPlaybookId" but I do not get it in sheets.

[@takaakiyamada7294]

Wonderful tutorial about XPath! As I arrived at this video too late, the structure of the KZbin 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. :-)

[@daytodatainc.2520]

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

[@tylercroskey2462]

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

[@LucXX36]

This guy is cool. You won me over at 33:37 at the latest with your calm and nice kind

[@JordiRPuxench]

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

[@pablonicolasvillanueva8708]

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

[@frederics7199]

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

[@hamzarafiq2459]

I would like the proper Xpath to use in Google Sheets such that =IMPORTXML("services.rsna.org/playbook/v1/playbook/complete/cpt/71250",xpath) returns RPID16. Or for example 74177 would return RPID145. You can try IMPORTDATA will the same URL to get the entire XML. In fact, I think the answer is close to something like "//*[local-name()='PlaybookTerm']/@radlexPlaybookId" but I do not get it in sheets.

[@educacionportable]

Excellent content!

[@salvadorperez5488]

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

[@mikeparker444]

This is an excellent video man.

[@mosesdunga]

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

[@ronald3921]

This really helped me out when writing the XPath query, thank you so much for clear instructions. What I don't understand is, why when I inspect element, right-click to 'copy XPath' doesn't provide the correct path, at least not for google sheets

[@huynguyen7048]

I think KZbin updated the HTML script, so if we used the his formula, it's no longer working. I'm a HTML newbie, so I can't figure out how to update the formula to grab what we want. lol

[@janekaze]

Excellent tutorial Thankyou.

[@nvcworld6423]

i belive this is one of the best video on KZbin that watching , after watching this video I have played more than 48 hrs to pull a table from a site but not got any success , can you please help me in same ?

[@crzyofficial7658]

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

[@kritishah1659]

This is very helpful sir. I am using smart editor for XPath SelectorsHub, it is very much time saving and helpful. You might like to try it, its a browser plugin.

[@pedroivocubas4105]

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

[@dodgersv3]

Great instructions... your are the best!

[@dbtech429]

Great Video!

[@benponderin]

dude , you're magic

[@ianfinlayAustralia]

Excellent presentation

[@rolpablo]

Incleible video!!!!

[@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.

[@adibzainal3991]

best tutorial ever!

[@huynguyen7048]

Very clear video instruction about XPath query. Thank you for your effort. I'm trying to learn as much as I can from you. You're genius. I have one question that I hope you can help me. It seems like youtube updated its script. No more Ul & Li in the script. Instead Div has Id name now. How can I refer the Div with ID name in my formula? Thank you so much and I really appreciate if you can help me with this stupid question

[@PropertiDong]

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

[@TheRangeControl]

Why did it only pull the title and NOT the link when you did the anchor at : #10:20 ? I mean, the encloses both a title AND a link, so why only part of it?

[@Kuzmitch2010]

Thank you, it's super helpful!

[@tibolefevre]

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

[@billjones3720]

Very informative. Thank you.

[@allfootage3558]

Very Informative Tutorial, I learn alot from this. Just one more question How to scrape the items loaded via a "view more" button in google sheets.

[@veevee7555]

Super sir thanks 🙏

[@Xein24]

for tag .... which should be Xpath? please tell

[@אריאלבריל]

Great video! Thanks 😁😁

[@phulm]

In June 2019 the @class addition no longer seems to work as advertised, even with WebScraper or Scraper.

[@suleymanozturk746]

Thx . Perfect 👍👍👍👍

[@TheDoggyOnTheWall]

Great detailed tutorial. Thanks!

[@J-J_du4nb]

Easiest way to find the XPath on a page is: - Right click section or word > inspect - Then right click highlighted line in "Inspect Elements" that just popped up - Click copy > scroll down and click "Xpath"

[@itsJLa]

Thank you so much for your amazing and easy to follow tutorials! I can't seem to figure out how to resolve the "Error Resource at url contents exceeded maximum size" on Google Sheets using importXML and was wondering if you had a video covering that subject.

[@ExcelGoogleSheets]

Unfortunately it might be impossible to resolve this problem. At least not without doing some crazy complicated things.

[@itsJLa]

@@ExcelGoogleSheets I was browsing on different forums to see if there are solutions around this issue and came accross a Reddit page with someone having the same issue www.reddit.com/r/googlesheets/comments/an7qbb/scrape_website_directory_for_names_with_custom/ And the page with the solution...but I have yet to get it to work properly webapps.stackexchange.com/questions/97629/google-sheets-why-wont-importxml-work-on-this-sheet/114124#114124

[@guruntr6481]

Very well done...

[@bobocathk]

Great training. If only top 30 videos data can be listed by using this method?

[@allanbsoliveira1]

it helped me a lot. thanks !

[@RaelDilldeMello]

Amazing channel... all your videos man, your rock! Tx so much :)

[@GeorgWuitschik]

Great video, thank you very much!

[@RoberioDias]

Very good lesson! Thanks a lot!

[@marcmolloy5446]

Awesome video... but my problem is that no matter what I do my queries come up "Empty"

[@dishydez]

Its probably not stored via Xpath then. I usually use ImportHTML if this is the case. You could also use other Import functions. Also look out for his video on import JSON that is also helpful

[@aliosmanozen196]

Great tutorial, thank you very much.

[@DavidElstob73]

Amazing timesaver for economic reports, but it is a concern if the website changes and the data is wrong, so still need to have a quick glance at the website and adding other safety checks. For example, I'm going to include a text column with my four numerical columns, so I can easily see if it has changed, because numbers will be harder to check at a glance than something like "percent of GDP".

[@moneymaker8227]

Good tutorial.!! I have a question.. I would like to know how import data to google sheet in cells that are already filled by other data. ?? I'm trying to automate my stocks imported financial data (income statement, balance sheet, cash flow statement) but I'm only able to import one by one because google sheet cells are already filled by the first stock data I imported.! How Can I RESOLVE This Issue.?? Thanks

[@binodmaharjan9981]

Very nice tutorial. But I have a problem that how to get data if the data is long and splitted into multiple pages like we have to click next button to load that data into the webpage. Please help me out

[@JesseGeorgePenner]

Is there a reason why '=IMPORTXML("kzbin.infovideos","//ul/li//h3/a")' doesn't work anymore? I tried the exact same formula from this video in a google sheet, and I get an #N/A error saying the imported content is empty

[@akshaykulkarni5626]

I'm having the same issue as well..

[@aquinox77]

How to optimize it so it only calls some parts of the data at a particular time? (too many calls stops data from loading)

[@bakataoako4202]

hi I like your video, i just wanna ask if is there any way to get the dynamic data?

[@심심-p7z]

thanks for nice explanation. i tryed to apply your explanation to scrape google news but it didn't work. can you make video to google news scrape using google sheet? especially you google certain words with "recent " filter.

[@mvgiugni65]

What about there is another page and you have to ask the webpage to go next page, to collect the rest of it?

[@Sulaimangalib]

I want to grab data from a site, but some of them have missing info, and it doesn't put a blank cell for the missing info. Is there any way to solve the problem?

[@sachidanandsadhguru3703]

Thank you very much. But, can you or anyone reading this guide me to use IMPORTXML to extract a particular row which contains specific text like "EPS" in its first column from a Table which doesn't have a name?

[@johnhe9984]

Can you post a video on how to import desired data from yahoo finance into google sheets? for example, total debt in balance sheet.

[@abdulwali4920]

hi there, can you please tell me how can i use a (google search link) to search anything on google and grab top 3 links from google and then paste it on the cell infront of cell (containing google search link)

[@LucasErtola]

Thanks @learn Google Spreasheets. Super useful video. But you solve the partial loading, or loading when scrolling? to import all data and not only the one that loads first.

[@bmr9779]

How do you import a table when the table on the website changes by criteria(#example the websites table can change data of nba players stats from last 5 games to season long)?

[@JesseGeorgePenner]

Can you tell me why, when I right click the element and copy as Xpath or full Xpath, and paste it into my formula, it doesn't work?

[@timothyrayner3626]

Link to the microsoft reference you used would be useful

[@brunocesar2283]

Is it possible to use the importdata function to bring an account's contact data?

[@jameswotring9432]

Does this list update automatically? for example your views column?

[@mariebeyssac1749]

Thank you!!!

[@dcgtk]

28:55 contains attribute 31:10 SPLIT

[@giamar3026]

Very usefull!, as all your videos. Thk you. One question: i practice on a market page and could sucesfully extract products and prices, but when i wanted to extract special prices, as not every product have an special price, the sequence cut and stop when system found one product without special price, so the followings products didn't bring me anything, no matterthey have or not special prices,. Is there a way to fix this?

[@rbendzsuk]

How do you auto-update data on your Sheets with data that changes on a web site like a crypto currencies on or stock??

[@SayafAmer]

Thank you for this amazing tutorial. However, I followed the same steps, but I could n't get the same results you had. Maybe KZbin has added protection to avoid scraping. Can you please check? If everything is fine, that means we need more practice and watch more tutorials from you. So It would be apprectiated if you could arrange another tutorial. :)

[@ExcelGoogleSheets]

KZbin now loads data using JavaScript, so this won't work on KZbin anymore.

[@ExcelGoogleSheets]

Otherwise everything is the same.

[@alexzhang5816]

Hi, I am trying this on a website, the information I am seeing through chrome is not the same as I am getting in sheet from the URL in the address bar. I am assuming the site has some kind of web scraping countermeasures. Is there any way to get around it?

[@igorchernysh9764]

@Learn Google Spreadsheets I have a question, is there any command or smth that will help to get data which can be retrieved only after pressing a specific button on a page like "see more" or "change currency" or "left/right"? Pressing a button doesn't change the initial url, so I can't use a modified ulr for importxlm.

[@ExcelGoogleSheets]

You'll need to write a script for that. Not in stock functionality.

[@walkingowl6810]

thank you so much! Precise and clear :D

[@dimitrioschantzis4647]

Great video, I apply the importxml function to Google Sheets and other times it works and other times (without changing anything) it gives me #N/A into cell. What can I do? Thank you very much

[@tylercroskey2462]

Does anyone know if import XML can be used for any website? I have been trying to get data from Terapeak product research and it won't even allow me to extract a title from the website. It keeps saying imported content is empty. Thanks!

[@igorchernysh9764]

@Learn Google Spreadsheets Thanks for the video!

[@nssdesigns]

So if you add a new video and refresh or open the Google Spreadsheet it will automatically propagate the Sheet with additional data?

[@ExcelGoogleSheets]

Generally yes, but it will not work on KZbin anymore.

[@hardikpanchal8106]

Thank u so much for the video I want to know that the information if change daily than in spreadsheet also it's changed automatically or we have to keep refresh the sheet

[@5953kim]

Per one hour refresh importxml function automatically.

[@3BoxCreation]

An error like this comes after some time. Is that it? How to solve it? " Error Could not fetch url: "

[@Victor-vp7kn]

Hello, I would like to know if it possible to have a one time class ( 30 min. ~ 1 hour) at a fair price. I need to extract certain info from a webpage and import into googlesheets? Thank you Vic

[@damiannika1296]

Me to please. [e-mail]. Thanks in advance!

[@9ebooks]

Hello sir how to seperate by comma instead of using first or last li

[@outlandvisual7421]

Why not use copy xpath in the inspector as opposed to manually figuring out the path syntax?

[@sciences-sci]

How do you update google sheet? Thanks

[@asyikbrowsing200]

What if I want to scraping data on a website that requires a login?

[@justfly2525]

All of your videos are awesome... I'm trying to be lazy... I was able to double click directly on the element that I wanted then hit... copy... copy x path. That seemed to give me the complete and exact x path. Having said that gsheets said it was empty and it didn't work.

[@TheQAAA]

Hello, the video is great , I there way to get the xPath of anything without going in all this instructions? best regards

[@Garen1]

Amazing video! I was wondering if there is a way I can contact you via email with a problem I am having regarding getting specific data into google sheets?

[@binodmaharjan9981]

In my case, data table is splited into 2 pages of same url: merolagani.com/StockQuote.aspx I am able to get data from page 1 but not able to get data from page 2 from that url. Please help me out.

[@Shkur777]

Thank you for tutorial. What about auth credential? Token or login/pass

[@ExcelGoogleSheets]

This doesn't support login/pass unless it can be passed as a part of the URL. You will have to write a script with Apps Script UrlFetchApp.

[@SquaredbyX]

Why //ul/li instead of just //li? // uses recursive descent, which finds every tag in the document. //ul/li checks every ul in the document for a direct child li. Why not just start at //li??? and have the check start at every li tag in the document?... What are the guidelines on how far out to begin your query?

[@sajmosajmon5774]

How to import data by function for example importxml and SAVE data automatically?

[@rafsan_jane]

Now if there is no "ul or li" only "div" there how can I use IMPORTXML for those sites?

[@wiganagames]

I seriusly love u

[@ExcelGoogleSheets]

:)