CSV data export with carriage returns is badly formatted

Hi @Ri_Ri

I tried the provided CSV and used "Data > Get Data (Power Query) > Text/CSV" option to load the CSV and here is the screenshot of the data, it has correctly handled the CRs:

PS: "Text Import Wizard" is a legacy feature, I couldn't make it work for the provided file.

2 Likes