Questions tagged [importhtml]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
2k 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 ...
8
votes
6answers
13k views

What are the refresh characteristics of the Google Spreadsheet Import functions?

The imported data is not always up to date with the source pages when I load the spreadsheet. When this happens, F5 refresh does not help. Nor does Ctl-F5. Apparently there is some kind of caching ...
3
votes
2answers
889 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....
3
votes
1answer
579 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
vote
1answer
4k views

ImportHTML spreadsheet function to update every 5 mins

I have a Google Spreadsheet fetching stock exchange data using an ImportHTML function: =ImportHtml("http://www.xxxx.xx.xx/xxxxxxxx/livefeedfull.aspx/?"& year(now()) & month(now()) & day(...
3
votes
3answers
3k views

Import current price from website to spreadsheet

As you can probably gather from the title, the goal is to plug the current price of this product into a spreadsheet. Perhaps I'm over-complicating things, but there must be an easy way to do this. ...
5
votes
2answers
2k views

Can a Google Spreadsheet be recalculated if it's not manually opened?

We have some Google Spreadsheets that use the ImportHtml() to pull in some real messy tables. Then on on an alternate page we access the above data and pull it into a nice cleanly formatted table via ...
0
votes
1answer
594 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 "...
4
votes
1answer
2k 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 ...