We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Software Reviews
15,670 Reviews

Google Spreadsheets free online spreadsheet application

free

Manufacturer: Google

Our Rating: We rate this 4 out of 5

If you carry around a laptop so you can show clients your latest marketing forecasts, you can save yourself the bother by using Google Spreadsheets.

If you carry around a laptop so you can show clients your latest marketing forecasts, you can save yourself the bother by using Google Spreadsheets.

Google Docs, previously known as Google Docs and Spreadsheets, now adds presentation functionality. Click here for PC Advisor's full review.

Google Docs & Spreadsheets provides editable spreadsheets that are compatible with Microsoft Excel. And, best of all, you and your colleagues can modify them simultaneously.

See PC Advisor's Google Docs review. Click here for PC Advisor's Google Docs & Spreadsheets review

Using spreadsheets

When you open a document in Google Spreadsheets, you see a standard spreadsheet grid with resizable rows and columns, and the usual array of options for formatting. You enter text or numbers in spreadsheet cells, as you would with any other spreadsheet application.

Using icons and menus on the Google Spreadsheets toolbar, you can merge cells; apply borders and highlighting; change fonts, font sizes and styles; and choose whether to wrap text within a cell. You may miss some of Excel's more-advanced features, but for basic data formatting and calculations, the necessary features are there.

Formulae and more

You can enter Excel-style formulae manually, or click on the Formulas tab to see links that quickly insert Sum, Count, Average, Min, Max and Product formulae. For more options, click on the More link to display a pop-up list of hundreds of formulae. Hover over a formula name to see its syntax, or click to insert it in the active cell. Google Spreadsheets lacks advanced Excel features such as macros, PivotTables, auditing, data filtering and validation.

Creating charts

If you need to create a quick visual representation of your data, such as a pie chart or a bar graph, Google Spreadsheets can help.

Begin by selecting the range of cells you want to chart, and then click on the pie-chart icon in the toolbar. Select the type of chart you want to make, and supply any optional data you choose - such as a title, or labels for horizontal and vertical axes. Click on Save Chart.

The chart will appear right on top of your spreadsheet; you can move it or resize it by clicking and dragging. Note that although your spreadsheet can include multiple charts, a Google Spreadsheets chart cannot represent noncontiguous ranges of cells.

Importing and Exporting You can upload Excel spreadsheets (.xls), comma-separated text files (.csv), and OpenDocument spreadsheets (.ods) in one of two ways (and as with Docs, there is a 500K size limit).

The first method is to go to the Google Docs & Spreadsheets home page, click on the Upload link, and follow the instructions for uploading a file, just as you would for a text document.

Alternatively, when you're viewing an existing Google Spreadsheets file, you can choose Import from the File pop-up menu, click on Browse, locate the file on your hard drive, click Open and then click the Open Now link. Unlike Docs, Google Spreadsheets currently has no option that lets you email a finished document directly from the program.

Working with Multiple Sheets As in Excel, each document can have multiple sheets. To create a second sheet, click on the Add Sheet button at the bottom of the document window. You can rename or rearrange the current sheet by clicking on its name and choosing Rename, Move Left or Move Right from the pop-up menu. You can also cut-and-paste cells from one sheet to another. For best results, use the toolbar's Cut, Copy and Paste icons.

Tracking Revisions

The Google Spreadsheets program automatically saves your work after almost every change, as well as when you click on the Save & Close button. To see any previous version of a file, click on the Revisions tab and select the version you want from the Revision pop-up menu. Although Google Spreadsheets tracks revisions, it doesn't highlight specific changes in each version, as Excel's Track Changes feature does, nor does it let you compare two versions, as Google Docs does.

Collaborating

Sometimes you need input from several people - for instance, forecasts from the sales department, history from accounting and strategy from project management. Google Spreadsheets makes it easy for multiple people to simultaneously view and edit the same spreadsheet. As with Google Docs, you can publish your spreadsheet to a web page where anyone can see it. You can also export your spreadsheet in a variety of file formats, and invite other people to collaborate on it with you.

Use the form on Google Spreadsheets' Collaborate tab to invite other people to edit or view a spreadsheet. To make the spreadsheet available to anyone with a Google account, click on Allow Anyone To View. The site produces a URL that you can send to anyone you want. To publish your spreadsheet for anyone to view without logging in, click on the Publish tab and then on Publish Now.

Have a quick question about a spreadsheet change? Because Google's chat program, Google Talk, is integrated with Google Spreadsheets, you can have a live chat with every collaborator who's currently viewing or editing the same spreadsheet. Click on the Discuss tab to see a list of available collaborators. Type your message into the field at the bottom, and a message pops up on the other users' screens, asking them to join the chat.

Google Spreadsheets Expert Verdict »
Intel Pentium or AMD Athlon XP processor
Microsoft Windows 98/Me/2000/XP
64MB RAM
Internet connection (broadband preferred)
Internet Explorer 6.0 or FireFox 1.07
  • Ease of Use: We give this item 8 of 10 for ease of use
  • Features: We give this item 7 of 10 for features
  • Overall: We give this item 8 of 10 overall

Google Spreadsheets is a good choice for maintaining everything from shopping lists to product-launch plans, especially if you want several people to be able to view or modify them. And even though it lacks some of Excel's flashier features, Spreadsheets can crunch numbers - including highly complex formulae - with the best of them. For traditional spreadsheet tasks such as tracking sales figures or account balances, Spreadsheets is a perfectly capable application. It's also a good option for people who want basic spreadsheet capabilities but can't afford Excel, or who often need to do quick calculations when they're away from their regular computers - while traveling, for example. Just like Docs, however, Google Spreadsheets is useless when you're not connected to the internet. And if you need high-powered features, you'll have to turn to Excel or another full-featured spreadsheet application.

There are currently no price comparisons for this product.
  • Google Docs & Spreadsheets

    For those seeking an alternative to Office, OpenOffice is comprehensive. But Google offers a very different approach.

  • Google Spreadsheets

    Google Spreadsheets

    We found this free web-based spreadsheet tool did a surprisingly good job as a basic number cruncher. It's still at an experimental stage, however.

  • Microsoft Excel 2007

    The ribbon is the most obvious innovation in Office 2007, but Excel has some major changes under the hood as well.

  • EditGrid review

    EditGrid

    EditGrid , an online spreadsheet service, might convince you that Microsoft's Excel isn't the best spreadsheet product for all jobs.

  • Google Docs review

    Google Docs

    The new version of Google Docs sports considerable collaboration tools, as well as improved editing and formatting, a faster, more useful spreadsheet and new collaborative drawing software. UPDATED: April 27 2010.


IDG UK Sites

Where to buy iPhone 6 and iPhone 6 Plus in the UK: Launch day price, deals and contracts

IDG UK Sites

Is Apple losing confidence in itself?

IDG UK Sites

Professional photo and video techniques for perfect colours

IDG UK Sites

How (and where) to buy an iPhone 6 or iPhone 6 Plus in the UK. Plus: What to do if you pre-ordered...