Data Import & Export

How to Fix Excel Not Saving Files in CSV Format

Ayan Masood Oct 1, 2026 869 views

Question details

The user is attempting to save an Excel file as a CSV, but the file saves as a standard Excel workbook and the CSV file extension is missing.

How to Fix Excel Not Saving Files in CSV Format

Product: Microsoft Excel
Device & OS: not provided
Scenario: Exporting or saving a spreadsheet to a plain-text CSV format for data processing or software import.
Observed behavior: Excel defaults to saving the file as an Excel workbook (e.g., .xlsx) instead of CSV, and the expected .csv file extension does not appear during the save process.

Before you start

Verify that your document is not opened in 'Protected View' or a restricted editing mode, as this restricts the ability to change file formats during the save process.

Solution 1Recommended

Manually Select the CSV File Type in the Save As Dialog

The most common reason for this issue is overlooking the 'Save as type' dropdown menu. You must manually instruct Excel to change the file format from a standard workbook to CSV.

By default, Excel will attempt to save any document as a standard Excel Workbook (.xlsx) to preserve formatting and formulas. To create a CSV, you must explicitly change the file type before confirming the save.

Open the Save As window

Click on 'File' in the top ribbon and select 'Save As'. Alternatively, press the F12 key on your keyboard to instantly open the Save As dialog box.

Change the Save as type

Below the 'File name' field, click the dropdown menu labeled 'Save as type'. Scroll through the list and select 'CSV UTF-8 (Comma delimited) (*.csv)' or 'CSV (Comma delimited) (*.csv)'.

Verify the file extension

Check the file name field to ensure the name now ends with the .csv extension. If it still says .xlsx, manually type .csv at the end of the file name.

Confirm the save format warning

Click 'Save'. Excel may warn you that some features or formatting will be lost if you save it as a CSV. Click 'Yes' or 'OK' to proceed with the export.

Manually Select the CSV File Type in the Save As Dialog

Choosing UTF-8 Encoding: Using 'CSV UTF-8' instead of standard CSV is highly recommended if your data contains special characters, accents, or non-English alphabets, as it prevents text corruption.

Solution 2

Check for Restricted Mode or Protected View

If the CSV option is entirely missing from the file type list, the document might be opened in a restricted or read-only mode.

Seamlessly Export Data to CSV

Easily Save and Export CSV Files Using WPS Office

If your spreadsheet program continues to give you trouble during export, you can quickly and accurately save your spreadsheets in CSV format using WPS Spreadsheet, a free, fast, and highly compatible alternative.

1. Open your file: Launch WPS Office and open your existing spreadsheet document.
2. Access the Save As menu: Click on the 'Menu' button in the top-left corner, hover over 'Save As', and select 'Other Formats'.
3. Select CSV format: In the File Type dropdown, choose 'CSV (Comma delimited) (*.csv)'.
4. Save the file: Choose your save location and click 'Save'. Confirm any prompts to successfully export your data.

Free and lightweight spreadsheet tool with an intuitive interfaceFully compatible with Microsoft Office formats, including .xlsx, .xls, and .csvSupports seamless CSV UTF-8 encoding without data loss or corruptionNo confusing restricted mode barriers when exporting simple plain text data

Frequently Asked Questions

Why does Excel warn me about losing features when saving as CSV?

CSV (Comma Separated Values) is a plain-text format. It does not support multiple sheets, cell formatting, colors, formulas, or charts. The software displays a warning to ensure you understand that only the raw text data of the active sheet will be saved.

How do I save an Excel file with multiple sheets as a CSV?

A standard CSV file can only contain one sheet of data. To export multiple sheets, you must navigate to each sheet individually and perform the 'Save As' > 'CSV' process for every sheet, creating separate files for each one.

What is the difference between CSV UTF-8 and standard CSV?

CSV UTF-8 encodes the text using Unicode, which supports a much wider range of characters, including special symbols, emojis, and non-English alphabets. Standard CSV may corrupt these characters into question marks or unreadable text when reopened.

Why does my CSV file open with all data crowded into one column?

This usually happens due to your computer's regional settings, where a semicolon (;) is expected as the list separator instead of a comma (,). You can fix this by using the 'Text to Columns' feature under the Data tab to split the data properly.

Excel & Data Problems