# ODK briefcase data export from ODK collect

**URL:** <https://forum.getodk.org/t/odk-briefcase-data-export-from-odk-collect/35948>\
**Category:** Support\
**Tags:** odk-briefcase\
**Created:** [November 29, 2021, 6:12pm UTC](https://forum.getodk.org/t/odk-briefcase-data-export-from-odk-collect/35948 "2021-11-29T18:12:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adil\_mansour](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/49beb7/32.png) [@adil\_mansour](https://forum.getodk.org/u/adil_mansour)\
**Post date:** [November 29, 2021, 6:12pm UTC](https://forum.getodk.org/t/odk-briefcase-data-export-from-odk-collect/35948/1 "2021-11-29T18:12:18Z")

</div>

Dear members,

i have the data in my android odk folder and now i have not access to the server where our data has been sent, i need the data once again, i am using ODK briefcase to pull and export the data. when i export the data in CSV file, it shows only numbers and the text shows with unknown marks. additionally, the columns name (the question asked from respondent) is also shows as a short code (A-a1 ... etc). can any one help me in this regard, how to export my data correctly from my android ODK folder??  
also, the exported data is saved in 3 files  
your help is most appreciated in advance.

bellow is screen shot of exported data. ![exported data](https://getodk.b-cdn.net/uploads/default/original/3X/c/1/c1fd6b35bedb45116b23fdcb6505ebb7eb92570d.jpeg)

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [November 29, 2021, 7:07pm UTC](https://forum.getodk.org/t/odk-briefcase-data-export-from-odk-collect/35948/2 "2021-11-29T19:07:35Z")

</div>

Excel will not import CSVs with Unicode characters like ã, ß, and 箸 correctly if you double-click the file or open it from the File menu. You must use the [Text Import Wizard](https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857) and specify a file origin of Unicode (UTF-8, 65001) and the comma delimiter.

---

<div class="post-metadata">

**Author:** ![adil\_mansour](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/a/49beb7/32.png) [@adil\_mansour](https://forum.getodk.org/u/adil_mansour)\
**Post date:** [November 30, 2021, 4:24am UTC](https://forum.getodk.org/t/odk-briefcase-data-export-from-odk-collect/35948/3 "2021-11-30T04:24:56Z")

</div>

Thank you so much @yanokwa , in above screenshot, the columns "M,N,O" are text column column (Name, F/Name, province) in Pashto Language, now they give it like unknown marks. also, the column name (name, F/Namer, province) is not exported while instead codes (A-a1, A-a2 .....) are replaced in column.  
please let me know if there is any other tools/method to export my data correctly.  
thank you very much once again.