CSV not importing properly

[floeby]

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.

[floeby]

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?

[joeyk]

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

Use the right delimiter here:

Joey