How to Save Google Sheets on a PC or Mac (Download and Back Up)

Google Sheets saves your work automatically to Google Drive, so you never need to press a Save button. To keep a copy on your PC or Mac, open the spreadsheet and select File > Download, then pick a format such as Microsoft Excel (.xlsx), PDF or CSV. The file goes to your computer’s Downloads folder.

The steps are the same on Windows and macOS because Google Sheets runs in your web browser. Below are the download options, how to save many spreadsheets at once, and how to work on your sheets without an internet connection.

How Google Sheets saves your work

Every change you make is saved to your Google Drive within a second or two. Look at the top of the spreadsheet next to the file name: a cloud icon with a check mark means everything is saved. If you see Saving… or a crossed-out cloud, wait or check your connection before you close the tab.

Pressing Ctrl + S (Windows) or Command + S (Mac) doesn’t download anything. It only shows a message that your changes are already saved in Drive.

Download a Google Sheet to your computer

  1. Open the spreadsheet in Google Sheets.
  2. Select File > Download.
  3. Choose a format (see the table below).
  4. Your browser saves the file to the Downloads folder. In Chrome or Edge, the download appears in the top-right corner of the window. On a Mac with Safari, it’s in the Downloads stack in the Dock.

To save it somewhere else, open the downloaded file’s folder and move it, or change your browser’s download setting so it asks where to save each file.

Can I download a Google Sheet on my phone?

In the Google Sheets app, open the file, tap the three-dot menu, then Share & export > Save as to make an Excel or PDF copy, or Send a copy to share it.

Which download format to choose

Format What you get Best for
Microsoft Excel (.xlsx) Every sheet, with formulas and most formatting Editing in Excel or Numbers, full backups
OpenDocument (.ods) Every sheet in an open format LibreOffice or OpenOffice
PDF (.pdf) A printable copy; opens the print settings first Sharing a read-only copy
Web page (.html) A zipped folder with an HTML page for each sheet Publishing as a web page
Comma-separated values (.csv) Plain values from the current sheet only Importing into other apps or databases
Tab-separated values (.tsv) Plain values from the current sheet only Data with commas inside the cells

CSV and TSV only include the sheet tab you’re looking at, with no formatting, formulas or charts. Switch to each tab and download again if you need every sheet. For a complete backup, use .xlsx. A few Sheets-only features, such as some functions, checkboxes and Apps Script, may not carry over to Excel. For more on that format, see how to download an Excel version of a Google Sheets file.

Can I edit a downloaded Google Sheet?

Yes. An .xlsx file opens in Excel, Numbers or LibreOffice. Changes you make there don’t sync back to Google Sheets unless you upload the file again.

Download several spreadsheets at once

  1. Go to drive.google.com.
  2. Hold Ctrl (Windows) or Command (Mac) and click each spreadsheet you want. You can also select a whole folder.
  3. Right-click the selection and choose Download.

Drive converts the spreadsheets to .xlsx and packs them into a single .zip file. Open the .zip to get the files out. Large selections can take a few minutes to prepare.

To back up every spreadsheet in your account, go to takeout.google.com, select Deselect all, check Drive, and choose the formats you want under All Drive data included. Google emails you a download link when the export is ready.

Keep a synced copy with Google Drive for desktop

Install Google Drive for desktop on Windows or macOS to see your Drive as a drive or folder on your computer. Your spreadsheets appear as small shortcut files (.gsheet) that open in your browser. They aren’t real offline copies, so download an .xlsx if you need a file that works without Google.

Work on your sheets offline

If you only need to keep working without internet, you don’t have to download anything:

  1. Use Google Chrome or Microsoft Edge, and install the Google Docs Offline extension.
  2. Open Google Drive, select the gear icon, then Settings.
  3. Turn on Offline.
  4. To be sure a particular spreadsheet is available, right-click it in Drive and turn on Available offline.

Edits you make offline sync back to Drive the next time you connect.

Make a copy inside Google Drive

Want a backup before making big changes? Select File > Make a copy, give it a name and choose a folder. You can also rely on version history: File > Version history > See version history lets you go back to earlier versions. Here’s how to restore a version from version history.

If the download doesn’t work

  • Nothing happens when you choose a format: your browser may be blocking pop-ups or downloads for docs.google.com. Allow them and try again.
  • The Download option is grayed out: the owner has turned off downloading for viewers and commenters. Ask them for edit access or a copy.
  • The Excel file looks different: some Sheets functions and formatting have no Excel equivalent. Check formulas after opening the file.
  • A CSV file is missing data: it only contains the active sheet. Download each tab separately or use .xlsx.

Related: how to change a file name in Google Sheets and how to download a Google Sheets chart as a PNG.