I would like to be able to read that into a simple software, like
Excel or Access, in order to do manipulation of the data (that are not allowed in EndNote).
Unfortunately, I am not aware of a simple utility or tool that will do what you are asking. There are a number of options available, however, depending on how much programming you are able to do.
Option: convert EndNote XML into CSV
Since Excel can read CSV files, you are not required to convert EndNote XML into MSFT XML in order to work with your data in a spreadsheet. Moreover, you are likely to have better luck finding a tool, or a programmer who can convert XML into CSV, since CSV is not (AFAIK) a 'proprietary' format (whereas MSFT XML is).
Option: open your EndNote XML in an XML editor and do your work there
Option: Write a program or script in any language that can convert You can write a program or a script that can read the EndNote XML and convert it into MSFT XML Spreadsheet format yourself. Although it is not a simple point-and-click solution, you can do it if you know three things:
1) The specific version of EndNote XML you are working with
2) How to produce MSFT "Spreadsheet XML" for office 2002
3) How to write a script that converts part 1) into part 2)
If you Do a search on msdn.microsoft.com for:
"XML Spreadsheet (XMLSS) schema"
you will find the reference that enumerates how to generate XMLSS files that will open in MSFT Excel.
This option is obviously the most complicated, especially if you are not able to write a program that does this. Any language capable of reading and writing XML should work.
I took a glance at some EndNote XML on the web, and it looks like you will have to also decide *what part* of the EndNote XML you will want to work with, since the whole EndNote XML file will probably not translate easily into a single spreadsheet. (eg do you want to work with the 'authors' section or something else?)
