Questions tagged [importhtml]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

Gather financial data from yahoo with command IMPORTHTML() [duplicate]

already at the beginning of the year I created a table (google sheet) that is intended for collecting financional data and creating reports from the yahoo server (Specifically, about 15 pages). I ...
Flek's user avatar
  • 1
0 votes
0 answers
7 views

How to get company details using Importxml from this URL? [duplicate]

I need the list of companies from here https://www.capterra.com/event-management-software/ I am trying to use the Importxml formula but there seems to be an error. Can someone pls help. The formula I ...
Sandy's user avatar
  • 1
0 votes
0 answers
27 views

Extract data from investing.com to Google Sheet [duplicate]

I would like to get data by using the IMPORTHTML function, especially the Historical Data (monthly) So with this formula: =IMPORTHTML("https://ca.investing.com/equities/bank-of-montreal-financial-...
neya's user avatar
  • 1
1 vote
1 answer
103 views

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

I need to bulk check the number of Google Search results count for given keywords by using Google Sheets or Microsoft excel For example, ocean is About 2,960,000,000 results
Tasha Williams's user avatar
0 votes
0 answers
87 views

How can I solve this formula?

=index(importhtml(concatenate("https://finance.yahoo.com/quote/";A6;"/key-statistics?p="A6";"EN_US");1;2) A6 is tiker: MO I need Dividend date: Oct 10, 2022 Original ...
Mateus's user avatar
  • 23
0 votes
1 answer
68 views

Is it possible to trip only specific lines in google sheet importhtml function

I am trying to fetch market price from a website using importhtml & It comes in rows & columns, =IMPORTHTML("https://www.moneycontrol.com/commodity/gold-price.html", "table"...
atvt's user avatar
  • 103
0 votes
1 answer
58 views

IMPORTHTML - Add a Column with the URL

I'm currently using IMPORTHTML to import tables from a website with 5 columns. I need to add a 6th column that is called "url", which will be the URL that I used in the IMPORTHTML formula. ...
AskingAndAnswering's user avatar
1 vote
1 answer
26 views

Temporary importhtml function

This is hard to explain so I will try my best. I know how to use import html. I have been using it for NFL research for a while now. But I don't like how many times i need to repeat it for every ...
Brennan's user avatar
  • 11
1 vote
1 answer
1k views

IMPORTHTML stuck on loading

Here's my problem, I've got an html page from my own web site which contains a lot of tables. I'm using IMPORTHTML in Google Sheets to import some of them in different spreadsheets. There's 4 ...
Serge Béliveau's user avatar
1 vote
1 answer
595 views

Google Sheets IMPORTXML and IMPORTFEED and "Could not fetch url" Error

I'm attempting to retrieve information from this XML page into a Google Sheets workbook using the IMPORTXML function. The following formula, which had worked before, now returns a "Could not ...
Catalyx's user avatar
  • 227
1 vote
1 answer
259 views

Importing data from Investors.com, getting #N/A (google sheets) [duplicate]

I am attempting to pull from https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm I want to get the EPS Rating which is the 305th list item, which I found using var i = 1; [].forEach....
JishCodes's user avatar
1 vote
1 answer
34 views

How can I use the importhmtl function in combination with today ()-2 function

I am importing data from a website: https://www.chancesgames.com/WinningNumbers/WinningList It provides up to 30 days of data. I want only two days of data, that are specifically in columns a b e and ...
Stephanie Butler's user avatar
0 votes
1 answer
154 views

Combining split data into columns and filter out blanks when importHTML

With Google sheets can importHTML be combined with a formula like arrays and filters. I can perform these tasks after using importHTML manually. Array to split data in one cell into three columns and ...
user3060061's user avatar
0 votes
1 answer
177 views

Can you filter a column in size order of an imported HTML? I have tried using query with no success

Using the below importhtml I'm hoping to order the numerical data of the third column in size order, but it seems I have lost my way on the model I was following. Any help greatly appreciated. =...
MR H's user avatar
  • 11
1 vote
1 answer
108 views

Can you change the importhtml address for the website URL automatically? The website address ends in tomorrows date so changes each day

Using importhtml, I always access tomorrows updated data from a website which finishes the webpage address with tomorrows date. Is there a way of automatically updating that part of the address each ...
MR H's user avatar
  • 11
0 votes
3 answers
989 views

=IMPORTHTML forces content to date format

I am a beginner with code and formulas here, so I was wondering if anyone could do exactly what was done on this question: Trying to use Google Sheets importHTML() to import a table. It forces content ...
John Tokish's user avatar
0 votes
1 answer
330 views

Reducing amount of IMPORTHTML Requests

Main Question I'm trying to reduce my IMPORTHTML requests. The main issue is I'm forced to do the process twice. =INDEX(IMPORTHTML(*Link*,"Table", 1),ROWS(IMPORTHTML(*Link*,"Table",...
Foreman's user avatar
1 vote
2 answers
672 views

Use importhtml to import a single cell vs a whole column

As the title would read, I am looking for a method to import data from a retail site to my current spreadsheet to have the prices update in real time. Unfortunately I am not educated in this so I am ...
Nick's user avatar
  • 11
1 vote
0 answers
142 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 ...
Anthony Madle's user avatar
0 votes
1 answer
313 views

IMPORTHTML - unable to import table [duplicate]

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 sintaxis: =IMPORTHTML("http://travian.kirilloid.ru/build.php#b=18&mb=...
Giulius77's user avatar
2 votes
1 answer
428 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 ...
Anthony Madle's user avatar
1 vote
1 answer
2k views

Trying to use Google Sheets importHTML() to import a table. But no content appears

I'm attempting to load the following website into Google Sheets: https://www.lasvegasadvisor.com/vegas-lines/?sport=ncaafb&period=0 Can anyone help provide a formula that would work in google ...
Kylerem11's user avatar
-1 votes
1 answer
151 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.
Nicholas Rodriguez's user avatar
1 vote
2 answers
81 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 ...
Jeff Trujillo's user avatar
-1 votes
2 answers
955 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: ...
Jon Dotter's user avatar
1 vote
1 answer
381 views

VLOOKUP vs IMPORTHTML

I am having a Google Apps Script issue using VLOOKUP on some data generated by the IMPORTHTML function. For normal user interactions this does not seem to be an issue but scripts accessing the ...
BigMikeL's user avatar
  • 113
1 vote
1 answer
8k 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
tanmoy sinha's user avatar
0 votes
1 answer
198 views

Extracting / scraping specific information off a website programatically

I have a public website link from which I need to extract a certain field programmatically. https://echa.europa.eu/fr/registration-dossier/-/registered-dossier/14500 e.g. The section that says "...
curious_cat's user avatar
2 votes
1 answer
98 views

Search prices for a list of items

I have a list of supported Router models for the gluon Freifunk firmware. and would like to create an automated list, that always shows the actual prices for those routers. How is it possible to ...
rubo77's user avatar
  • 497
2 votes
1 answer
256 views

Truncate Text returned from indexhtml

I'm new to making spreadsheets. I'm making one for a game I play. I'm trying to use an api call to return json data from the games exchange website, to update prices in near real time. However I don't ...
bannji's user avatar
  • 23
1 vote
1 answer
4k views

Extract table from moneycontrol.com

I'm trying to extract data from a table into Google Sheets, from this webpage: http://www.moneycontrol.com/stocks/fno/marketstats/futures/gainers/homebody.php?opttopic=&optinst=allfut&...
Inderpartap Cheema's user avatar
15 votes
2 answers
29k views

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Google Sheets has several import functions IMPORTDATA IMPORTFEED IMPORTHTML IMPORTXML Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that ...
Rubén's user avatar
  • 44.6k
0 votes
1 answer
132 views

Importhtml data alert on new row updated

I am fetching data from ndtv profit, I would like to get an alert for any new row updated in the table. I have 'send mail' functions. which the event funtion needs to use to get the data on increase ...
Murali Pujari's user avatar
0 votes
2 answers
1k views

Trying to pull data from website into Google Sheet [closed]

I'm trying to pull the data from this website into a Google Sheet https://www.pgatour.com/stats/stat.194.html I've used =importhtml or =importxml in the past for this site, but I can't get it to ...
Jeff's user avatar
  • 1
2 votes
2 answers
2k 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. ...
user avatar
1 vote
1 answer
678 views

Multiple IMPORTHTML requests in a custom array, or in separate cells - same speed?

I have a spreadsheet with 62 IMPORTHTML requests. Does it make any difference in speed if I put all of these inside a custom array rather than having them in individual cells?
Gnrl Kitty's user avatar
6 votes
5 answers
15k views

Is it possible to use IMPORTHTML to return only certain cells?

I'm currently using IMPORTHTML to import tables from a website that have five columns and three rows. But, I only need three cells from each of these tables. Is there a way to import just these ...
Gnrl Kitty's user avatar
0 votes
1 answer
4k views

Inability to use `IMPORTHTML` in Google sheets

I use the website below: http://score.nowscore.com/odds/match.aspx?id=1396936 to import data from that website to Google sheets but it does NOT work. The formula I use to try to import data is: =...
Jason Lam's user avatar
0 votes
1 answer
6k views

Google Sheets IMPORTHTML has long loading time - How can I improve efficiency?

I'm putting together a spreadsheet of sports statistics that I intend to display certain calculations from on my website once both my site and the spreadsheet are complete. I currently have 30+ pages ...
LCD's user avatar
  • 1
0 votes
2 answers
2k views

Manual importhtml()?

I'm tired of Google Sheets re-triggering my importHTML functions every time I make a change to my sheet, so I would like to make that function happen manually, and store the returned data until the ...
JVC's user avatar
  • 1,192
3 votes
1 answer
1k views

IMPORTHTML data is sporadically changing to incorrect format

I'm hoping you can help me with my problem using importhtml with Google Sheets. It is a problem similar to Trying to use Google Sheets importHTML() to import a table. It forces content to a date ...
Brad Bunk's user avatar
-1 votes
1 answer
1k views

IMPORTHTML - Google Sheets - Can't find specific table

I'm trying to import a table on this page: http://www.fangraphs.com/statsplits.aspx?playerid=13593&position=2B/SS&season=2017#advanced As you can see there's three sections - "Standard", "...
SteveeeePerry's user avatar
0 votes
1 answer
7k views

Extracting data from Investing.com to Google Sheet

I am using google sheet function to extract a table from investing.com, the data I need is on daily basis, where there is a button in the page named "daily". However since the default setting of the ...
user1895703's user avatar
3 votes
2 answers
2k views

Trying to use Google Sheets importHTML() to import a table. It forces content to a date format

I am trying to get a table into a sheet. The table contains data that looks like this: 4-0-2 This is wins-losses-ties. It comes in as a date. This is the command I use: IMPORTHTML("http://www....
John Scarlett's user avatar
-1 votes
1 answer
552 views

Various incorrect errors when using import functions

I'm using various import functions to pull stock data from several places. I'm using importhtml, importxml, and even some scripting with UrlFetchApp. Out of the blue, all my imports are now failing ...
JVC's user avatar
  • 1,192
3 votes
1 answer
1k views

Do named ranges not work under certain conditions?

Been tearing my hair out today with this one. I'll be as concise as I can. I have a number of named ranges, and I would like to reference them in a long, ugly formula that works without them just ...
JVC's user avatar
  • 1,192
0 votes
1 answer
2k views

How to fetch one HTML table from a URL in Google Sheets?

I'm trying to fetch part of a single table from an HTML page into my Google spreadsheet. Been having lots of problems. importhtml() fails quite regularly (but not always) and simply displays "...
JVC's user avatar
  • 1,192
0 votes
1 answer
3k views

Query to Import HTML / XML Data Into Google Spreadsheets

I'm using Google Spreadsheets to retrieve a data table ('id=idp6855942304') from this site. The full sets of tables can be viewed by clicking on "All Reports" from the menus on the left side of the ...
Catalyx's user avatar
  • 227
10 votes
2 answers
51k views

IMPORTHTML 'could not fetch URL' but used to be able to

I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage. For the first couple of weeks that it ran, it worked pretty great, getting all the data from the table ...
Archie Roques's user avatar
4 votes
1 answer
4k views

IMPORTHTML at a certain time of day in Google Spreadsheets

I am looking for a way to import the table from this formula once per day at a certain time instead of automatically updating as the formulas seems to do. I need to do this in order to track certain ...
Isaac Brekke's user avatar