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.
When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. You may not want ...Discover More
When you get a lot of data in a spreadsheet, it can be hard to zero in on the data you really need to work with. That's ...Discover More
Sheets includes a nifty, undocumented feature that allows you to enlist Google's help in brainstorming. All you need to ...Discover More