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 ^_^
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.
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
Wonderful tutorial about XPath! As I arrived at this video too late, the structure of the RUclips 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. :-)
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
I think RUclips 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
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.
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
Is there a reason why '=IMPORTXML("ruclips.net/user/LearnGoogleSpreadsheetsvideos","//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
i belive this is one of the best video on RUclips 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 ?
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
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.
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".
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
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 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
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!
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?
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?
I have an issue. I am trying to scrape historical data from Yahoo finance, It has 535 rows. But my function is returning only 100 rows. How can it be solved? Great Video btw.
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)
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)?
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
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
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.
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?
@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.
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.
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
hello very good video , Actually I am working in pulling some data from SCOPUS web and It works fine, but some of the info that I importing them does not display of appear in the cell of spreadsheet even it showing , Can you help ? Thanks
Please, how can i filter only the text between 76.653,6976.653,69 My function now is : "//span[@class='Trsdu(0.3s) Fw(b) Fz(36px) Mb(-4px) D(ib)']" thanks for your help...
@@ExcelGoogleSheets I don’t know…. The issue is: you have a clear command of xpath terminology that is absolutely incredible to the layman like me. Anything that happens to help with xpath makes this formula more usable to me.
Please Resolve this . its urgent 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.
Hi there, Awesome content man, im learning so much! I have a question/problem I need some help with. , I seem to be getting a limited number of returns on my data when i try to extract similar data to you in this video. What is the reason that would be happening? I'm using "*" before "//" so i cant search everything, but even when the page is refreshed and there are a different order of items, the XML still only returns 48 rows. Any clues? Thanks
Unfortunately, only "//h3/a" works today. There are no UL and LI, so the examples do not work with them. Also the sample with class selection does not work.
@@ExcelGoogleSheets The fact is that the browser renders the content. The Importxml function sees one thing, and a person sees another, so the old approaches do not work. Perhaps this is a consequence of the struggle with parsers. It is necessary to invent something new. For example, how to display the structure (with tags) in the browser that the Importxml function sees.
@@ExcelGoogleSheets Here is an example to confirm that a person and a function see different contents. Enter this on the sheet: =IMPORTXML("ruclips.net/user/podsolnooxvideos?view=0&sort=p&flow=list&view_as=subscriber";"//ul/li//h3/a") You will see the result, i.e. the function sees tags UL and LI. However, you do not see these tags in the browser.
RUclips now renders content using JavaScript. Importxml only works if content is rendered on load. You shouldn't be using Importxml to get youtube data, youtube has API for it and I have a video covering it.
@@ExcelGoogleSheets stackoverflow.com/a/18241030/2578960: "Most XPath Processors Work on raw XML Excluding JavaScript, most XPath processors work on raw XML, not the DOM, thus do not add tags. Also HTML parser libraries like tag-soup and htmltidy only output XHTML, not "DOM-HTML". This is a common problem posted on Stackoverflow for ... Google ... Spreadsheets."
Whenever I try this approach, Google Sheets returns errors ("Can't parse", "Empty", etc.) unless the XPath provided is VERY simple (i.e. "//div"). Anything more complex, I get no data. Doesn't matter the source.
What is I only have an API from HTTPWatch - where the site doesn't have a Table? What I'm trying to Import: njparcels.com/search/address/?s=Newcastle+Ct&s_co=15
hey man thanks for the great videos, Iv tried it on simple stuff work like a charm. iv tried to pull all of my fb friends i couldn't why is that? thanks in advance
RUclips changed all his APIs. Any chance you do an update video about how to extract the e.g. the views number of a certain video since they changed the code? :)
This video is not meant as a tutorial to scrape youtube data. Website will change all the time, but the logic of using the function is the same. If you need youtube info there are better ways to do it using RUclips API.
Would it be possible to create some sort of helper tool/extension thing that is like the one built in to Chrome's Devtools>Copy XPath, but one that actually works with ImportXML??
I image that you could create a Google Chrome extension that would be able to accomplish this. It would not be simple for someone who is not a programmer though.
Great video. I am trying to import data from a class MarketData into a google sheet but it says imported content is empty. Please help. Here is the string: =IMPORTXML("www.sharedata.co.za/v2/Scripts/Quote.aspx?c=VOD","//ul[@class='MarketData']")
I have tried to retrieve data from the web in Excel using the FILTERXML formula, but he always shows a "Value" error. = FILTERXML (WEBSERVICE (A2), "\\ tr") whereas if I apply the formula on the Google sheet it works. = IMPORTXML (A2, "\\ tr")
most likely Excel cannot handle the whole table, it's possible that you need to do each column separately. try //tr/td[1] and see if you get the first column.
I was trying to follow the steps recommended in the video but no luck. I am trying to get all the listed stocks in that table, but some how I cannot fig-out why is not working?Any advise? Thank you! =importxml("stockcharts.com/freecharts/sectorsummary.html?&G=SECTOR_DJUSAS&O=6","//tr/td/span")
Good tutorial. Do you know if sites block Google sheets user agent? (Or IP or whatever it makes request under). We're trying to watch our products on Wayfair.com. "Import Internal Error" returned, but since I'm just learning can't tell if its my syntax (checks out in Firebug) or if site is blocking. Thanks!
I don't really know, I don't use Google Sheets for any serious web crawling, there are far better options. That being said, most of large website will have some some sort of request limit after which they will temporarily block the IP address. Not sure they would block Google Sheets as a whole, but it's definitely not difficult, since Sheets request IP addresses are made publicly available in Google Sheets documentation.
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 ^_^
Thank you so much for actual troubleshooting and without any transitions while doing the tutorial.
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.
32:00 I'm loving this SPLIT() function! And displaying the img right in the spreadsheet- SO useful.
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
What a great tutorial! explains everything from beginning to end. Great Job!!
Wonderful tutorial about XPath! As I arrived at this video too late, the structure of the RUclips 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. :-)
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
I think RUclips 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
Dude, you're amazing! So useful info. Thanks a lot!!
In June 2019 the @class addition no longer seems to work as advertised, even with WebScraper or Scraper.
Your explanation is awesome. You helped me to reach my goal... my heartfelt thanks
Best tuto ever. You definitely have got a gift for explaining stuff man. Keep up the good work!
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.
Awesome video... but my problem is that no matter what I do my queries come up "Empty"
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
Awesome tutorial. It solved in minutes all the doubts I had with the XPath query. Congrats and tx!!
Excellent tutorial Thankyou.
This guy is cool. You won me over at 33:37 at the latest with your calm and nice kind
Fantastic explanaton, and so detailed. I thank you for the time you spend to do such a useful video.
Is there a reason why '=IMPORTXML("ruclips.net/user/LearnGoogleSpreadsheetsvideos","//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
I'm having the same issue as well..
i belive this is one of the best video on RUclips 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 ?
Excellent content!
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
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.
Great instructions... your are the best!
dude , you're magic
This is an excellent video man.
What a great video. Awesone. Thanks a lot for your job !
Thank you, it's super helpful!
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".
Great detailed tutorial. Thanks!
Great Video!
Very informative. Thank you.
Very helpful! Thanks.
Amazing channel... all your videos man, your rock!
Tx so much :)
Great tutorial, thank you very much.
Super sir thanks 🙏
Very good lesson! Thanks a lot!
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
Great video!
Thanks 😁😁
best tutorial ever!
it helped me a lot. thanks !
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.
Unfortunately it might be impossible to resolve this problem. At least not without doing some crazy complicated things.
@@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
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!
Can you post a video on how to import desired data from yahoo finance into google sheets? for example, total debt in balance sheet.
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?
@Learn Google Spreadsheets
Thanks for the video!
thank you so much!
Precise and clear :D
What about there is another page and you have to ask the webpage to go next page, to collect the rest of it?
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?
Tks 4 the lesson
What if I want to scraping data on a website that requires a login?
Great training. If only top 30 videos data can be listed by using this method?
I have an issue. I am trying to scrape historical data from Yahoo finance, It has 535 rows. But my function is returning only 100 rows. How can it be solved? Great Video btw.
It is better to check the references of 100 onward then try.
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)
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)?
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
Me to please. dn@askdamian.net. Thanks in advance!
An error like this comes after some time. Is that it? How to solve it? " Error
Could not fetch url: "
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
Why not use copy xpath in the inspector as opposed to manually figuring out the path syntax?
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.
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?
//ul/li/span[1] span first element not working can you help me
How do you update google sheet?
Thanks
@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.
You'll need to write a script for that. Not in stock functionality.
Thanks for the lesson. By this code,only first 30 data is extracted.how to extract more number of data.? By customizing this code.
How do you auto-update data on your Sheets with data that changes on a web site like a crypto currencies on or stock??
Excellent tutorial... Could you please help me with xpath syntax for scraping the product price from Amazon??
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.
How to make the query as if I was in Prague or Berlin (to get location reliant different results)
Is this still working? I get "Imported content is empty."
How do I use importXML on-site which required login
python.. I think you need to make a program for that
Have you done any thing on refreshing the data in google sheets IMPORTXML?
I don't think I have.
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
Per one hour refresh importxml function automatically.
Hello, the video is great , I there way to get the xPath of anything without going in all this instructions? best regards
Why if I take json data with google sheet slower in appeal than in Excel?
hello very good video , Actually I am working in pulling some data from SCOPUS web and It works fine, but some of the info that I importing them does not display of appear in the cell of spreadsheet even it showing , Can you help ? Thanks
How to import data from
www.soccer24.com
I get always Empty DAta
i cant import prices from pcpartpicker and im using the exact xpath
Please, how can i filter only the text between 76.653,6976.653,69
My function now is : "//span[@class='Trsdu(0.3s) Fw(b) Fz(36px) Mb(-4px) D(ib)']"
thanks for your help...
6:15 just right click and select copy xpath path.
Would that work when you have a list of 40 items matching a class?
@@ExcelGoogleSheets I don’t know…. The issue is: you have a clear command of xpath terminology that is absolutely incredible to the layman like me. Anything that happens to help with xpath makes this formula more usable to me.
can this work with a website that required us to login first?
No.
Thank you for tutorial. What about auth credential? Token or login/pass
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.
how to get all pages data
So if you add a new video and refresh or open the Google Spreadsheet it will automatically propagate the Sheet with additional data?
Generally yes, but it will not work on RUclips anymore.
Please Resolve this . its urgent
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.
Hi there,
Awesome content man, im learning so much!
I have a question/problem I need some help with.
, I seem to be getting a limited number of returns on my data when i try to extract similar data to you in this video. What is the reason that would be happening? I'm using "*" before "//" so i cant search everything, but even when the page is refreshed and there are a different order of items, the XML still only returns 48 rows. Any clues?
Thanks
Impossible to say, so many things happen with each website. It's pretty much case by case when it gets to this type of problems.
Unfortunately, only "//h3/a" works today.
There are no UL and LI, so the examples do not work with them.
Also the sample with class selection does not work.
Websites will obviously change, logic is still the same.
@@ExcelGoogleSheets The fact is that the browser renders the content. The Importxml function sees one thing, and a person sees another, so the old approaches do not work.
Perhaps this is a consequence of the struggle with parsers.
It is necessary to invent something new.
For example, how to display the structure (with tags) in the browser that the Importxml function sees.
@@ExcelGoogleSheets Here is an example to confirm that a person and a function see different contents.
Enter this on the sheet: =IMPORTXML("ruclips.net/user/podsolnooxvideos?view=0&sort=p&flow=list&view_as=subscriber";"//ul/li//h3/a")
You will see the result, i.e. the function sees tags UL and LI.
However, you do not see these tags in the browser.
RUclips now renders content using JavaScript. Importxml only works if content is rendered on load. You shouldn't be using Importxml to get youtube data, youtube has API for it and I have a video covering it.
@@ExcelGoogleSheets stackoverflow.com/a/18241030/2578960:
"Most XPath Processors Work on raw XML
Excluding JavaScript, most XPath processors work on raw XML, not the DOM, thus do not add tags. Also HTML parser libraries like tag-soup and htmltidy only output XHTML, not "DOM-HTML".
This is a common problem posted on Stackoverflow for ... Google ... Spreadsheets."
Whenever I try this approach, Google Sheets returns errors ("Can't parse", "Empty", etc.) unless the XPath provided is VERY simple (i.e. "//div"). Anything more complex, I get no data. Doesn't matter the source.
I am getting data, but after the page would refresh, the data disappear and I only can get all data back by changing the path or rebuilding it!
What is I only have an API from HTTPWatch - where the site doesn't have a Table?
What I'm trying to Import:
njparcels.com/search/address/?s=Newcastle+Ct&s_co=15
Can I get the titles from "ruclips.net/user/feedhistory". It gives no answer or parsing error.
Import XML formula how to apply on Truecaller please do workout share that link
hey man thanks for the great videos, Iv tried it on simple stuff work like a charm. iv tried to pull all of my fb friends i couldn't why is that? thanks in advance
You got to authenticate before accessing
how to resolving error "Imported XML content cannot be parsed."?
yeah, that's where I am at. We're doing it wrong obviously
RUclips changed all his APIs. Any chance you do an update video about how to extract the e.g. the views number of a certain video since they changed the code? :)
This video is not meant as a tutorial to scrape youtube data. Website will change all the time, but the logic of using the function is the same. If you need youtube info there are better ways to do it using RUclips API.
Would it be possible to create some sort of helper tool/extension thing that is like the one built in to Chrome's Devtools>Copy XPath, but one that actually works with ImportXML??
I image that you could create a Google Chrome extension that would be able to accomplish this. It would not be simple for someone who is not a programmer though.
Sure, it works.
i am having span instead of list
Great video. I am trying to import data from a class MarketData into a google sheet but it says imported content is empty. Please help. Here is the string: =IMPORTXML("www.sharedata.co.za/v2/Scripts/Quote.aspx?c=VOD","//ul[@class='MarketData']")
I have tried to retrieve data from the web in Excel using the FILTERXML formula, but he always shows a "Value" error.
= FILTERXML (WEBSERVICE (A2), "\\ tr")
whereas if I apply the formula on the Google sheet it works.
= IMPORTXML (A2, "\\ tr")
have you tried //tr ?
I would first make sure WEBSERVICE(A2) has a valid return.
yes, but it just "value"
in excel => ibb.co/dPVFi9
in google sheet => ibb.co/m6K2Vp
most likely Excel cannot handle the whole table, it's possible that you need to do each column separately. try //tr/td[1] and see if you get the first column.
I was trying to follow the steps recommended in the video but no luck. I am trying to get all the listed stocks in that table, but some how I cannot fig-out why is not working?Any advise? Thank you!
=importxml("stockcharts.com/freecharts/sectorsummary.html?&G=SECTOR_DJUSAS&O=6","//tr/td/span")
Good tutorial. Do you know if sites block Google sheets user agent? (Or IP or whatever it makes request under). We're trying to watch our products on Wayfair.com. "Import Internal Error" returned, but since I'm just learning can't tell if its my syntax (checks out in Firebug) or if site is blocking. Thanks!
I don't really know, I don't use Google Sheets for any serious web crawling, there are far better options. That being said, most of large website will have some some sort of request limit after which they will temporarily block the IP address. Not sure they would block Google Sheets as a whole, but it's definitely not difficult, since Sheets request IP addresses are made publicly available in Google Sheets documentation.
Hi, I have a few trouble-shooting questions that I'd like to ask you about Google Spreadsheets. Is there a way to reach you via email? Thank you