Extensible Markup Language - a set of rules for encoding documents in machine-readable form.

learn more… | top users | synonyms

3
votes
1answer
430 views

How to extract website title into row?

How to extract title (or other meta descriptions) of the website into row using Google Docs? E.g. www.google.com
3
votes
2answers
495 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. ...
2
votes
1answer
175 views

ImportXML with XPath does not return an entry of a table

Using Google Sheets with IMPORTXML to scrape a piece of information from a website via XPath. Here's the site (click here). The specific piece of information I'm trying to extract is the Price/Sales ...
2
votes
1answer
100 views

Extracting GICS codes from Fidelity website

This is the website: https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols=aapl&type=o-NavBar I'm trying to pull out the following two pieces of data into a Google Sheet: ...
2
votes
1answer
28 views

Present importXML output in reverse order

How to reverse the order of the output of imporxml? For example, =importxml("http://example.com","//p") outputs +---+---------------------+ | 1 | This domain is ... | | 2 | More information... | ...
2
votes
1answer
322 views

Fetching category based XML Feeds

I am working on a web app for which I have to fetch RSS feeds for a specific website. Initially I was using Yahoo pipes but later on I found Yahoo pipes can not filter feeds as per categories. So ...
2
votes
0answers
32 views

Import site URLs to Google Sheet (and add new row each time)

I am trying to make a list of site pages that will automatically update in Google Sheets, while keeping the full history rather than overwriting older rows with new ones. I see two possible ways of ...
2
votes
0answers
333 views

Is there an online XML generator to generate xml code from a list of values ? [closed]

Is there an online XML generator to generate XML code from a list of values ? i.e. Value1 Value2 Value3 Value4 Value5 Value6 <item>Value1</item> <item>Value2</item> ...
1
vote
2answers
764 views

Parsing JSON with IFTTT?

I'd like to create an IFTTT action that allows triggers based upon a certain electricity price threshold. This Xively feed can return the current price in either JSON, XML, or CSV formats. Xively's ...
1
vote
2answers
3k views

How to get Google search results in a simpler format?

Google search requires a JS enabled web browser to display the results. But I want a simple XML or JSON format, so my app can parse it. I looked into Web Search API but it is deprecated. I looked ...
1
vote
1answer
37 views

Prevent importXML from spilling text across multiple columns

When importing chat transcript by importXML, e.g., =IMPORTXML("http://chat.stackexchange.com/transcript/7/2015/8/13", "//div[@class='content']") I find that some messages split across several ...
1
vote
1answer
106 views

ImportXML formula no longer working

Here is the formula: =ImportXML("http://www.bloomberg.com/quote/7501:JP", "//div[@class='price-container down']//div[@class='price']") As of several days ago, this formula stopped working. Why ...
1
vote
1answer
246 views

IMPORTXML Google Spreadsheet Amazon review numbers

I am making a spreadsheet which requires me to have the number of amazon reviews of a product. I looked up how to dynamically update the reviews as more came in and came across the IMPORTXML formula. ...
1
vote
1answer
758 views

If This Then That (ifttt) Preserve Whitespace RSS Feed

Can anyone help me out with a method to preserve white space/line breaks in an RSS-feed-to-email ifttt task? I have tried using xml:space="preserve", <![CDATA[ <br> ]]> and just plain ...
1
vote
0answers
52 views

Using Google Spreasheet's IMPORTFEED or IMPORTXML Function to Download Multiple Columns

I'm accustomed to using Excel's XML mapping to download RSS feeds and select the column fields to display. I'm currently using Google Spreadsheet's IMPORTFEED and IMPORTXML functions and trying to ...
1
vote
0answers
243 views

edX numerical input error “Sorry couldn't parse formula” when using inequalities

I am trying to create a question on edX Studio where the answer is an inequality. As far as I understand edX used the Mathjax library for which \ge or &ge; represent the ≥ symbol. I can use \ge ...