Google Spreadsheets started as a standalone product developed using twenty percent time, but it's now a fully integrated part of Google Drive. It has the potential to be extremely useful for anyone with the need to deal with spreadsheets in a group setting.You can access Google Spreadsheets at docs.google.com or at drive.google.com.
Import and Export
Generally, Google Spreadsheets requires you to be logged into a Google account. If you don't have one, it will prompt you to create one. You can import spreadsheets from Excel or any other standard .xls or .csv file or you can create a spreadsheet on the web and download it as an .xls or .csv file
Share the Wealth
This is where Google Spreadsheets is very useful. You can invite other users to view or edit your spreadsheet. This means you could share a spreadsheet with coworkers in your office to get their input on a test project. You could share a spreadsheet with a classroom and let the students input data. You could share the spreadsheet with yourself, so you can view and edit it across more than one computer. The files are also available inside Google Drive for potential offline editing.
Multiple Users, All at Once
This feature has been around for ages. I tested this by having four people simultaneously edit cells in the test spreadsheet to see how it reacted. Google Spreadsheet had no problem letting many people edit cells. In earlier versions, if two people were editing exactly the same cell at the same time, whoever saved their changes last would overwrite the cell. Google has since learned how to handle simultaneous edits all at once.
Why would you want multiple users inside your spreadsheet? We found it very useful for testing software, making feature suggestions, or just brainstorming. When using a spreadsheet, it's important to establish rules beforehand, and we found it easiest to have one person create the spreadsheet while others added data in the cells. Having multiple people make columns tends to get chaotic.
Collaborate and Discuss
Google Spreadsheets offers a handy built-in chat tool on the right-hand side of the screen, so you can discuss changes with anyone else who is accessing that spreadsheet at the moment. This helps mitigate the impact of the simultaneous cell editing.
You can create charts from Google Spreadsheets data. You can pick from a few basic types of charts, such as pie, bar, and scatter. Google has also created a mechanism for third-parties to create chart apps. It's possible to take a chart or gadget and publish it somewhere outside of the spreadsheet, so you could have a pie chart powered by data being updated behind the scenes, for instance. Once you've created a chart the standard way, it is embedded within your spreadsheet. You can edit the chart, and you can save the chart itself as a png image for importing into other programs.
Upload a New Version
Google Spreadsheets started out as something geared towards sharing a spreadsheet, but maintaining a backup copy on the desktop. This was a wise course of action with experimental new software, but Google has had years to iron out the major feature bugs. You can now overwrite your uploaded spreadsheets through Google Drive, but there's really no need if you're keeping the file within Google for editing. Spreadsheets also now supports versions.