Questions tagged [importhtml]

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

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

importhtml not updating when run from script

I have a script that I have set up with a trigger. When the script runs, it says it executed successfully, but the spreadsheet is not updated with the latest information from the web page. function ...
user avatar
1 vote
1 answer
434 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 ...
user avatar
0 votes
0 answers
8 views

How do i change the forced Date/Time format from IMPORTHTML? [duplicate]

I'm trying to scrape like this : INDEX(IMPORTHTML("https://www.reuters.com/companies/MSFT.OQ/key-metrics";"table";B2);3;2) and the result looks fine as long as it's in date ...
user avatar
0 votes
1 answer
175 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 ...
user avatar
  • 193
0 votes
0 answers
9 views

IMPORTHTML not fetching the correct webpage [duplicate]

I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage. What I've written is: =IMPORTHTML("https://www.rbi.org.in/scripts/FS_PressRelease.aspx?fn=9?"...
user avatar
0 votes
1 answer
88 views

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

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....
user avatar
0 votes
0 answers
9 views

How can I Import table from this webpage? https://khadya.cg.nic.in/citizen/citizenhome.aspx [duplicate]

I'm Unable to import HTML table from this URL : https://khadya.cg.nic.in/citizen/citizenhome.aspx I tried to read solutions for the errors I Receive, which are, "Could not fetch URL:.." and &...
user avatar
  • 1
0 votes
1 answer
29 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 ...
user avatar
0 votes
1 answer
39 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 ...
user avatar
0 votes
1 answer
89 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. =...
user avatar
  • 11
1 vote
1 answer
66 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 ...
user avatar
  • 11
0 votes
3 answers
544 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 ...
user avatar
0 votes
1 answer
131 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",...
user avatar
1 vote
2 answers
325 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 ...
user avatar
  • 11
1 vote
0 answers
82 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 ...
user avatar
0 votes
1 answer
123 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=...
user avatar
1 vote
1 answer
272 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 ...
user avatar
1 vote
1 answer
1k 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 ...
user avatar
-1 votes
1 answer
121 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.
user avatar
0 votes
2 answers
59 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 ...
user avatar
-1 votes
2 answers
694 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: ...
user avatar
1 vote
1 answer
340 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 ...
user avatar
  • 113
1 vote
1 answer
7k 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
user avatar
0 votes
1 answer
186 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 "...
user avatar
2 votes
1 answer
80 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 ...
user avatar
  • 507
2 votes
1 answer
207 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 ...
user avatar
  • 23
1 vote
1 answer
3k 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&...
user avatar
11 votes
2 answers
19k 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 ...
user avatar
  • 41.8k
0 votes
1 answer
126 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 ...
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 ...
user avatar
  • 1
1 vote
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
607 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?
user avatar
6 votes
5 answers
13k 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 ...
user avatar
0 votes
1 answer
3k 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: =...
user avatar
0 votes
1 answer
5k 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 ...
user avatar
  • 1
0 votes
1 answer
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 ...
user avatar
  • 999
3 votes
1 answer
981 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 ...
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", "...
user avatar
0 votes
1 answer
6k 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 ...
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....
user avatar
-1 votes
1 answer
516 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 ...
user avatar
  • 999
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 ...
user avatar
  • 999
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 "...
user avatar
  • 999
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 ...
user avatar
  • 193
10 votes
2 answers
41k 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 ...
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 ...
user avatar
0 votes
2 answers
4k views

How do I resolve IMPORTHTML showing error #N/A? [closed]

N/A error showing on following query: =importhtml("http://www.barchart.com/commodityfutures/Cotton_%232_Futures/CT?search=CT*","table",1) and =Importhtml(A2,"table",1) Also table id is dt1.
user avatar
  • 19
2 votes
2 answers
1k views

Google Sheets LEFT function trim text generated by IMPORTHTML function

When I use this formula to import data =iferror(INDEX(IMPORTHTML("http://www.thestreet.com/quote/GE/details/company-profile.html","table",3),8,1)) The result is Sector: Industrial Goods. I'd like to ...
user avatar
3 votes
1 answer
4k views

Querying data through importHTML function in Google spreadsheet

I am trying to import table data into a Google spreadsheet using the below function: =ImportHTML( "http://eciresults.nic.in/StatewiseU05.htm" , "table" , 9 ) Following is the result I get out of it. ...
user avatar
2 votes
1 answer
957 views

Extracting GICS codes from Fidelity website

This is the website: https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols=aapl&type=o-NavBar I'm trying to pull out the following two pieces of data into a Google Sheet: ...
user avatar