How can I output a UTF-8 CSV in PHP that Excel will read properly? -
How can I output a UTF-8 CSV in PHP that Excel will read properly? - i've got simple thing outputs stuff in csv format, it's got utf-8. open file in textedit or textmate or dreamweaver , displays utf-8 characters properly, if open in excel it's doing silly íÄ kind of thing instead. here's i've got @ head of document: header("content-type:application/csv;charset=utf-8"); header("content-disposition:attachment;filename=\"chs.csv\""); this seems have desired effect except excel (mac, 2008) doesn't want import properly. there's no options in excel me "open utf-8" or anything, … i'm getting little annoyed. i can't seem find clear solutions anywhere, despite lot of people having same problem. thing see include bom, can't figure out how that. can see above i'm echo ing data, i'm not writing file. can if need to, i'm not because there doesn't seem need @ point. help? update: tried ech