Hint: Import .csv with special chars (üäö)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CeWa
    Junior Member
    • Oct 2014
    • 22

    Hint: Import .csv with special chars (üäö)

    If you, like me, needs to import data from a .csv with special chars like Ü Ä Ö exported from an Excel file this might help you.

    Just importing it will replace all those chars with an ? or some garbage. Reason is that Excel saves .csv as ANSI encoding not UTF-8. Workaround is to open the .csv with the build in Windows Editor and save it again. Here you can choose UTF-8 encoding.

    Import it. Done. Hope it helps.
Working...