I’m encountering an issue when writing data to a CSV file in Python. Some characters are appearing as question marks inside a square box, which I believe indicates an encoding problem.
When I open the CSV file in Notepad, the characters display correctly (for example, “ö” is shown as expected). However, when I open the same file in Excel, some characters appear as question marks inside a square box.