We’re rewarding the question askers & reputations are being recalculated! Read more.
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....


3

Tl;Dr Using Chrome, Open the URL of the source data. Press F12 to open Chrome Developer Tools Press Control+Shift+P to open the Command Menu. Start typing javascript, select Disable JavaScript, and then press Enter to run the command. JavaScript is now disabled. JavaScript will remain disabled in this tab so long as you have DevTools open. Reload the ...


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 ...


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 ...


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