Save your Excel spreadsheet as a CSV file in three steps

A CSV file (comma-separated values) is a plain-text format that stores data in rows and columns, separated by commas. Excel can open and save files in this format. To convert an Excel spreadsheet to CSV, open the file in Excel, click File, select Save As, choose CSV as the file type, name the file, and click Save.

CSV files are smaller than Excel files and work with almost any program — spreadsheet software, databases, email systems, and web applications all read CSV format. If you need to move data between different programs or share a spreadsheet with someone who does not have Excel, CSV is often the best choice.

Key Takeaways

  • CSV files store data as plain text with commas between columns, making them compatible with nearly any software.
  • Excel's Save As function lets you choose CSV format from a dropdown menu of file types.
  • Excel will warn you that some formatting and formulas may not transfer to CSV — this is normal and expected.
  • You can save the same spreadsheet as both an Excel file and a CSV file without losing either version.

Step-by-step: saving an Excel file as CSV

Open the Excel file you want to convert. Click the File menu in the top left corner. From the menu that appears, click Save As.

A dialog box will open. In the "Save as type" dropdown (on Windows) or "File Format" dropdown (on Mac), scroll down and select "CSV (Comma delimited) (*.csv)". Type a name for your file in the filename field. Choose where you want to save it — your Desktop, Documents folder, or another location. Click Save.

Excel will show a warning message saying the file may contain features that are not compatible with CSV format. This is normal. Click Yes or Continue to proceed. Your file is now saved as a CSV file.

What happens to formatting and formulas when you convert to CSV

CSV format stores only the data itself — the text, numbers, and dates in each cell. It does not preserve colors, fonts, bold text, cell borders, or any other visual formatting. If your spreadsheet relies on color-coding or special formatting to convey information, that formatting will be lost when you save as CSV.

Formulas also do not transfer to CSV. If your Excel file contains formulas (like =SUM or =IF), CSV will save only the results those formulas produced, not the formulas themselves. When you open the CSV file later, you will see the numbers but not the underlying calculations.

Charts, images, and multiple sheets also do not convert to CSV. If your Excel file has more than one sheet, only the sheet you are currently viewing will be saved as CSV. The other sheets will not be included in the CSV file.

Keeping both Excel and CSV versions of your file

You do not have to choose between keeping your Excel file and creating a CSV version. Save As creates a new file without changing the original. Your original Excel file stays exactly as it is.

To keep both versions, open your Excel file and use Save As to create a CSV copy with a slightly different name — for example, "Sales Data.xlsx" and "Sales Data.csv". Both files will exist in the same folder. You can open and edit either one independently.

This approach is useful when you need to share data with someone using different software while keeping your formatted Excel version for your own records.

When to use CSV instead of Excel format

Use CSV when you need to import data into another program. Most database software, email marketing platforms, and web applications accept CSV files. If a website asks you to upload a spreadsheet, CSV is usually the safest choice because it works everywhere.

CSV is also useful for sharing data with people who do not have Excel or who use different spreadsheet software like Google Sheets or LibreOffice. CSV files open in any of these programs without compatibility issues.

CSV files are also much smaller than Excel files, which matters if you are sending the file by email or uploading it to a server with file size limits. A spreadsheet with thousands of rows might be several megabytes as an Excel file but only a few hundred kilobytes as CSV.

Opening a CSV file in Excel

To open a CSV file in Excel, click File, then Open. Navigate to the folder where your CSV file is stored and select it. Click Open. Excel will display the data in a spreadsheet format you can edit.

When you open a CSV file, Excel may show an import wizard asking about the delimiter (the character separating columns — usually a comma). In most cases, the default settings are correct. Click Finish or OK to proceed.

If you edit a CSV file in Excel and save it, make sure you save it as CSV again if you want to keep it in that format. If you click Save without using Save As, Excel may convert it back to .xlsx format.

Troubleshooting common CSV issues

If your CSV file opens in Notepad instead of Excel, right-click the file, select Open With, and choose Excel from the list. This tells your computer to open CSV files in Excel by default.

If your data appears in a single column instead of multiple columns when you open the CSV, the columns may not be separated by commas. Use Excel's Text to Columns feature: select all the data, click the Data menu, choose Text to Columns, and follow the wizard to specify the correct delimiter.

If special characters or accented letters appear as strange symbols, the file may have an encoding issue. When you save as CSV, look for an encoding option (usually UTF-8 is the best choice) and select it before saving.

Frequently Asked Questions

Can I convert a CSV file back to Excel format?

Yes. Open the CSV file in Excel, then use File > Save As and choose Excel format (.xlsx) from the dropdown. All the data will transfer, though any formatting you added in Excel will be preserved only if you save as Excel format.

Will I lose data if I save my Excel file as CSV?

The data itself will not be lost, but formatting, formulas, and multiple sheets will not transfer. The actual text, numbers, and dates in your cells will remain intact in the CSV file.

What is the difference between CSV and Excel format?

Excel format (.xlsx) stores data along with formatting, formulas, and multiple sheets. CSV stores only the raw data as plain text. Excel is better for complex spreadsheets; CSV is better for sharing data between different programs.

Can I edit a CSV file in Excel?

Yes. Open the CSV file in Excel, make your changes, and save it. Remember to save it as CSV format if you want to keep it as a CSV file, or save it as Excel format if you want to preserve formatting and formulas.

Do I need special software to open a CSV file?

No. CSV files open in Excel, Google Sheets, LibreOffice, and most other spreadsheet programs. You can also open them in a text editor like Notepad, though the data will not be formatted as a table.