Binary XML vs. Excel

02 Aug, 2006
Xebia Background Header Wave

In this post I’d like to point out some ideas regarding Binary XML and Excel.
The W3C‘s XML Binary Characterization Working Group started in the summer of 2003 and its first activity sparked protest from XML experts around the world. The Binary XML concept has been discussed before, exchanging ideas why a less verbose XML is necessary.
One year ago the XBC Working Group published their documents and continued their efforts at the Efficient XML Interchange Working Group, sadly without gaining too much interest. The problem is, Binary XML would be a whole new set of specifications, creating new problems: it would be humanly unreadable, new and updated tools, parsers and editors would be necessary, and a new set of agreements would have to be made for e.g. well-formedness validations.
Why do we invent a Binary XML when we already have a perfectly useable alternative: Microsoft Excel?
Excel is used for all kinds of purposes, even many it was not designed for: requirements, structured specifications, messages, issue tracking, timesheets, project management, timeseries data and — of course, calculations. That makes Excel as much ‘general purpose’ as XML is.
What’s more, it is already used by countless numbers of users worldwide. Nowadays non-Microsoft tools are able to take care of the Excel file format, so the usefulness of Excel spreadsheets is extended beyond the Microsoft Windows platform.
An Excel sheet is a binary format which simple human beings know how to deal with: we can open those spreadsheet files in our favourite office suite and look, analyse and modify what’s in there. It’s even more user-friendly than XML itself! No more tag balancing, no more character escaping! Spreadsheets lend themselves perfectly for mixed human-computer message exchange. For instance, a questionnaire or a timesheet could be provided as an Excel template, filled in by a user and processed by an administrative system, using the user’s favourite Spreadsheet application and software like Jakarta POI.
It’s a shame that most spreadsheets are only used by users, and almost never processed by software, which is a very real and practical option…
When will businesses go all the way and use spreadsheets to implement c2b or b2b messaging?


Get in touch with us to learn more about the subject and related solutions

Explore related posts