Three (3) Methods to Convert Spreadsheet DATA to XML - Using Google Docs or Microsoft ACCESS or Microsoft Excel

Method 1: Using Google Docs

XML-XSLT] How to Convert a Google Spreadsheet into JSON XML and MySQL :

http://otherfancystuff.blogspot.com/2009/05/how-to-convert-google-spreadsheet-into.html

http://pamelafox-samplecode.googlecode.com/svn/trunk/spreadsheetsconverter/spreadsheetsconverter.xml

Method 2: Using Microsoft Excel

1. CREATE an XML template for your spreadsheet data.
   INCLUDE at least two (2) rows of data.
•  
  <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<TestFeb xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<row>
    <Date>:01/01/01</Date>
    <Thread>:[IMC-Satellite] palestine IMC</Thread>
    <List>:New</List>
    <Author>:cburn</Author>
    <URL>:http://archives.lists.indymedia.org/new-imc/2001-December/001350.html</URL>
    <Notes>:rachel leah jones?</Notes>
</row>
<row>
    <Date>:01/10/02</Date>
    <Thread>:Proposed new IMC!</Thread>
    <List>:New IMC</List>
    <Author>:calluna</Author>
    <URL>:http://archives.lists.indymedia.org/new-imc/2002-January/001446.html</URL>
    <Notes>:original proposal</Notes>
</row>
</TestFeb>

2. Import CSV data into EXCEL as TEXT. [IMPORTANT! Dates/currencies will not convert correctly.]
1. OPEN new document/spreadsheet
• SELECT DATA --> From Other Sources --> From XML Input
• SELECT XML schema from #1 above.
• COPY original data set to new sheet
• SAVE AS -->: workbook
• SAVE AS --> XML data
2. VIEW XML data

Method 3

1. IMPORT data (from .csv) into a new Access database/table
• FROM 'Import Text Wizard'
• CHECK 'First Row Contains Field Names'
• CHECK 'No primary key' (unless you want a UNIQUE IDENTIFIER)
2. SELECT 'External Data' --> 'Export' --> 'More' --> 'XML file'
3. ACCEPT default options in 'Export XML' dialog box ['Data (XML)' 'Schema of the data (XSD)']
4. REVIEW new file .XML
1. Step 1
2. Step 2
3. Step 3
4. Step 4
5. http://www.aspfree.com/c/a/Microsoft-Access/Exporting-XML-from-MS-Access-2003/