Questions tagged [importhtml]

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

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
35 views

How to change cell format on ImportHTML Function

I've used the ImportHTML function to scrape play-by-play information from Basketball Reference. I am using a Vlookup to create a rating system based on time, point different, and several other ...
1
vote
1answer
45 views

ImportHTML Altering Data Format/URL Fetch Issue

4/17 6PM Update *** I am now trying to use the URL Fetch App. I've been playing with this for hours, but can't seem to figure out the issue. I am just trying to get the info from this site as plain ...
1
vote
2answers
1k 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
96 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
0answers
10 views

Google Sheets: Transforming a single date column in a multi-column query

I'm importing a HTML table into my Google sheet with IMPORTHTML. I need to parse date strings to real dates in the first column so I can format them and sort them properly. The table structure is as ...
0
votes
0answers
12 views

IMPORTHTML - unable to import table

I try to import on my sheets a table o this url http://travian.kirilloid.ru/build.php#b=18&mb=1&s=1.45 I use this sintassi: =IMPORTHTML("http://travian.kirilloid.ru/build.php#b=18&mb=1&...
0
votes
2answers
27 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
2k 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
0answers
72 views

Added importJSON function and importHTML stopped working

I built a great Google Sheets spreadsheet which has been working for a year with no hickups. It pulls data from websites using importHTML. I then tried to add the importJSON function to the ...
-1
votes
1answer
98 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
346 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: ...