7

Oddly enough - in this exact situation - I played around with the page, a couple functions, variations, but the change that actually pulled in the data was simply changing the url from http to https.. see below image for live content successfully pulled


5

The solution was to select all the cells (I can't find a Select All menu item, but on OS X Command-A worked), then choose Copy, then Paste special/Paste values only. Bingo: all the cells whose values depend on the ImportHTML() in A1 now have their values pasted.


5

ImportHTML does not support authentication. The data has to be publicly available for you to use this function. This applies to ImportXML & ImportFeed also.


3

You could concatenate the URL from another cell. Let's say you have 3 columns, where each column header is a name: Tom | Jerry | Daffy ... and that you want row 2 - X to be populated by the importHTML function. Then, in row 2 column A, you would write =importHTML("http://www.schoolgrades.com/" & A1) This will be interpreted as =importHTML("http://www....


2

Short answer You are right, the import functions updates their result at certain intervals. Explanation From Change a spreadsheet's locale, time zone, recalculation, and language, a help article from the official documentation, Note: External data functions recalculate at the following intervals: ImportRange: 30 minutes ImportHtml, ImportFeed,...


2

It seems wodindex.wikispaces.com attempts to store a cookie, and then do some fancy redirect tricks, for reasons I don't know. The functionality behind ImportHTML needs to work as a browser (or at least an HTTP client), and probably does not support cookies. This is what I get from running wget http://wodindex.wikispaces.com: --12:41:12-- http://wodindex....


2

You might try: =index(importhtml("http://bigcharts.marketwatch.com/markets/indexes.asp","Table"),5,4) for the NASDAQ 100 Index and adjust the 5 to suit for others.


2

The error in your importxml was in the xpath syntax. here is the correct one: =CONCATENATE(IMPORTXML("http://www.walmart.com/ip/Morton-Sea-Salt-Fine-Salt-17.6-oz/10849552","//*[@itemprop='price'][1]")) edited: added the [1] at the end of the xpath to prevent the duplicate price.


2

I got it to work with this: =QUERY(ImportHTML( "http://eciresults.nic.in/StatewiseU05.htm" , "table" , 9 ), "SELECT * where Col2>0",0)


2

Regarding why INDEX does not work when there are named ranges as parameters, but does work in the other cases, it is not clear to me yet. I was thinking that the problem is that INDEX requires that its first parameter be a reference to a spreadsheet range, as it's stated in the official documentation. Besides the formula forms that you already found, you ...


2

You cannot modify the data provided fetched with IMPORTHTML: if you do, you'll indeed either erase it all (if you modify the cell containing the IMPORTHTML function), or a reference error. However, you can achieve your goal by referencing the imported data from another sheet. Let's assume you have your IMPORTHTML call within sheet Sheet1. You can create a ...


2

Possibly try a different approach. Don't use query but instead, in A1 and copied across to B1: =index(IMPORTHTML("http://www.thepowerof10.info/athletes/profile.aspx?athleteid=800922&viewby=date","table",18),,column()) Then either format ColumnB as Duration (and accept some extra zeros) or also use the plain IMPORTHTML as the source to copy format only ...


2

The error occurs because spreadsheet functions like importHTML can't be calculated by Google Apps Script. The Class UrlFetchApp it's able to get content from a URL. Once the script got the content, it should parse it, but there is a problem, Google Apps Script doesn't include a robust method that work with any web page. If the web page to import is XHTML ...


2

IMPORTDATA, IMPORTFEED, IMPORTHTML and IMPORTXML are able to get content from resources hosted on websites that are: Publicly available. This means that the resource doesn't require authorization / to be logged in into any service to access it. The content is "static". This mean that if you open the resource using the view source code option of modern web ...


1

You can do this in a single formula using array_constrain, query, index and regexreplace: ={ARRAY_CONSTRAIN(IMPORTHTML("http://www.sportsnet.ca/hockey/nhl/standings/", "table"),100,10),arrayformula(REGEXREPLACE(query(text(IMPORTHTML("http://www.sportsnet.ca/hockey/nhl/standings/", "table"),"M-D-YYYY"),"select Col11,Col12,Col13"),"(\d-\d-)(\d\d\d)(\d)","$1$...


1

Formulas For columns 1-10 On cell A1 add the following formula: =ARRAY_CONSTRAIN(IMPORTXML("http://www.sportsnet.ca/hockey/nhl/standings/", "(//table)[1]//tr"),2000000,10) For columns 11-13 On cells K1 to M1 add the following formula on each cell =ArrayFormula( TEXT(IMPORTXML("http://www.sportsnet.ca/hockey/nhl/standings/", "(//table)[1]/*/*/*["&...


1

ARRRGH! It was user error. I did in fact have a now() embedded many levels deep in a nested formula that was a leftover from an experiment I did recently, and totally forgot about. Removed it and presto... all is well. Thanks to all who tried to lend a hand on this one!!


1

On mouse over the cell's top right corner, Google Sheets shows extended error description "Import Internal Error": That means that there is an error one the Google side. You could report it by clicking in Help > Report a problem Google Sheets' menu and filling out and submitting the feedback form.


1

There are a couple ways to do it: If you specifically want to get rid of only that one element that shows up as "Sector" you can use the substitute function: =substitute(iferror(INDEX(IMPORTHTML("http://www.thestreet.com/quote/GE/details/company-profile.html","table",3),8,1)),"Sector: ","") alternatively, if you would like the function to remove any of ...


1

Short Answer Instead of LEFT() use RIGHT(). Explanation The LEFT() function returns the leftmost characters, but the OP want to get the rightmost characters. The following is a simplified version of the final formula, for explanatory purposes: =RIGHT("Sector: Industrial Goods",16) The following is the final formula; in order to improve readability, ...


1

Ultimately, I can't do it with Google's functions. As a result, I decided to write a custom function. Go to Tools -> Script Editor. Click "Spreadsheet" on the left hand side to create a new document. Scroll down and paste the following code in: function getWalmartPrice(url) { var html = UrlFetchApp.fetch(url).getContentText(); //Can't create document ...


1

UNTESTED (because for example the Nairobi Stock Exchange is closed at present) but & year(now()) & month(now()) & day(now()) & hour(now()) & MINUTE(), to & A1, with =int(minute(now())/5) in A1 may be worth trying.


Only top voted, non community-wiki answers of a minimum length are eligible