# CSV not importing properly

**URL:** <https://forum.mautic.org/t/csv-not-importing-properly/32747>\
**Category:** Product Support\
**Created:** [July 13, 2024, 10:08am UTC](https://forum.mautic.org/t/csv-not-importing-properly/32747 "2024-07-13T10:08:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![floeby](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/floeby/32/1444_2.png) [@floeby](https://forum.mautic.org/u/floeby)\
**Post date:** [July 13, 2024, 10:08am UTC](https://forum.mautic.org/t/csv-not-importing-properly/32747/1 "2024-07-13T10:08:23Z")

</div>

**Your software**  
My Mautic version is: 5.1  
My PHP version is: 8.2  
My Database type and version is: Maria db

**Your problem**  
My problem is: Probably stupid mistake and my doing, but when I import a csv (utf-8) the columns are not ‘separated’ (everything is delimited by a ,) by mautic. Sometimes data from 2 columns, or lines is combined. I have tried several ways of saving the file, but I cannot seem to find any logic to it.

When I import it, all data is put in 1 contact field, even though I specified e.g. email, first name, last name etc.

These errors are showing in the log: No errors

Steps I have tried to fix the problem: saving the csv in different manners, different delimiters (😉 etc.

---

<div class="post-metadata">

**Author:** ![floeby](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/floeby/32/1444_2.png) [@floeby](https://forum.mautic.org/u/floeby)\
**Post date:** [July 13, 2024, 11:16am UTC](https://forum.mautic.org/t/csv-not-importing-properly/32747/2 "2024-07-13T11:16:55Z")

</div>

When I first put data in Notepad++ and save it as a csv it works…Was saving it in excel as a utf-8 csv file.

Anybody know how to create a proper csv file in excel?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 15, 2024, 12:03pm UTC](https://forum.mautic.org/t/csv-not-importing-properly/32747/3 "2024-07-15T12:03:11Z")

</div>

Hello,  
The case might be, that you use the worng separator.  
Try to change it to SEMICOLON, like ;

Use the right delimiter here:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/c63180497be3be81d4899f21d70350017cce6651.png)

Joey