Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there any Excel-like software for XML data?

Something not restricted to spreadsheet format, but allowing:

  • data with hierarchy
  • more strict typing
  • tagging
  • multiple views to the data, unlike Excel's plain spreadsheets

For example, in a kind of a music library, if we have artists, albums and tracks, and each of them has a few attributes, and some attributes are numeric, some are sets of tags (where order is not important), some are lists (where order is important).
We'd need to edit, browse, filter this data dynamically, do basic calculations, and keep relations between entities.

share|improve this question
    
Spreadsheet programs and the functions they offer are bound to the paradigm of information ordered in a 2-dimensional grid. XML is completely different – information is represented as a tree. Can you give an example of what data you have and what you want to do with it? –  slhck Mar 2 '12 at 15:05
    
For example, in a kind of a music library, if we have artists, albums and tracks, and each of them has a few attributes, and some attributes are numeric, some are sets of tags (where order is not important), some are lists (where order is important). And we need to edit, browse, filter this data dynamically, do basic calculations, and to keep relations between entities. –  Ognjen Mar 2 '12 at 15:38

2 Answers 2

As the comment by @slchk states, there is a difference in the foundations of a spreadsheet's use and XML which is tree based. The spreadsheet is 2D and XML is better for a directory structure of music like you suggest, I have briefly been introduced to oxygenxml link which has many nice views. It has a nice interface for editing data manually, but I don't know how well it interfaces with maybe your own scripts etc. But I guess you could work with the xml it exports.

share|improve this answer

I have been looking for something like this for a long time, with the advent of XML and XHTML, I find that it would be useful to populate XML type data from a spreadsheet.

The following systems are close to the functionality that you describe, however its not 100 percent.

Altova XML Spy grid view:

enter image description here

One with good potential is the XMLMind software. The ellipsis indicate that there is a complex one to many relation within the cell, clicking on it reveals the detail.

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.