• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Google / Sheets / How to Download Google Sheets as a CSV File

How to Download Google Sheets as a CSV File

November 20, 2019 By Matt Jacobs

The steps in this guide are going to show you how to download your Google Sheets file as a .csv file.

  1. Sign into Google Drive and open the Sheets file to download.
  2. Select the File tab at the top-left of the window.
  3. Choose the Download option, then click Comma-separated values.
  4. Choose the download location, then click the Save button.

Do you have a spreadsheet in Google Sheets that you need to put into a CSV file format? While you may be considering options like copying and pasting everything into Microsoft Excel, there is a much faster way to accomplish this.

Our article below is going to show you how to download as a .csv file from Google Sheets using an option found within the application’s menus.

How to Convert a Google Sheets File to a CSV File

The steps in this tutorial were performed in the desktop version of Google Chrome, but will also work in other desktop Web browsers like Mozilla Firefox or Microsoft Edge.

Step 1: Sign into Google Drive at https://drive.google.com and open the Google Sheets file you wish to download as a .csv file.

Step 2: Click the File tab at the top-left of the window.

click the File tab

Step 3: Choose the Download option, then click Comma-separated values.

how to download a Google Sheets file as a csv file

Step 4: Choose a location for the .csv file, then click Save. Note that your browser may just automatically download the file to your default download location depending on your settings.

save the csv file

The .csv file type has far fewer formatting options than Google Sheets’ default file type. This means that almost all of the formatting that you have applied to the file will be stripped from the .csv version of the file. Additionally you cannot download charts or graphs as part of a .csv file, and it can only consist of the active worksheet when you complete the steps above.

Learn how to freeze a row to the top of the spreadsheet in Google Sheets if you would like to keep a row, such as one with headings, visible at all times while you scroll down through your data.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Delete a Text Box in Microsoft Excel for Office 365
  • How to Add Line Numbers in Word for Office 365
  • How to Save a Picture to Your Computer from Powerpoint for Office 365
  • How to Enable Data Saver in Spotify on an iPhone
  • How to Change the Font for a Selection in Microsoft Word for Office 365

Featured Posts

how to strikethrough text in Google Docs

How to Strikethrough Text in Google Docs [Guide]

How to Add the Developer Tab in Microsoft Excel for Office 365

How to Create a Comma Delimited File from Excel

How to Change the Page Order When Printing in Excel for Office 365

How to Turn Off the Passcode on an iPhone 11

How to Stop an iPhone 7 from Automatically Capitalizing Words

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com