Forum Discussion
Editing a CSV file in Excel but Changes are lost when Saved Back to CSV
Hi, I have a CSV file where I need to make all letters lowercase. I make the changes in the CSV and save but when I go back into the file they are lost. I tried beginning with an Excel workbook...
From your description, my guess--and that's what it is--is that you actually are reopening the original CSV file.
Two suggestions:
- Open the CSV and save it as an Excel file. Then edit it. Then save it again, still as an Excel file. (That way you can always reopen the edited Excel, not losing any work you've done.)
- Then save it again as CSV but either give it a different name OR make sure you're saving it to a different folder than the original (or both).