Posts Tagged ‘spreadsheets’

Create XML Document with Google Spreadsheet, Gadget and HTML Tidy

May 4, 2010

WHO:  The computer user operates a wireless phone business.
WHAT:  The user lists uploaded videos on an external, business web page.
WHERE:  The videos are streamed via YouTube.  But, the XML document is on the user’s shared web server.
WHEN:  There are time saving RSS feed tools already in place at YouTube.  The method described in this post could be outfitted to match the XML output from YouTube.
HOW:  Here is a three (3) step method to convert a Google Spreadsheet to XML…

  1. Create a new spreadsheet in Google Docs.  Fill in one list item per row.
  2. Insert the XML Google Gadget.  Select XML from the dropdown list.  Adjust the cell ranges in the gadget.
  3. Add “<?xml version=”1.0″ encoding=”UTF-8″ ?>” (without quotes) at the beginning of the new XML document.  Use HTML Tidy on the resulting XML, if desired.

WHY:  You can upload documents (including spreadsheets and CSV files) to Google Docs.  Using the method described above, a Microsoft Excel spreadsheet (for example) can be converted into an XML file for an RSS feed (with SimpleXML).