how do you convert an xml file to xls

[speckytecky]

Our Brand New unitary Local Authority has sent out new pupil data for SIMS as an XML file. Is there an easy way to convert it to XLS?

[bossman]

@speckytecky:

I think you are at cross purposes here young man.
Have another look at what you are asking and then re-post.
Convert excel file to excel file???

[Dom_]

His subject is correct though...

[dhicks]

Our Brand New unitary Local Authority has sent out new pupil data for SIMS as an XLS file. Is there an easy way to convert it to XLS?

Assuming you mean "...SIMS as an XML file...". You could write an XSLT transform to format the XML file however you liked, probably just as a simple bunch of columns with data in. You could then view this with a web browser and copy-and-paste to Excel.

--
David Hicks

[Dom_]

Just checked and if I open them in excel i can just 'save as...' xls - using office 2003.

Dom

[Fridge]

Wouldn't it be easier to just open the file click, save as and then save it as the format you want it to be...

edit: posted it a second to late looks like the OP figured it out.

[bossman]

@Dom:

Just read the post not the subject Doh!!!