This article details the steps required if you are seeing issues when opening a report or gate export CSV file from GatedContent.com in Excel. Specifically, if you are encountering an issue where records appear misaligned and fields with line breaks in them are causing breaks in your actual data.
This is caused by a problem with the way that Excel interprets CSV data, rather than any issue with the file itself. In this scenario, you should use another piece of software such as Google Sheets or Libre Office (both of which are free) to import the CSV file. You can then either work with your data in those programs or export it from there into Excel format. This exported file should then open correctly in Excel.
Unfortunately, because this is an issue with Excel rather than in the exported CSV files, we aren't able to offer any other solutions to this problem.