Excel has a File Format known as CSV (Comma Separated Values) format. In this format, we can see the numbers and texts in plain text. This format is quite popular nowadays due to its simplicity. One can easily analyze the data through this format and make required changes. But, owing to some mistakes in the saving process of the CSV file, those changes may not get saved. In this article, we’ll show you the possible solutions for Excel CSV File Not Saving Changes.
Download Practice Workbook
Download the following workbook to practice by yourself.
6 Possible Solutions for Excel CSV File Not Saving Changes
To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset is saved in a CSV file. Here, we’ll demonstrate easy and effective solutions so that you can learn to save CSV Files and see the desired changes.
Solution 1: Save as Excel CSV UTF-8 File to See Changes
Saving the Excel files in CSV UTF-8 File format is the most efficient way to get all the changes you make without destroying any characters. Therefore, follow the steps below to perform the task.
STEPS:
- First, go to File.
- Then, select Save As in the File window.
- After that, in the Save As window, select CSV UTF-8 from the drop-down options.
- At last, press Save and you’ll get your desired CSV File.
Solution 2: Save Changes Through CSV UTF-16 File
Another file format is CSV UTF-16, where the special characters stay intact. So, learn the following steps to solve the Excel CSV File Not Saving Changes issue.
STEPS:
- Firstly, select File ➤ Save As.
- Afterward, choose Unicode Text from the drop-down list.
- Then, press Save. Hence, you’ll get a .txt file.
- Now, open the text file and click Save As.
- Consequently, a dialog box will pop out.
- Next, 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.
- Thus, it’ll return a CSV file that contains the special characters correctly.
Solution 3: Specify Comma as Separator in Excel CSV File
In this solution method, we’ll specify Comma as a Thousand Separator for CSV files. Hence, follow the process to carry out the operation.
STEPS:
- First of all, go to File ➤ Options.
- Consequently, the Excel Options window will appear.
- Then, uncheck the box for Use system separators in the Advanced tab.
- Subsequently, type Dot (.) as the Decimal separator and Comma (,) as the Thousands separator.
- Press OK.
- Now, save the file in CSV See the below picture to understand better.
- Finally, you’ll get the expected outcome.
Similar Readings
- How to Save VBA Code in Excel (3 Suitable Methods)
- How to Save a Worksheet as a New File Using Excel VBA
- Excel VBA to Print As PDF and Save with Automatic File Name
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- [Fix]: Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory
Solution 4: Open CSV File Through Text Editor
Moreover, to view a CSV File with the modifications, open the file through a Text Editor application such as Notepad. In this way, you’ll get all the changes made to the CSV file.
Solution 5: Use Excel Power Query to Import CSV File
However, we can import a CSV File to our Excel workbook using the Power Query Editor. Therefore, learn the below process to fix Excel CSV File Not Saving Changes problem.
STEPS:
- Go to the Data tab first.
- There, choose the Get Data ➤ From File ➤ From Text/CSV.
- As a result, a dialog box will emerge.
- Select the desired CSV file and press Import.
- After that, press Load in the pop-out dialog box.
- Hence, it’ll return a new worksheet containing the CSV file data.
Solution 6: Save File Using Text Import Wizard
In our last solution, we will execute Text Import Wizard. For that purpose, see the below procedure.
STEPS:
- In the beginning, select Options in the File window.
- In the pop-out dialog box, go to the Data tab.
- Then, check the box for From Text (Legacy).
- Next, press OK.
- After that, open a .txt file.
- It’ll return a dialog box as displayed below.
- Press Next.
- Again, press Next after choosing Tab as Delimiters.
- Lastly, press Finish and you’ll get your desired file in Excel.
Conclusion
Henceforth, you will be able to fix the Excel CSV File Not Saving Changes issue following the above-described solutions. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- Excel VBA: Save Workbook in Specific Folder (4 Suitable Examples)
- How to Save One Sheet in Excel as PDF (3 Useful Ways)
- How to Save Macros in Excel Permanently (2 Suitable Ways)
- Excel VBA: Save and Close Workbook (5 Suitable Examples)
- [Fixed!] Document Not Saved Excel Network Drive (5 Possible Solutions)
- How to Save a Worksheet in Excel to a Separate File (3 Handy Methods)