July 5th, 2007 | Published in Google Docs
The API gave me access to practically all my spreadsheet data, so I had the flexibility to do whatever I had in mind. Within a few hours, I had a pretty powerful little application that could filter using easy dropdowns on each column. But I wasn't done -- I wanted more control over filtering. I added an expression parser that understands "fuzzy" filters -- things like "contains North or New" -- just as well as it understands more precise (but intimidating) traditional expressions.
I clearly went a little overboard with my spreadsheet application, but the point is that the API puts a lot of power into my hands--and yours. If you've got any kind of programming experience, why don't you give it a try ?