Here is neat trick to load a Wikipedia data table in Google Docs.

Let’s take the list of countries by population for instance.

Google Docs allows HTML to be imported via the “=ImportHtml” function.  The function requires the URL of the HTML document, the HTML element to extract data from (table) and the position of the HTML element (2nd table).

Google Docs does the rest and creates a spreadsheet that can be shared, exported or saved.

You may also like:

  1. Track Visitors To Google Docs; Know When People Open & Read Your Documents
  2. Perform OCR with Google Docs – Turn Images Into Editable Documents
  3. Open Your Google Docs Presentations in Microsoft PowerPoint
  4. Build a Web Page Monitor with Google Docs and Track Changes Automatically
  5. Open your Google Documents Directly into MS Office with Cloud Connect