When importing a CSV file in Excel 2016, if any of the fields have new lines, Excel treats them as the end of the field making the document unaligned.
Incompatibility with Excel 2016.
- Open the exported CSV file in LibreOffice or any older version of Excel than 2016.
- Save the same file as an xls or xlsx file.
- Open the file in Excel 2016 with no missing columns or rows.