🧩 Data Cleaning · 6 min read
CSV Not Saving Changes? Why Excel Reverts Your Edits
Your edit was saved — just not where you were looking, or not in a form a CSV can hold.Excel writes straight back to the same .csv when you press Save, so when the file on disk looks untouched, one of three things happened: you used Save As and picked an Excel workbook type, the edit was on a worksheet that never got written, or the thing that "reverted" was formatting, not data. Each has a different fix and the first step is working out which one you have.
This page covers Excel first, because that is where the question is asked, and Google Sheets and LibreOffice behave the same way for the same reason: a CSV is a text file with no formatting layer to save.
The three things "not saving" usually means
| What you see | What actually happened | Go to |
|---|---|---|
| Reopened the CSV and the edits are gone | Save As was used and an Excel workbook type was chosen, so the original .csv was never overwritten | Fix 1 |
| Edits on the second or third sheet are missing | A CSV holds one table; only the active worksheet is written, and Microsoft documents a prompt saying so | Fix 1 |
| Values look right in Excel but wrong in the file | Formatting was applied in the sheet; a CSV stores values as plain text only | Fix 2 |
| Leading zeros, dates or long IDs change on reopening | Excel re-interprets each column on open using its default data format settings | Fix 2 |
| The file has an unchanged Modified time | The save never completed, or it went to a different file name or folder | Fix 3 |
Why a CSV cannot remember formatting
RFC 4180 describes a CSV as plain text: records separated by line breaks, fields separated by a delimiter (a comma by default), and double quotes around any value that contains the delimiter, a quote, or a line break. There are no cells, no types, no column widths and no formulas in that description, because the format has no way to express them.
Microsoft makes the same point in its own instructions. When you use Save As to write a worksheet as text, a second dialog box warns that your worksheet may contain features that are not supported by text file formats. That dialog is the explanation for a whole category of "my CSV did not save" reports: the save worked, and the formatting could never have been part of it.
The same page notes that opening a text file in Excel does not change the file's format — the title bar keeps the .csv extension. Excel reads the bytes and renders a table; the file stays text.
Fix 1: Save the CSV itself, not a copy of it
- Edit the file, then press Ctrl+S(File > Save). Skip Save As unless you are deliberately creating a new file.
- If you do open Save As, keep CSV (Comma delimited)in the Save as type list, and keep the same file name and folder. Choosing "Excel Workbook" writes a new .xlsx and leaves the .csv as it was.
- Answer both prompts. Microsoft's instructions describe the first as a reminder that only the current worksheet will be saved, and the second as a warning that unsupported features will be dropped. Nothing is written until you accept them.
- Check the title bar. If it still shows .csv, saves go back to the CSV. If it shows .xlsx and you meant to keep a CSV, you are editing the wrong document.
If the work spans several worksheets, a single CSV cannot be the destination. Export one CSV per sheet, or keep an .xlsx master and produce the CSV only for the system that demands one — the round trip in the other direction is covered in convert CSV to Excel without Excel.
Fix 2: Treat the reverted columns as text
The complaints that are really about values, not saving, come from Excel re-reading the file. Microsoft documents three automatic conversions that cause it: leading zeros removed when a code is read as a number, numbers truncated to 15 digits of precision, and long numbers displayed in scientific notation. The formatting you applied in the sheet is a display setting; the file holds only the characters.
- ZIP codes, account numbers and product codes losing their leading zeros: see keep leading zeros in a CSV.
- Days and months swapping on the way through the file: see why CSV dates keep changing.
- A long ID shown as 1.23E+15: see CSV scientific notation in Excel.
The durable fix is to set the column type yourself instead of accepting the guess. In Excel that means importing with Data > From Text/CSVand setting the column to Text in the preview or Power Query, rather than double-clicking the file. Once the column is text, the values stop changing and the "not saving" report disappears with them.
Fix 3: Prove where the save landed
When you cannot tell whether the file changed, stop reading it through Excel. Excel shows you its interpretation of the bytes, which is the thing in question.
- Check the Modified time of the file on disk, next to the time you saved.
- Open the CSV in a viewer that shows the raw table: the free CSV analyzer renders the columns and rows as they are stored, with no type guessing to undo.
- A file at the wrong path is a common miss: search the folder for a second copy with the same name.
- If the columns themselves are still fused into one, that is a delimiter problem rather than a save problem, and CSV opens in one column deals with it.
What a CSV is the wrong place for
If the file needs multiple sheets, formulas you will reuse, or number formats that must survive, keep it as an .xlsx and export a CSV for the systems that require one. Two problems genuinely do belong to the file rather than the spreadsheet: text that arrives with the wrong characters, which is an encoding question covered in fix garbled CSV, and a delimiter that the reader is not expecting, covered in change a CSV delimiter.
Frequently asked questions
How do I make Excel actually save changes to a CSV file?
Edit the file and then use File > Save (Ctrl+S), not Save As. Excel keeps the .csv extension on the title bar, and saving writes straight back to that file. If you do use Save As, keep CSV (Comma delimited) in the Save as type list and the same file name and folder, then answer both prompts. Microsoft documents that only the current worksheet is written to the new file, and that a second prompt warns about worksheet features that text file formats do not support.
Why did my formatting disappear after saving as CSV?
A CSV file has nowhere to put formatting. It is plain text described by RFC 4180: rows separated by line breaks, fields separated by a delimiter, with double quotes reserved for values that contain the delimiter. Cells, colours, column widths, number formats and formulas exist only in the workbook. Microsoft's own Save As flow warns that the worksheet may contain features that are not supported by text file formats, which is exactly what that prompt is telling you.
Why do leading zeros keep disappearing each time I save the CSV?
Because Excel is re-reading the file, not failing to save it. Microsoft documents that Excel removes leading zeros from numeric-looking codes, truncates numbers to 15 digits of precision, and displays long numbers in scientific notation, because it treats them as numbers. Each time the CSV is opened, those conversions are applied again. Set the column type to Text during import instead of letting Excel guess, which is what the guide on keeping leading zeros in a CSV walks through.
Can one CSV file hold more than one sheet?
No. A CSV is a single table with one header row and no concept of worksheets. Microsoft's Save As instructions say a prompt appears reminding you that only the current worksheet will be saved to the new file, and that other sheets have to be saved as separate text files by repeating the procedure. If edits on a second sheet are missing from the file, that is the reason.
The CSV looks unchanged after I edited it — what happened?
The most common cause is Save As to an Excel workbook type, which leaves the original .csv untouched and puts your edits in a new .xlsx. The second is saving to a different folder and then opening the old copy. Compare the file's Modified time, and open the file in a plain viewer rather than Excel so you are reading the bytes on disk. Cancelling out of the Save As prompts is the third cause: nothing is written until those prompts are accepted.
NoCodeCSV Team
Updated October 12, 2026 · Practical guides by the NoCodeCSV team.
Tools mentioned in this guide
The work around a stubborn CSV file is usually repetitive, so the tools that earn their place are the ones that remove the manual step:
- OpenCode Go — checking a folder of exports, or rewriting one that keeps getting reformatted, is a few lines of script you can run and reuse. Try OpenCode Go
- Stack AI — when the same export is saved and re-checked on a schedule, a workflow can do the pass without a manual step. Try Stack AI
- Softr — if the file exists only to feed a lookup table, a no-code app can hold the records so nobody has to re-save a CSV to change one row. Try Softr
Some links above are affiliate links — if you buy through them we may earn a commission at no extra cost to you. OpenCode Go uses our referral link; the other two point to each vendor's official page until our tracking links are approved.
See What the File Actually Contains
Open the CSV in the analyzer and read the rows as they are stored, without a spreadsheet re-interpreting them first.
Sources for this article: Microsoft Support, "Import or export text (.txt or .csv) files" (the Save As prompts, and the note that opening a text file does not change its format), "Excel specifications and limits", and "Keeping leading zeros and large numbers" (leading zeros removed, 15 digits of precision, scientific notation). The row and column ceiling of 1,048,576 by 16,384 is from those Microsoft pages. The comma, CRLF and quoting rules are from RFC 4180. All were checked on the day this page was published.
Related reading
Data Cleaning — other guides that pair well with this one.
- Remove Duplicates from CSV
- Remove Blank Rows from CSV
- How to Open a CSV File in Windows (Notepad, Excel, PowerShell)
- How to Open a CSV File on Android (Google Sheets, Text Editors, File Managers)
Browse all guides in the NoCodeCSV blog.