Create XML Document with Google Spreadsheet, Gadget and HTML Tidy

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).

Advertisements

Tags: , ,

One Response to “Create XML Document with Google Spreadsheet, Gadget and HTML Tidy”

  1. Broughton Gilpin Says:

    I have not had any lock using this XML Gadget you directed us to. This gadget requires a URL which I copied from Pamela’s web site. I am not able to go beyond the URL point.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: