Thread:Help talk:CSV format/Problems with umlaut/reply (2)

I've run into the same issue as well and have a patch which at least fixes it for me. I see that SMW exports the data as UTF-8, but Excel can't figure that out, and it's a bit of a hassle to import the data in the correct format. The solution to this is to add the UTF-8 byte order mark to the beginning of the string to be returned (see http://roosmaa.net/importing-utf-8-csvs-in-excel/). Also setting the delimiter to a semicolon makes Excel happy.

What I've done is add the BOM around line 106 of includes/queryprinters/SMW_QP_CSV.php: $result .= stream_get_contents( $csv ); // Add the UTF-8 byte order mark (BOM) so that Excel can read this in as UTF-8 $result = chr(239). chr(187). chr(191). $result;