Ok here’s a plea for any developer who knows how to write browser extensions to write one that lets me do basic spreadsheet operations right in the web page. I would pay $20 for this add-on in its most basic buggy incarnation and up to $50-75 for a pro edition depending on how well it worked. Here’s the issue:
It’s too cumbersome to ask simple questions and do basic data wrangling of tabular numbered data in web pages.
I play with data probably five times a day via various web sites (sometimes our own, sometimes ones in the wild). Here’s a practical example from right now- we’re running some email campaigns for one of our startups and I get this report:
Which is just a set of numbers and has no meaning until you can see relative %’s and how campaigns compare across iterations. I would like to be able to quickly calculate the open rate, CTR and bounce rates of each of these five campaigns. And then get average totaled across all mailings.
Now sometimes you luck out and can copy/paste the table into Excel or Numbers and do basic summing / averaging / math ops there. But it’s a crapshoot – half the time it pastes the entire table into a single column which makes it useless. You wind up w/ this:
(sorry if you haven’t seen this Spinal Tap scene that bread reference will make no sense at all).
Pasting to a desktop app makes you leave the browser and adds just enough friction to the process to where you might not ask a question of the data that you would have otherwise. Google Docs is getting us closer and their copy/paste tends to work better, but that too is still an extra step and cumbersome & flakey. The other alternative on small datasets like this is to Command-Space to open Spotlight and manually run some calculations there typing in the numbers. But alas that sucks as well.
What would be truly spectacular is a FF or Chrome extension that gave me this right in the context of the web page:
Select. Click. Done. Two motions to get immediate insight into tabular data on web pages. Like I said, I’d pay $20 no question for the basic version and if you start adding spiffy extra spreadsheet functionality, that number goes up to $50 and beyond very quickly. This is a valuable/painful enough situation where it would be pretty easy to make me happy even with a crappy extension.
So my question is “would you pay for such an extension?” Heck, I’ll setup a Pledgebank and hire a programmer to create this if enough people want it. I think it could do miracles for startup founders in terms of wiping out the friction associated with casually asking questions of data in web pages. My hunch is some developer could give away the very most basic version and charge a grip for the professional edition similar to how iMacros has done it. Leave a comment or a tweetback if this is something you’d use.