After Exporting Content to CSV, especially containing JSON data, there may be instances of blank rows or other data issues after opening in Microsoft Excel
This is a known issue regarding a limitation to Microsoft Excel. There is a limit of 32,767 characters that can exist in one cell.
See this Microsoft Support Article
Opening a CSV that contains data in a cell that exceeds this 32,767 character limit in Microsoft Excel will cause a data overflow, resulting in formatting errors, gaps in rows, and misplaced data. This will make the CSV file unusable. If you are experiencing this issue, please delete the file, export a new CSV, and DO NOT open the file in Excel. Instead, it is recommended that you open the file in a text editor, such as notepad. If you are editing this file in a text editor, make sure you keep it saved in CSV format.