# Blank value for selected field when importing csv

**URL:** <https://forum.mautic.org/t/blank-value-for-selected-field-when-importing-csv/38027>\
**Category:** Product Support\
**Created:** [April 1, 2026, 11:50am UTC](https://forum.mautic.org/t/blank-value-for-selected-field-when-importing-csv/38027 "2026-04-01T11:50:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ivan.totev](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ivan.totev/32/14961_2.png) [@ivan.totev](https://forum.mautic.org/u/ivan.totev)\
**Post date:** [April 1, 2026, 11:50am UTC](https://forum.mautic.org/t/blank-value-for-selected-field-when-importing-csv/38027/1 "2026-04-01T11:50:12Z")

</div>

![Screenshot 2026-04-01 at 12.43.22](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e68f57ae8299ffbf7c05b3677bfc9e43b92d8432.png)  
I am importing 40k of those rows. For about 300 of them it does not like the bundesland value and it is empty. I can see it has been set to this value and then removed.

What should I do to fix this? It is weird as it does it for some of those. The majorty of them are fine. I checked the utf formating , I checked if the values have spaces or anything else. What can I do to fix this? I am technical and I can make changes to the mautic code just not sure where I can look it up.

This is a select field and the values are as provided. I was thinking it is the umlauts in German but they are not as it does it for values that do not have them too.

 ![Screenshot 2026-04-01 at 12.47.25](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/9/9a35dcad701e3b510669b070ab168c0be601b5a0.png)

---

<div class="post-metadata">

**Author:** ![rcarabelli](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rcarabelli/32/6807_2.png) [@rcarabelli](https://forum.mautic.org/u/rcarabelli)\
**Post date:** [April 2, 2026, 12:53am UTC](https://forum.mautic.org/t/blank-value-for-selected-field-when-importing-csv/38027/2 "2026-04-02T00:53:02Z")

</div>

Probably is the collation in your csv file.  
Open the csv file in a program like sublime text, check if the lines are showing ok, then save the file with a new character set, like utf8mb4 or specifically a collation like utf8mb4\_0900\_ai\_ci probably.

After that, try importing again.