If you are try to export data from Notion to CSV and it doesn’t work, it might be because you are doing this in Notion’s desktop app.
There seems to be a bug in Notion’s desktop version with CSV exports.
Luckily, there is an easy workaround that fixes this frustrating issue!
To export data to CSV from Notion's desktop app, you need to open the Notion web app in your browser.
From there, open the page you want to export from, click on the three dots in the top right corner, and select "Export".
Then select Markdown & CSV from the dropdown menu and this should generate a zip folder with .csv file that works just fine and opens in Excel with no issues.
If you're still having trouble after following the steps above, it's best to contact Notion's customer support team. They can help you resolve the issue and answer any questions you have.