I'm try to import my customers from magento1 to magento2 but got a few errors on import validation.

The import is aimed at a german shop so special chars like "ä, ö, ü" are pretty common, especially in names and addresses.

I have to change the charset but can't find any spot to do that. So here's the question:

• Where do I change the charset to make the import possible ?

• What do I wrong if it isn't the charset ?

Charset is: utf8_general_ci

  • If your tables have utf8_general_ci set as default charset, all should be OK. Make sure your import scripts have the correct charset too. Jan 18, 2017 at 13:42
  • blame me... got the wrong charset on the csv. Thanks man.
    – Marcel H.
    Jan 18, 2017 at 15:14
  • These things happen haha. I suggest you answer your own question and accept it, or if you think you question wasn't really due to a bug in the first place, close it. Jan 18, 2017 at 15:23

2 Answers 2


Problem solved:

The default charset of my CSV editor wasn't UTF-8.

Thats why the import was invalid. Once i changed the csv charset in my editor to UTF-8 the import was valid.

So, the issue is

Wrong charset on my .csv file

  • You can explain more details? Jan 19, 2017 at 2:10
  • 1
    The default charset of my csv editor wasnt UTF-8 - Thats why the import was invalid. Once i changed the csv charset in my editor to UTF-8 the import was valid
    – Marcel H.
    Jan 19, 2017 at 11:30
  • btw when exporting, UTF-8 BOM is the encoding used (Idk if this affects smth, thought I should mention it)
    – medmek
    Oct 8, 2018 at 13:06
  • But! if you can't change file encoding? In my case i get data from the file that located on another server by FTP. In this case nee to encode "Name" "on fly".
    – orthener
    Apr 6, 2020 at 8:41

We can use this website to encode your special characters: http://www.web2generators.com/html-based-tools/online-html-entities-encoder-and-decoder

After getting the encoded chars, we need to use the string replace tool to replace the special characters.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.