Google Spreadsheets will surprise you

Google Spreadsheets is a free, Web-based spreadsheet tool from Google that does a surprisingly good job as a basic number cruncher, and the price is right. Google began accepting sign-ups to participate in a limited public beta test earlier this week, so you can sign up and try it yourself.

I didn't expect to see high-end spreadsheet features. There are no PivotTables, there's no charting, and apart from sorting, you can't do much with text. But there's a lot more functionality than you might expect. Google Spreadsheets' user interface, functions support, collaboration features and performance are all strengths.

Where the files are

Files you create or import with Google Spreadsheets are automatically saved by default to Google's server, though it's easy to delete them there. Data files are not encrypted, though, which should give at least some users pause. Google offers encryption with some of its other user-data services, so perhaps this capability will be added later. But even if Google does eventually offer worksheet encryption, any notion of saving sensitive data to some other company's server via the Internet is rarely a smart move. (This problem might potentially be offset if Google were to offer an enterprise product that ran on corporate intranets.)

You can use Google Spreadsheets to work with your pre-existing worksheets (either native Microsoft Office Excel .xls or comma-separated-value .csv files) by uploading them to Google Spreadsheets. You can also save a Google Spreadsheets worksheet to your hard drive and convert it to an .xls or .csv file. Be prepared to lose some formatting, such as row height and column width, when saving to .xls format. You can also create an HTML file of your worksheet as a read-only file.

Every time you make a change, the Google server automatically updates the worksheet. While I experienced no serious lag, and you do have access to undo and redo buttons throughout the interface, this constant saving means you can't make a series of changes and then save the file in a particular state. Every time you make a change, your spreadsheet is saved, so "Wait, wait, wait, I want to go back to the last good version!" is not an option.

Regular use of Google Spreadsheets might tend to make spreadsheets smaller. By default, new worksheets are sized at 100 rows by 20 columns, and inserting large numbers of rows or columns is cumbersome. Although Google Spreadsheets can import existing worksheets with more rows, there are limits. You can work with up to 100 spreadsheets in all, each with up to 20 worksheet tabs, 50,000 cells, 256 columns or 10,000 rows, according to Google. If any worksheet exceeds any of these conditions, you're prevented from adding data to the spreadsheet. Your .xls and .csv files cannot exceed 400KB each.

The Format tab

Google Spreadsheets' interface is clean and simple. Standard drop-down menus, icons and buttons handle many common chores. Buttons control formatting choices, such as toggling between two or no decimal points, applying dollar or percent signs, aligning text and inserting rows and columns.

The main interface is divided into three tabs, Format, Sorting and Formulas. The Format tab is where you'll probably spend most of your time. I like the feedback and naming conventions given to user interface elements, particularly on the Format tab. For instance, when you select a cell range and press the Delete menu button, the online spreadsheet tool presents you with user-friendly, plain-English options that offer feedback about the range you selected, such as "Delete Rows 1-4," "Delete Columns G-H" or "Clear Selection." Likewise, select two cells and click the "Merge Across" button to merge the cells, or choose a merged range and click "Break Apart" to do the opposite, just as the button says. There are no cryptic icons to decipher.

Formatting is simple, direct and fast. You can format cells in any of seven font faces and 11 font sizes; make them bold, italic, and underlined; and wrap text within a cell. You can choose among 40 text and background colors, although there's no provision similar to Microsoft Office Excel's custom colors.

Google Spreadsheets provides good feedback in many places. When you select a range, the program initially turns the background of that cell range blue. When you perform an operation on the range, such as Copy, it temporarily changes the background to light red to let you know it recognized and is performing your command.

There are some disappointing omissions. For instance, you can change cell width and height by dragging cell borders, but you can't double-click on a row/column border to automatically adjust the dimension to the widest or tallest entry in the selected row or column. You also can't control the number of decimal points uniformly in a worksheet. Google Spreadsheets lets you format numbers in these settings: showing all digits to the right of the decimal point, showing two digits, or not showing the decimal point.

Join the newsletter!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Richard Ericson

Show Comments





Back To Business Guide

Click for more ›

Most Popular Reviews

Latest Articles


PCW Evaluation Team

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill


I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?