View XML data as a table

Question

Is there a way I can use Visual Studio to view my XML data in a tabular structure by applying the appropriate XSD to it?

Are there any other tools I can easily use for this purpose? PS: I need this for a one time use.

Answer 1

I'm not sure this answers your question, but I've had plenty of luck opening xml files in Firefox, copying and pasting the result into Notepad, and then importing the text file as a tab delimited file into Excel.

Probably an easier way to do that, but it works for me.

Answer 2

There is an option for this in XMLSpy 2011. A fully functional, 30 day trial is available for download here.

Answer 3

Excel has surprisingly good XML support.

It will even generate the XSD internally if needed.

Answer 4

You can do this in SQL server quite easily using the FOR XML functionality.

A simple adaptation of the code from my answers to these questions would suffice:

• http://stackoverflow.com/questions/3903974/fastest-import-of-a-csv-to-a-database-table/3905436#3905436

• http://stackoverflow.com/questions/3879687/how-can-i-use-single-query-to-insert-multiple-records-from-dataset-into-sql-serve/3879800#3879800

Answer 5

Use Excel to view the XML document, as Oded mentioned.

If you're using Excel 2003, click on Data->XML->Import, and select the XML you'd like to view. Excel will ask you which cell to start the import from, and then populate the spreadsheet with the XML data.