# Not importing foreign characters

**URL:** https://forum.mautic.org/t/not-importing-foreign-characters/3518
**Category:** Product Support
**Created:** [April 14, 2016, 2:01pm UTC](https://forum.mautic.org/t/not-importing-foreign-characters/3518 "2016-04-14T14:01:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![ralfhug](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@ralfhug](https://forum.mautic.org/u/ralfhug)
#### Post date: [April 14, 2016, 2:01pm UTC](https://forum.mautic.org/t/not-importing-foreign-characters/3518/1 "2016-04-14T14:01:00Z")

</div>

Having trouble importing Contacts with non US characters, i.e. German Umlauts öäü etc. via a csv file. Result is it cuts off Umlaut and every letter thereafter. Any advice?

---

<div class="post-metadata">

### Author: ![ralfhug](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@ralfhug](https://forum.mautic.org/u/ralfhug)
#### Post date: [April 14, 2016, 2:01pm UTC](https://forum.mautic.org/t/not-importing-foreign-characters/3518/2 "2016-04-14T14:01:00Z")

</div>

Having trouble importing Contacts with non US characters, i.e. German Umlauts öäü etc. via a csv file. Result is it cuts off Umlaut and every letter thereafter. Any advice?

---

<div class="post-metadata">

### Author: ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [April 15, 2016, 5:41am UTC](https://forum.mautic.org/t/not-importing-foreign-characters/3518/3 "2016-04-15T05:41:24Z")

</div>

Make sure that the CSV file is in UTF8 encoding. Open Office Calc is great for setting the encoding.

---

<div class="post-metadata">

### Author: ![ralfhug](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@ralfhug](https://forum.mautic.org/u/ralfhug)
#### Post date: [April 16, 2016, 11:56am UTC](https://forum.mautic.org/t/not-importing-foreign-characters/3518/4 "2016-04-16T11:56:30Z")

</div>

Using Open Office to save in UTF8 worked and the import is now fine. I tried saving it in Excel on a Mac and Windows PC as a UTF8 CSV but nothing seemed to work. Open Office indeed did the job. Thanks.
