Google Spreadsheet xpath scraping <p>So I'm not a professional programmer, but I'm trying to scrape data off the Reuters homepage and import it into google spreadsheets. I know that there have already been questions answerd about scraping from Reuters, however, that didn't help me.</p> <p>I want data from this page: <a href="http://www.reuters.com/finance/stocks/financialHighlights?symbol=9983.T" rel="nofollow">http://www.reuters.com/finance/stocks/financialHighlights?symbol=9983.T</a></p> <p>specifically, if you scroll down, there's a lot of data on the company's financials, packed into tables. I need specific values out of the tables.</p> <p>So naturally my question to you is, how can I get specific values out of the tables? For instance, I want the first value out of the line that's labelled "Net Profit Margin (TTM)". The value should be 7.30.</p> <p>So I got the xpath by using google chrome developer tools, right-click on the element and select "copy xpath". Since I'm not a programmer I dont know any other way for arriving at a specific element from the tables.</p> <p>I tried the following function in google spreadsheets:</p> <pre><code>=IMPORTXML(URL as written above,"//*[@id='content']/div[2]/div/div[2]/div[1]/div[13]/div[2]/table/tbody/tr[14]/td[2]") </code></pre> <p>but it returns</p> <pre><code>"#N/A - Error, imported content is empty" </code></pre> <p>What can I do to get the value?</p>