# Export CSV does not format data

**URL:** <https://primero.supporthub.dev/forum/t/export-csv-does-not-format-data/471>\
**Category:** CPIMS\
**Tags:** v1-7\
**Created:** [August 23, 2021, 11:16am UTC](https://primero.supporthub.dev/forum/t/export-csv-does-not-format-data/471 "2021-08-23T11:16:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shettyajit9](https://primero.supporthub.dev/forum/letter_avatar_proxy/v4/letter/s/e8c25b/32.png) [@shettyajit9](https://primero.supporthub.dev/forum/u/shettyajit9)\
**Post date:** [August 23, 2021, 11:16am UTC](https://primero.supporthub.dev/forum/t/export-csv-does-not-format-data/471/1 "2021-08-23T11:16:32Z")

</div>

Hi All,

We have certain users whose default language is English, But they have to use Arabic in some text fields. When they try to export the cases in bulk, the Arabic data/Text is not formatted properly. How to fix this?

---

<div class="post-metadata">

**Author:** ![jack.miszencin](https://primero.supporthub.dev/forum/letter_avatar_proxy/v4/letter/j/90ced4/32.png) [@jack.miszencin](https://primero.supporthub.dev/forum/u/jack.miszencin)\
**Post date:** [August 24, 2021, 9:52am UTC](https://primero.supporthub.dev/forum/t/export-csv-does-not-format-data/471/2 "2021-08-24T09:52:36Z")

</div>

Hi Ajit,

Any time users export record data which includes non-Latin characters (e.g. Arabic, Kurdish, Thai) to a CSV file, they basically need to tell Excel to read that file according to UTF-8 format. I’ve created a demo video on how to do this: [arabic-kurdish-characters-from-csv.mp4 - Google Drive](https://drive.google.com/file/d/1TujQ5NToj2MFCRZbpwZHBXhVUoTBOFx9/view?usp=sharing)

Please let me know if you have any other questions.

Thanks,  
Jack