Exporting a Google Spreadsheet to Excel Format


By default, all the spreadsheets you work with in Google Spreadsheets are stored on Google's servers. You can, however, download files from Google to your computer's hard drive to work with in Excel. In essence, you're exporting your Google spreadsheet to an XLS-format Excel file.

To export the current spreadsheet, follow these steps:

1.

Select File, Download as .XLS.

2.

When the File Download dialog box appears, as shown in Figure 13, click the Save button.

Figure 13. Downloading a Google Spreadsheets file.


3.

When the Save As dialog box appears, as shown in Figure 14, select a location for the downloaded file, rename it if you like, and then click the Save button.

Figure 14. Saving a spreadsheet file in XLS format.


The Google Spreadsheets file is saved in XLS format on your hard disk. You can now open that file with Excel, and work on it as you would with any Excel spreadsheet. Know, however, that whatever changes you make to the file from within Excel affect only the downloaded file, not the copy of the spreadsheet that still resides on the Google Spreadsheets site. If you later want to reimport the Excel file to Google Spreadsheets, select File, Upload New Version to upload the changed spreadsheet from your PC to Google's servers.

Note

You can also export a Google spreadsheet as a CSV-format file by selecting File, Download as .CSV. You can then import the CSV-format file into Excel or any other spreadsheet program. (Excel will not directly open CSV-format files, however; you'll have to use the import function from within Excel.)





Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net