Google Docs: Number Crunching

by Scott Roche on May 23, 2011 · 4 comments

in Service

I will admit it, I’m not a power spreadsheet user. I was an English geek in high school and college. I was never into numbers or databases. I did learn a thing or two about them after college when I took some computer programming classes in order to find a real job, so I got to learn more about them than I ever thought possible. That might just make me an ideal user for Google Docs’ spreadsheet feature.

This service gives me everything I need Excel for. I can create and share basic flat file databases. For the non-geek, a flat file database is essentially a collection of information you’d put in a card file full of index cards. There’s no relationship between any of the data. It also appears to have any and all of the requisite functions and formulas that harder core math geeks would need.

Where does this shine? Much of the difference comes, as was the case with the document creator, in the ability to share and comment with other users. There are a few more features that jumped out at me. As with the packaged software spreadsheets, you can quickly and easily make over a half dozen different charts and graphs. With just a few more clicks you can take that and embed it on your website, as I’ve done with the chart below:

The feature that I appreciate even more is the ability to take a spreadsheet you create and make a form from it. I see a lot of people use something like SurveyMonkey when they could use this instead. While SurveyMonkey is a good service, the free account limits the number and types of questions you can ask. With the forms tool you have more options and can ask as many questions as you like and all of the answers populate a database under your control. Better than that, with most online survey tools users have to leave your site to take the survey. With this tool your survey can be embedded directly in the post.

I’d say that, unsurprisingly, Google has hit another one out of the park with this service. While it may not be for hardcore number crunchers, and it may well suit their needs too, if you use basic spreadsheet functionality and you want to be able to share that quickly and easily then this is for you. As I said in the review of their documents services, you wouldn’t want to use this for sensitive data and it’s advisable to download your results and back them up as you would any other important information, but I use this before I use Excel or Numbers.

Previous post:

Next post: