I watched it, while importing a previous exported CSV transactions, but I believe other CSV imports are affected, too. 1. If the locale setting has comma as decimal symbol - or it was manually selected -, it can not be the separator. In this case semicolon becomes the separator. 2. It should be possible to guess the date component order from the locales. 3. The order of fields seems slightly different, resulting in right association of columns at the beginning, but not for notes etc. Solving above points would save many mouse clicks 4. Match accounts: "To change mapping ..." should only be red as long as not fulfilled.
In theory I would expect, export followed by import of the same file, should be possible without changing settings - not only for LANG=C.