In this tutorial, you will learn how to save an Excel file (.xlsx) or Google Sheets as a CSV file.
Save an Excel File as CSV
1. In the Ribbon, go to File > Save a Copy (or Save as).
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.
As a result, the CSV file is saved in the same folder as the Excel file.
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).
As a result, a new CSV file is downloaded with data from the current Google sheet.