I’m offering my first free open source program; it's under the GPL license.
This program uses an Microsoft Excel VBA macro to convert XML-based Continuity of Care Documents (CCDs) into a stripped down Comma Separated Value (CSV) file. The CSV contains all the relevant data without formatting instructions, which is literally the most efficient way to distribute raw data. The CSV can then be consumed and formatted by spreadsheet templates or other programs.
I am looking for help porting the application to OpenOffice or other suitable FOSS applications.
The Excel macro opens CCD XML file as a form is a spreadsheet, based on formatting instructions from its corresponding XSL file. The macro then strips out the blank rows and table of contents, and then saves the raw data and labels in a CSV file. Although designed to for a particular CCD format, the macro can be modified to work with any XML/XSL file, and is not limited to CCDs.
You may download a free copy of the file from SourceForge at http://sourceforge.net/projects/convertxmltocsv/