How to Save an Excel File (.xlsx) or Google Sheet as CSV

In this tutorial, you will learn how to save an Excel file (.xlsx) or Google Sheets as a CSV file.

 

save excel file as csv

 

Save an Excel File as CSV

1. In the Ribbon, go to File > Save a Copy (or Save as).

 

excel save as csv

 

2. In the new window, on the right side, (1) choose the CSV (Comma delimited (*.csv)) file format and (2) click Save.

If you have special or foreign-language characters in the file, the best solution is to use UTF-8 for the CSV file. This way, special characters from Excel remain the same in .csv format.

 

excel save as csv 2

 

As a result, the CSV file is saved in the same folder as the Excel file.

 

save excel file as csv

 

Note: An Excel file can also be saved as a CSV file using VBA code.

Save a Google Sheets File as CSV

You can also save a Google Sheets file in .csv format. To do this, in the Menu, go to File > Download > Comma-separated values (.csv, current sheet).

 

google sheets save as csv

 

As a result, a new CSV file is downloaded with data from the current Google sheet.