How to Fix If Excel CSV File Is Not Saving Changes (6 Solutions)

The following dataset is saved in a CSV file. Here, we’ll demonstrate easy and effective solutions to save CSV files and see the desired changes.

Solution 1: Save as Excel CSV UTF-8 File to See Changes

STEPS:

Go to File.
Select Save As in the File window.

Tin the Save As window, select CSV UTF-8 from the drop-down options.

Press Save and you’ll get the CSV file you desire.

Read More: How to Save Excel File as CSV

Solution 2: Save Changes Through CSV UTF-16 File

STEPS:

Select File ➤ Save As.
Choose Unicode Text from the drop-down list.

Press Save. You’ll get a .txt file.
Open the text file and click Save As.

A dialog box will pop out.
Type .csv at the end of the file name and choose All Files in the Save as type.
Select UTF-16 LE in the Encoding field and press Save.

It’ll return a CSV file that correctly contains the special characters.

Solution 3: Specify a Comma as a Separator in Excel CSV File

STEPS:

Go to File ➤ Options.
The Excel Options window will appear.
Uncheck the box for Use system separators in the Advanced tab.
Type Dot (.) as the Decimal separator and Comma (,) as the Thousands separator.
Press OK.

Save the file in CSV. See the below picture to understand better.
You’ll get the expected outcome.

Solution 4: Open a CSV File Through Text Editor

To view a CSV File with the modifications, open the file through a Text Editor application such as Notepad. This way, you’ll get all the changes to the CSV file.