How to Save as a CSV from Google Sheets

While the popularity of Google Sheets has been increasing due to the large number of features that it has (and the fact that it is free), there are still occasions where you will need to work with a file in a different application. Fortunately Sheets makes it a simple process to download your Sheets spreadsheets in different formats, including a .csv file.

CSV files are used in many situations, and it is not unusual for a specific scenario to require a file to be in that format. So if you have a Sheets document that needs to be converted to a .csv file, you can follow the steps below to accomplish this from directly within the application.

 

How to Download a Spreadsheet from Google Sheets as a CSV

The steps in this guide are going to show you how to download a spreadsheet as a .csv file that is currently saved in Google Sheets. Note that the .csv file format has some limitations that could affect your current sheet. For example, .csv files can’t save formatting data, so any font choices, shading colors, etc. will not be included with the downloaded file. Additionally, a .csv file can only be one sheet. If you have a file in Google Sheets that contains multiple worksheets, you will need to download each individual sheet as its own .csv file.

Step 1: Open your spreadsheet in Google Drive. You can navigate to Google Drive directly by clicking this link – https://drive.google.com.

 

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

how to download as csv from google sheets

 

 

Step 3: Click the Download As option, then select the Comma-separated values option.

how to convert from google sheets to csv

 

 

The .csv version of your Sheets file will then download in your browser and you are free to edit or share it as needed. Note that the file will no longer be linked to the version of the spreadsheet in Google Drive.

 

If you have downloaded a large number of .csv files and need to combine all of them into one document, then you might be planning to do so manually. There is actually a way to merge csv files in Windows with the command prompt, and it can be considerably faster if you have a lot of data to combine.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.