by Allen Wyatt
(last updated April 3, 2014)
One of the key benefits to working with Sheets is that you can easily collaborate with others. However, not everyone has access to the Internet (hard to believe, huh?), or you might need to simply share a spreadsheet with someone in a different file format.
Sheets makes it easy to download a spreadsheet and do a file conversion at the same time. Here's how you do it:
At this point, Sheets starts the download, using a filename that matches the name of your spreadsheet and an extension that reflects your choice in step 2.
Speaking of step 2, there are a number of different target formats you can choose for your downloaded spreadsheet. As of this writing, Sheets provides these options:
Note that the first three options result in the data on all sheets being downloaded, but the final three do not. Also, it should be noted that the last option (web page) does not produce a page that is interactive or changeable; it is essentially a static representation of the current sheet.
Because you can put text into spreadsheet cells, it makes sense that not all that text could be displayed in a regular-sized ...Discover More
Named ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.Discover More
Adding stock information to a spreadsheet is a common need. Rather than enter information manually, why not let Sheets handle ...Discover More