# CSV data export with carriage returns is badly formatted

**URL:** <https://forum.getodk.org/t/csv-data-export-with-carriage-returns-is-badly-formatted/47980>\
**Category:** Support\
**Tags:** odk-central\
**Created:** [July 6, 2024, 10:26pm UTC](https://forum.getodk.org/t/csv-data-export-with-carriage-returns-is-badly-formatted/47980 "2024-07-06T22:26:54Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![Sadiq\_Khoja](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/sadiq_khoja/32/3719_2.png) [@Sadiq\_Khoja](https://forum.getodk.org/u/Sadiq_Khoja)\
**Post date:** [July 9, 2024, 4:02pm UTC](https://forum.getodk.org/t/csv-data-export-with-carriage-returns-is-badly-formatted/47980/15 "2024-07-09T16:02:56Z")

</div>

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:

 ![image](https://getodk.b-cdn.net/uploads/default/original/3X/5/5/55199532c62ee2a5419212eb1162c35a69da7502.png)

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

---

_[View the full topic](https://forum.getodk.org/t/csv-data-export-with-carriage-returns-is-badly-formatted/47980)._