Now that SD is putting his data into Excel spreadsheets, the import procedure is (thankfully!) a lot simpler than the first process:

Step 1:

1. Use Oxygen to convert Excel spreadsheet to XML (File -> Import -> MS Excel File); ensure that "First row contains field names" is checked
2. Save as step_1.xml

Step 2:

1. Transform step_1.xml with transformations/1_to_2.xsl
2. Save as step_2.xml

Step 3:

1. Transform step_2.xml with transformations/2_to_3.xsl
2. Add RNG schema line to the top of the file:
   <?oxygen RNGSchema="http://web.uvic.ca/~lang02/bailey/schema/bailey_trialfile_proofing.rng"type="xml"?>
3. Validate and correct any errors. Given the variable nature of the data, 100% validation probably won't be possible at this point
4. Save as step_3.xml
5. Send the file to SD for proofing/final validating