Looking for help pulling specific cells from a web site into a Google Spreadsheet. I want to pull "last" price from this page but only a few specific ones. Such as Dow, Nasdaq 100, S&P 500, S&P 400 Mid Cap and Russell 2000. I tried using ImportXMLand managed to import the whole table but can't seem to figure out how to pull just those cells. I also want to be able to do each cell individually so I can move and adjust the spreadsheet to my liking.

  • So what’s your question?
    – Alex
    Commented May 27, 2014 at 7:55

2 Answers 2


You might try:


for the NASDAQ 100 Index and adjust the 5 to suit for others.


The following setup will return the last price for NASDAQ 100 Index (NASDAQ Calculation)

A1: http://bigcharts.marketwatch.com/markets/indexes.asp
A2: =//tr[contains(.,'NASDAQ 100 Index (NASDAQ Calculation)')]/td[4]
A3 Formula: =IMPORTXML(A1,A2)
A3 Result: 4,512.54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.