csv file not saving problem

Question

After creating a csv file with python using read + option, open the file and edit it directly, and do not press ctrl+s or click the save button,

but click the X mark on the top bar to save, a message asking "Do you want to save the changes to this file?" will appear.

When I click save in the pop-up, it does not save and exit normally, but the "Do you want to save the changes to this file?" pop-up message continues to appear and does not save.

Also, if I log out, it saves normally and exits. How can I solve this?

It does not seem to be a permission issue, and the CSV file was not created as read-only when it was created.

Answer 1

Hi @seungyun oh

open the file and edit it directly

Do you open this .csv file via Excel?

If so, please this file is completely released in Python.

Also, if I log out, it saves normally and exits.

What program did you log out? Did you end the Excel process in Task Manager?

Excel often creates a temporary file when you open a file, please go to the folder where your CSV is saved, check whether there is any file starting with ~$, and delete it.

Besides, I suggest you follow the steps in "Troubleshoot why Excel doesn't save changes".

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---