Questions tagged [importhtml]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
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?"...
0
votes
1answer
28 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....
0
votes
0answers
8 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 &...
0
votes
1answer
26 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 ...
0
votes
1answer
27 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 ...
0
votes
0answers
24 views

Import data from Investing.com or other sites into spreadsheet not possible anymore? [duplicate]

I wanted to import from the section of historic data high/low prices in weekly ranges. For example from this site: https://www.investing.com/indices/us-30-historical-data I tried =INDEX(IMPORTHTML(&...
0
votes
1answer
69 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. =...
1
vote
1answer
56 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 ...
0
votes
3answers
421 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 ...
0
votes
1answer
97 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",...
1
vote
2answers
191 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 ...
1
vote
0answers
58 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 ...
0
votes
1answer
93 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=...
1
vote
1answer
218 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
1answer
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 ...
-1
votes
1answer
115 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.
0
votes
2answers
50 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 ...
-1
votes
2answers
622 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: ...
1
vote
1answer
324 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 ...
1
vote
1answer
6k 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
0
votes
1answer
185 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 "...
2
votes
1answer
78 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 ...
2
votes
1answer
179 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 ...
1
vote
1answer
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&...
10
votes
2answers
16k 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 ...
0
votes
1answer
124 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 ...
0
votes
2answers
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 ...
1
vote
2answers
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. ...
1
vote
1answer
577 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?
6
votes
5answers
12k 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 ...
0
votes
1answer
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: =...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
3
votes
1answer
949 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 ...
-1
votes
1answer
988 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", "...
0
votes
1answer
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 ...
3
votes
2answers
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....
-1
votes
1answer
497 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 ...
3
votes
1answer
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 ...
0
votes
1answer
1k 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 "...
0
votes
1answer
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 ...
9
votes
2answers
35k 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 ...
4
votes
1answer
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 ...
0
votes
2answers
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.
2
votes
2answers
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 ...
3
votes
1answer
3k 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. ...
2
votes
1answer
936 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: ...
5
votes
1answer
2k views

How to split multiple values in one cell into separate cells?

I'm using ImportHTML to pull in data scraped using another tool called Import.io, as you can see in the example spreadsheet here. However, when I pull in data using ImportHTML, it's pulling three ...
1
vote
1answer
368 views

Get the sum of every row in a table imported with Importhtml

I've figured out how to import HTML table into Google spreadsheets, but is there a way to sum a row? I want to get a sum of Total Revenue from Nasdaq. This allowed me to pull the quarterly data from ...
6
votes
2answers
3k views

With Google Docs/ImportHTML(), how do I then modify the data?

I'm using ImportHTML() on a Google Sheet to import a large table from a website. It's great, and it's now all there, but now I want to hand-modify the data to my needs. Unfortunately, every time I try ...