Section 2. Migrating from Excel to Google Spreadsheets
If you've decided to give Google Spreadsheets a spin, the first question (if you've used Excel at all in the past) is how to transfer your existing Excel spreadsheets to Google Spreadsheets. Fortunately, it's pretty easy.
As you'll learn in the "Importing a Spreadsheet from Excel" section of this document, it's easy to open your Excel spreadsheets from within Google Spreadsheets. All you have to do is click the File button and select the
In some instances, however, Google Spreadsheets won't be able to import an Excel spreadsheet. You'll probably run into problems if you try to open a spreadsheet that has embedded
In some cases, these spreadsheets simply won't import; Google will give you a message saying that it couldn't open the file. In other cases, Google Spreadsheets will be able to open the file, but the non-Google features will be carved off. Even with fully compatible spreadsheets, it's not uncommon to find some formatting changes when you import into Google Spreadsheets; for example, the
It's also possible to export from Google Spreadsheets back into Excel's XLS format. This lets you work on your spreadsheets online, for sharing and collaboration, but then go offline with an Excel file for more private or detailed work. Just click the File button and select Download as XLS; this downloads an XLS-format version of the spreadsheet file to your computer.
Section 3. Navigating the Google Spreadsheets Workspace
The Google Spreadsheets workspace looks a lot like every other PC-based spreadsheet application you've ever used. Whether you started with VisiCalc, 1-2-3, Quattro Pro, or Excel, you'll recognize the row-and-column grid you see when you first access Google Spreadsheets. Sure, the
Understanding Elements of the Workspace
Let's take a quick look at what's where in the Google Spreadsheets workspace. The first thing to note is that the workspace changes slightly, depending on which tab (Format,
Figure 6. Google SpreadsheetsFormat tab.
Figure 7. Google SpreadsheetsSort tab.
Figure 8. Google SpreadsheetsFormulas tab.
Table 2. Elements of the Google Spreadsheets Workspace