The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [importhtml]

For questions specifically about the Google Sheets function: ImportHTML()

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
2answers
552 views

Using Google Sheets to bulk collect the number of Google Search results for given keywords

I would like to create a Google Sheets that will allow me to paste in a list of 25 or so keywords in column A and would then return the number of search results for each of those terms in column B. ...
1
vote
0answers
91 views

Identifying row records in different tables when scraping through ImportHTML query in Google Spreadsheet

I'm inserting two different tables successfully with ImportHTML. However I want to identify records in rows to which table it belongs. In this particular case (link attached) the player Higuain plays ...
0
votes
2answers
20 views

Find changes in imported data daily

I have a workbook that pulls data from a website and changes daily. I would like to know what has changed from day to day (or even week to week). Is there any way to do this? I'm using the ...
0
votes
1answer
369 views

How to import data from Investing.com into spreadsheet?

I want to import the live individual stock price in the Google Sheets as highlighted on the image. Is that possible? https://in.investing.com/equities/jagson-airlines-bo
-1
votes
1answer
71 views

IMPORTHTML - Can't find specific table on WNBA.com

https://www.wnba.com/stats/team-stats-advanced/#?Season=2018 Is the web page. I can't seem to find the table for advanced team rates or opponent.
-1
votes
1answer
188 views

Retrieve fund price from Vanguard website using importxml in Google Sheets

This was working in Google Sheets but now I get #N/A message: Imported Content is Empty A1: https://institutional.vanguard.com/web/c1/product-details/fund/1680 A2: //*[@id='dailyNavValue'] A3: ...