Questions tagged [importhtml]
For questions specifically about the Google Sheets function: ImportHTML()
70
questions
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 ...
- 1
0
votes
0
answers
26
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-...
- 1
1
vote
1
answer
70
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
0
votes
0
answers
53
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 ...
- 11
0
votes
0
answers
15
views
How to import US 500 data from Investing.com into spreadsheet? [duplicate]
I want to import the live individual stock price in the Google Sheets as highlighted on the image 3,975.9
Is that possible?
https://in.investing.com/indices/us-spx-500-futures?cid=1175153
0
votes
1
answer
35
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"...
- 103
1
vote
1
answer
28
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.
...
1
vote
1
answer
24
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 ...
- 11
0
votes
0
answers
10
views
importhtml not updating when run from script [duplicate]
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 ...
- 1
1
vote
1
answer
751
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 ...
1
vote
1
answer
467
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 ...
- 225
1
vote
1
answer
216
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....
- 11
1
vote
1
answer
32
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
1
answer
79
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
1
answer
133
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.
=...
- 11
1
vote
1
answer
93
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 ...
- 11
0
votes
3
answers
742
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
1
answer
220
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",...
- 3
1
vote
2
answers
506
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 ...
- 11
1
vote
0
answers
122
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 ...
- 124
0
votes
1
answer
227
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=...
2
votes
1
answer
372
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 ...
- 124
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 ...
- 11
-1
votes
1
answer
144
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
vote
2
answers
72
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
2
answers
813
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
1
answer
363
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 ...
- 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
- 21
0
votes
1
answer
193
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 "...
- 188
2
votes
1
answer
83
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 ...
- 507
2
votes
1
answer
230
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 ...
- 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&...
14
votes
2
answers
25k
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 ...
- 43.2k
0
votes
1
answer
130
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
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 ...
- 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.
...
Jake Havenridge
1
vote
1
answer
651
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?
- 303
6
votes
5
answers
14k
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 ...
- 303
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:
=...
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 ...
- 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 ...
- 1,103
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 ...
- 31
-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", "...
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 ...
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....
-1
votes
1
answer
544
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 ...
- 1,103
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 ...
- 1,103
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 "...
- 1,103
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 ...
- 225
10
votes
2
answers
47k
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 ...
- 103