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.
What day of the week is that date? Sheets can let you know by using the TEXT function to return a weekday name for a ...Discover More
When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...Discover More
One of the layout tools that Sheets provides allows you to merge together a group of cells. Here's how to use that tool.Discover More