Skip to content

PHP encoding Umlauts in .csv for Excel

I’m working on a PHP script that creates a .csv file from some data. Unfortunately, in Excel Umlauts are not displayed properly: Löl becomes L√∂l (this is just in Excel, in Apple’s Numbers, Atom and Textedit everything looks fine). I have tried hundreds of functions to try and get the encoding rig…