Hi @albertosa
If you export a fresh CSV and open it in Notepad, is the data formatted correctly then? Usually with issues like this we find the CSV is correct, and 99% of the time the issue is the way that Excel processes the data when opening the file.
The workaround is to open a blank workbook instead of opening your file directly in Excel. Then, you can import the CSV from the Data > From Text/CSV menu option. You will get a preview of the data with different encoding options before importing. Unless you have an unusual WordPress configuration, the default encoding should be fine, and you’ll see the CSV opened correctly in Excel using this method.
If you have any trouble with this, I would recommend reaching out to the Microsoft Excel support team for assistance.
Best,
Nathanael.