EditGrid Brings Web 2.0 Tricks to Spreadsheets Arizona

Excel is synonymous with spreadsheets for many of us. But EditGrid, a new online spreadsheet service, could convince you that Microsoft's product isn't the best financial analysis tool under all circumstances.

EditGrid supports some online mashups, letting you insert stock-price charts and other graphical data from services such as Alexa, Compete.com, Google Charts, Reuters, and Yahoo Finance. EditGrid offers both more and less than Excel does. The online service makes collaborating with others easier, and provides the ability to import and integrate charts and other Web 2.0 material from online sources such as Google and Reuters.

Hard-core spreadsheet wranglers might be disappointed with EditGrid's lack of full support for keyboard shortcuts, and its omission of some high-end capabilities. And like all online spreadsheets, EditGrid suffers from slower file retrieve and save operations. But occasional users who create small to midsize spreadsheets should be quite satisfied with EditGrid, the Personal Edition of which is free.

To use EditGrid, you need only a broadband Internet connection and a Web browser that supports JavaScript. You must sign up for a free account, which is quick and painless. You can upload existing spreadsheet files up to 2MB (8MB in the paid service) created in Excel, OpenDocument, Lotus 1-2-3, or certain other formats.

One of the prime advantages of online services such as EditGrid is that they let you collaborate on spreadsheet creation and then share the result easily. EditGrid's real-time update permits more than one user to work on a spreadsheet at the same time. It also has a handy chat capability that allows collaborators to communicate. You have the option of creating and saving private sheets or making them available to the public, as well.

Sounds like Google's and Zoho's online spreadsheets, right? Well, EditGrid has some tricks that the competitors lack. EditGrid supports some online mashups, letting you insert stock-price charts, exchange rates, and other financial data from services such as Alexa, Compete.com, Google Charts, Reuters, and Yahoo Finance. EditGrid also publishes an API (application programming interface) that lets you integrate the service with your existing applications, though you will need some technical knowledge to accomplish that.

Like other online services, EditGrid offers optional plug-ins that enhance its capabilities; one allows you to open EditGrid sheets within Excel. EditGrid also integrates with the customer relationship management (CRM) service Salesforce.com.

Unlike the online services from Google and Zoho, however, EditGrid concentrates on spreadsheets only, not on word processing or presentations. The specialized approach pays off with better collaboration features and, in the paid Subscription Edition, with more administrative capabilities.

EditGrid offers most of the spreadsheet capabilities of Excel, with the notable exceptions of macros, pivot tables, data validation, and cell merge, among several other missing features.

The biggest disappointment is that EditGrid lacks full support for keyboard controls, such as those called up by the slash command. For a knowledgeable spreadsheet user, such keyboard controls are quicker than pointing and clicking on a mouse-driven menu.

You will wait longer to save or retrieve spreadsheet files than if you were working on a local hard drive, too. However, most of the other spreadsheet functions, such as copy and paste, operate just as fast as their counterparts do in Excel.