April 08, 2008

EditGrid brings Web 2.0 tricks to spreadsheets

EditGrid's online spreadsheet service provides easy collaboration and integration of outside sources

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 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.

How to use EditGrid

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 like 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 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 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 has its limitations

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.

Close

On Twitter now

Applications

Powered by Twitter

On Twitter now

White Paper

D2D Virtual Tape Library Replication Primer

This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.

Download now »

White Paper

An Alternative to Virtualization for Datacenter Cost Savings

Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.

Download now »

White Paper

Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network

The emergence of WLANs has created a new breed of security threats to enterprise networks.

Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation

Download now »

White Paper

Bringing the Edge to the Data Center

Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.

Download now »

Sign up to receive Applications Resource Alerts

Subscribe to the Today's Headlines: First Look Newsletter

Find out what will be news for the day, with our first-thing-in-the-morning briefing.

©1994-2009 Infoworld, Inc.