Google Docs XML Feed

  • Create Google spreadsheet
  • Share
    • Publish As Webpage
      • More Publishing Options
        • File Format: RSS
          • Generate URL
  • Set up TransformDoc   
  • /O2NetDev/Applications/TransformDoc/default.aspx?XmlDoc=http://spreadsheets.google.com/feeds/list/pRtmodZF-c5KZRzPuMKqTKQ/default/public/basic?alt=rss&XsltDoc=/xslt/googleSpreadsheet.xslt
  • RSS Feed
    • It lower cases the column names
    • First column is "title"
    • All remaining columns are "description" - deliniated by ", columnName: " (colon)
  • Viewing RSS XML feed through browswer
    • Using IE Tester, open IE7 panel and open URL - it will show up in regular XML form where as normal browser open as RSS feed