I have a problem importing user from a csv file

Hi, yes I am using excel and exporting as csv UTF-8 with commas.

However, in this case, for trying out the ""-wrapping, I also used MSword as Excel created double ""s.
It looked like this: """firstname""", """lastname""" etc.
I then needed word to enter " instead of """.

I then copied and pasted the text into the csv-file.

You shouldn't need to manually edit the CSV. Export 1 row so the structure is there, then open in your CSV editor with the settings provided earlier and you should be all set. I've retested imports and am not having any issues at this time so I'm guessing your CSV editor settings maybe not quite right. We provide JSON and XML import/export as well that you could try. I'm not sure what more to suggest as I don't own Excel only LibreOffice Calc and Google Sheets have been explicitly tested.

Some improvements were made to the CSV functions in PHP 7.4 that we had not yet adopted. I'm looking into replacing our usage with a more up to date usage that will eliminate formatting concerns, but I'm still not yet entirely sure that's what is causing your problem.

The improvements are pending review, but if you've already updated to CB 2.11.0 I can install the patched build for you if you PM backend login credentials to give it a try. I've re-tested import/export with the improvements and confirmed working. Basically just switched from manually row handling to fputcsv, which will be a lot more reliable when exporting.

Thank you so much!
Yes I have the 2.11.0 version installed.

Now I tried to change the semicola I automatically have in my csv-exports into kommas by using the text-editor instead of word.
It worked.
So I am happy now.

Something else I changed in the saving options was from UTF-8 with BOM (whatever that is) to only UTF-8
You might know if that could have had any impact...

Thank you, problem solved.

Kind regards
Peter