On the centrality of Excel

I have a very specific use case in mind for Enterprise Web 2.0, which consists of a business analyst mailing around spreadsheets and I’m sure it’s consistent from company to company.

There are a lot of people who are skilled Excel users who can do sophisticated analysis and reporting but who are cruelly (cruelly!) limited by their available tools. It would be fantastically useful for them to be able to call external services using something simple and familiar like Excel formulas.

A lot of times, people use Excel *just* for presentation, which is absurd, of course, but they know how to do it. HTML would be better, but it’s not as widely known. Most people I work with have never touched HTML or even know to look at “view source” in their browser.

Have you ever tried to move Excel tables onto the web? Someone who went to the trouble of creating an Excel export to HTML tables would be doing everyone a great favor.

Then all you have to do is add some all-important eye candy and publish it, so that instead of emailing around zipped files of multi-tabbed Excel extracts from Oracle databases, you could have a URL perhaps with an RSS feed that would give me the three numbers that I really need: revenue, utilization, and pipeline for my practice.