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.
Excel CSV File Not Saving Changes: 6 Possible Solutions
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.
Read More:
- [Fixed!] Why Is Excel Not Saving My Formatting?Â
- [Fixed!] Document Not Saved Excel Network DriveÂ
- How to Save Excel File as CSV
- How to Save Multiple Sheets in Excel to CSV
- How to Save Excel File in XLSX FormatÂ
- How to Save Excel as PDF
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.
Read More
- How to Save a Worksheet in Excel
- How to Save a Worksheet in Excel to a Separate File
- How to Save a Copy of an Excel File
- How to Save One Sheet in Excel as PDFÂ
- How to Save Multiple Excel Sheets as One FileÂ
- How to Save Multiple Sheets in Excel
- How to Save Excel File with Password
- How to Save Multiple Tabs in Excel as Separate Files
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.
Download Practice Workbook
Download the following workbook to practice by yourself.
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.