Content has been updated elsewhere, would you like to reload?

*** Warning: If you do not reload, you may be editing obsolete contents. This may cause you to lose recent changes.

Yes, reload    |    No, keep this older content
Overview
  • Google Spreadsheet's ImportXML function is easy to use, and can sometimes look magical. You can use it to grab Web page or blog title and subtitles,  stock prices, or movie info from IMDB. You can summarize data, extract Wikipedia table, and so much more. Here is a list of excellent tutorials. Google also has related and useful spreadsheet functions such as ImportData, ImportHTML, ImportFeed. What do you do if the new Google Sheet yield inexplicable errors?

    • What is ImortXML from Google Spreadsheet?
    • How can I use them? What are some examples of use?
    • Where can I find simple and effective tutorials to learn from?
    • Where can I find sample codes?
    • What other Google Spreadsheet functions are there?
    • What do I do if the importXML function yield error about parsing? Try the older Google Sheet http://g.co/oldsheets
  Dishes  - Intro to ImportXML
  • Dish 2 : Chapters 3 and 4: The ImportXML Guide for Google Docs | Distilled.net

  • This is an excellent overview of ImportXML function with detailed examples in 9 short chapters.

    Chapter 3 - Why should I care about using ImportXML?

    We can now look at a page, decide what information we want by looking in the source code, finding the HTML element and by using Xpath we can dig it out.

    ImportXML is how we’re going to pull it in. ... Instead of copying and pasting information from a bunch of websites, this is will do it in 2.2 seconds. It automatically pulls it into a spreasheet so you can work with your data however you want.

    If you’re a trader, you can automatically pull in all your stocks into one spreadsheet effortlessly. If you’re an SEO, you can acquire 100’s of link targets from around the web. If you’re an online retailer, check up on your competitor’s pricing for Product XYZ as soon as it changes!

    Chapter 4 - Your first ImportXML lesson ...

  • Dish 3 : ImportXML Cookbook | SEER Interactive

  • Here’s a collection of ImportXML functions that I’ve collected over the past few months. Some of them I grabbed from other folks, others I’ve made myself.

    This post won’t introduce you to ImportXML.  If you don’t know what ImportXML is go read this EPIC post by the guys at Distilled: “The ImportXML Guide for Google Docs”. If you do know how to use ImportXML then this will be a fun Sunday afternoon project!

  • UPDATE: (May 9, 2012) Added more here: More ImportXML Cookbooks Here’s a collection of ImportXML functions that I’ve collected over the past few months. Some of them I grabbed from other folks, others I’ve made myself. This post won’t introduce you to ImportXML.  If you don’t know what ImportXML is go read this EPIC post by the …
  • Dish 5 : Learn ImportXML - Best SEO Tool Ever | ZoomSpring.com

  • If you haven’t heard of ImportXML yet, or just haven’t got around to using it, you need to learn it now. Why?

    - It’s not very hard
    - It’s free and awesome
    - It will save you tons of time if you do any work online and make you very happy! Yaaay

    [This tutorial is detailed and practical. It uses a spreadsheet script.]

  • I am not a developer. But learning how to use ImportXML with Google Docs has been one of the most interesting things I’ve done in the past few weeks. If you haven’t heard of ImportXML yet, or just haven’t got around to using it, you need to learn it now.
  Chops  - ImportData & ImportHTML
  • Chop 5 : ImportHTML - How to Import Web Data into Google Docs | labnol.org

  • You have been using Google Docs to create basic documents and spreadsheets but did you know that Google’s cloud-based Office suite can do even more.

    For instance, you can directly import data from web pages and edit it inside Google Docs. You can translate the text of a cell from one language to another. You can read RSS feeds inside Google Docs. You can even use Google Docs for monitoring web page changes – this is handy for tracking price fluctuations for a product on any shopping website.

    You don’t have to be a geek nor do you have to write any scripts to do such amazing stuff inside Google Docs. All you need to know is a couple of Google functions – ImportFeed, ImportHTML and ImportXML – and you’ll have a head start. Ready?

  • This video tutorial explains how you can import web data - like HTML tables and lists - from external web pages into your Google Docs sheets with a simple formula.
  Desserts
  References and More

You are welcome to

  • Sign in through   Sign in or sign up with your Facebook account   Sign in or sign up with your Google account   Sign in or sign up with your Amazon account
  • Create your own Web list!
  • Save this into your reading list.
  • Write a comment below.
  • Share this Web list through email or with other Readish users.
      
Course info
  Comments
7  10  0  9  0
      
Language: EnglishThis course is owned by Durio
By Durio

 For Readish.com
Suggested courses    Hide
 For Readish.com
  • Move to:
  •    
       
       
       
Open All         >>