I think this is similar to this thread. You will have some fields containing carriage returns that causes issues when opened. I still see this in some of my CSV exports as well where I have carriage returns in the cells that break the formatting.
If you are able to query the data using the OData URL instead you will get better formatted content.