Simple online database collaboration
Forget e-mailing attachments. Specialized services make sharing spreadsheets easy.
If you have to jointly author a spreadsheet with a colleague, what is the first thing that you do? Email it back and forth. This can be painful, particularly as you try to keep track of your partner's changes and hope the emails transit back and forth across the Internet. Add a third or fourth person, and things get worse. Luckily, there is a better way, and a number of providers have stepped up with tools to make spreadsheet sharing a lot easier than sending attachments.
The process is very straightforward: you either copy and paste data or take your spreadsheet and upload it to the service, after creating accounts for you and your collaborators. Then you can make changes via your Web browser, no other software is required. Some of the services allow for more bells and whistles. Setup time is minimal; your data is properly protected by the service and safe from harm. And you don't need to learn any Web/database programming skills either.
For many people, the spreadsheet is still one of the most popular low-end database applications. The rubric of a table of rows and columns is easily understood and can easily be used as a way to view records and fields of a database. Plus, you don't need to design special reports to view your data entries, and you can easily sort your data without having to create data dictionaries or other database structures, just use the appropriate Excel commands. Having a specialized service that can share this data makes it easier to collaborate too, whether your partners are across the office or on the other side of the world -- as long as they have an Internet connection, they are good to go.
There are seven different services currently available, in order of increasing cost:
Online Spreadsheet Sharing Services
|Pagos Spreadsheetlive.com||Free now, $5/mo per user later this year||1 MB|
|Smartsheet.com||$10/mo for up to 10 spreadsheets||30 MB|
|Box.net combined with Google Docs||$15/mo per user||15 GB|
|DabbleDB.com||$24/mo for 3 users or free*||250 MB per user|
|HyperBase||$175 setup plus $44/mo for 5 users||1.25 GB|
|TrackVia.com||$250/mo for 10 users||4 GB for entry plan|
|Intuit QuickBase||$299/mo for 10 users||1 GB for entry plan **|
|*If you don't mind your data being public view for up to 15 users|
|**Can go to 20 GB for more expensive plans|
Next page: Pricing and support
Pricing and support
When you decide on the particular service, it pays to read the pricing fine print. There are discounts for annual subscriptions on most services, and some, such as Smartsheet, offer additional discounts for non-profit and educational institutions. All of these services have 14-day or 30-day free trials to get started, so you can get a feel of what is involved in manipulating your data and how easy it is to make changes, produce reports, and receive notifications.
The downside is that some of these services can be pricey, as you add collaborators. Each service has different ways to count actual "users". For example, if you want to jointly edit the same spreadsheet with two others -- that usually counts as a three-user license. But if you want others to just view your data but not change it, these others usually don't consume additional licenses. Smartsheet doesn't have any user limitations, which is great if you are going to publish it for wide use around your corporation. These services can also get expensive if you need to attach files to particular cells in your database, as you can see from the table above.
Customer support can be extra too. TrackVia, HyperBase, and QuickBase all include phone support in their offerings, and TrackVia actually emails you automatically with the name and phone number of an account rep should you need additional help. Smartsheet offers support on its premium plans that begin at $50 a month, although you probably won't need it because it has copious help pop-up screens and suggestions for first-time users. The others offer minimal support.
Let's review each service and touch on some of their distinguishing features. First is how they notify you of changes to your file's content. Some services give you more control over how they will email you when one of your collaborators has made changes. Another feature is how they can publish your data, if you want to invite others to view it. While this throws all hope of security to the winds, for less secure information it is a great way to start a collaboration process. Some can design very sophisticated reports, others show you your data in the familiar grid layout that Excel uses.
Another thing to look for is how each service loads your data: with some, you can upload an Excel file from your hard drive, while with others you have to either import a comma separated file or manually cut and paste your data from your spreadsheet. Why is this important? If you have more than a simple table of columns and rows, cut and paste will probably not work and you will have some cleanup to do after the import.
Finally, there is the consideration of how much control they give you over the look and feel of your data. Some of the services, such as Smartsheet, TrackVia and QuickBase have dozens of pre-built templates to help you get started with organizing your data, such as client contacts, issue tracking, or expense reports. The others you are left to be your own designer.
One caveat: Web services are constantly being changed, especially prices, as the vendors tweak their offerings. This analysis is based on what we saw in mid-March 2010, so do spend some of your own time checking out particular features that are deal-makers or breakers for you. We also tried to test each service in a wide variety of browsers on both Windows and Mac operating systems, but again, things quickly change in that department too.
Next page: SpreadsheetLive
This service has real potential and is still free and in beta. I had real trouble getting the service to work with importing Excel 2003 file formats, but Excel 2007 worked fine. So I would steer clear until it is more polished.
Next page: Smartsheet
If looks and cost matter and you don't need a lot of storage, then consider Smartsheet. They have templates galore to make it easier to design a good-looking database. They also have all kinds of notification controls, where you can set frequency and what particular content has changed. Smartsheet handles publishing with a single click of a button, with a variety of publishing options too, as you can see from the screenshot below.
Next page: Box.net with Google Docs
Box.net with Google Docs
The newest entry into this field is a one-two punch from Box.net and Google. The process is somewhat complex to link your accounts from each service together, but once you do you can create Google Docs from inside Box that can be shared by others. The downside is that you lose real-time concurrent editing that is found on the other services, but the upside is that you can do some primitive collaboration for next to no cost. The interoperability is only one-way -- meaning a doc that is created on the Google side can't be seen by the Box users.
Next page: DabbleDB
If you don't care about templates or extra features, then DabbleDB is a good place to start. You can quickly create your spreadsheet and have it shared within a few minutes. The only downside is that you have to cut and paste your data, rather than import an Excel file directly.
It will find your field names in the first row of your data, and ask you how you want each column imported (as text or numbers, for example). You can set up Web forms that can be published and used to collect more data to input into your spreadsheets. And you can even add the Google Analytics tracking codes if you want them to keep track of your visitors. DabbleDB offers a way to restore a particular backup snapshot taken on a particular day, or to email you a ZIP file with your data. Finally, you can share more than one spreadsheet per account, even during the free trial.
The other downside to DabbleDB is they are stingy on storage. The basic account only includes 250 MB for any attachments to your files. Additional storage is $10 for every extra 5 GB.
The service gives you your own sub-domain, such as strom.dabbledb.com, so that others can easily find your work, for an extra fee of $25 to $100, depending on whether you want it secured with SSL or not. And for an extra $75, you can place restricted access by particular IP source addresses for your data.
Next page: HyperBase
HyperBase is an add-on to the Web-based HyperOffice, which is a competitor to Google Docs and Microsoft Live Office. You have to purchase an annual contract for the office services before you can make use of the shared spreadsheets in HyperBase. The starter set is for five users, with additional users at less than $10 a month. This isn't really the best platform if all you want to do is share a database, as it is really designed as a full-featured open office product where you can create documents and spreadsheets from inside your browser. Nevertheless, you can design some rather sophisticated forms and data layouts with the product. If you have lots of local Excel spreadsheets this isn't the product for you because you need to first save them as CSVs to upload the data.
Next page: TrackVia
TrackVia has changed its pricing plan, making it more appealing towards the higher-end and with at least ten collaborators on a spreadsheet. But the good news is that it has plenty of features that befit its higher cost. You can import an Excel file, start with one of their existing templates, or start from scratch. There are also different email notifications it can send you when new records are added or elements change, as you can see here:
TrackVia will send you a CD copy of all your data for an additional $100 that will be sent overnight to you. TrackVia has integrated email merge features, so if you set up your spreadsheet for that particular purpose, such as a list of customers that you want to stay in touch with, you can use this service as an inexpensive contact management system (this will cost a penny an email extra). You can also create a public Web page that asks questions that you can use to collect information to include on your spreadsheet. In beta test is a way to graph and chart your data. Finally, there is a function to find and eliminate duplicate records in your data, which can be handy depending on how many authors are entering information.
Next page: QuickBase
At the most expensive, but perhaps the most polished, end of the spectrum is Intuit's QuickBase. Intuit has a reputation for quality online services and QuickBase delivers. It can only import files in CSV and not from Excel formats directly. This is a real database application, and the default operation is to take each row of your spreadsheet and turn it into an individual record. You have lots of controls over reports, and, as we mentioned, tons of templates.
If you want to import your Excel files directly and don't want to pay a lot of money, then start with Smartsheet. They have a nice mix of features and reports, and seem to work in a variety of Web browsers without trouble. If that service doesn't have a rich enough feature set for you, or you want to have more collaborators, then consider TrackVia or QuickBase if you can afford the monthly fees. I would steer clear of the others for the time being.