How can I output a UTF-8 CSV in PHP that Excel will read properly?

by

I have the same (or similar) problem.

In my case, if I add a BOM to the output, it works:

header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename=Customers_Export.csv');
echo "\xEF\xBB\xBF"; // UTF-8 BOM

I believe this is a pretty ugly hack, but it worked for me, at least for Excel 2007 Windows. Not sure it’ll work on Mac.

More Related Contents:

  1. How do I remove  from the beginning of a file?
  2. How to remove multiple UTF-8 BOM sequences
  3. UTF-8 BOM signature in PHP files
  4. Detect encoding and make everything UTF-8
  5. file_get_contents() Breaks Up UTF-8 Characters
  6. Elegant way to search for UTF-8 files with BOM?
  7. How to best configure PHP to handle a UTF-8 website [duplicate]
  8. php implode (101) with quotes
  9. Unable to retrieve UTF-8 accented characters from Access via PDO_ODBC
  10. How to sort an array of UTF-8 strings?
  11. PHP CSV string to array
  12. Getting ’ instead of an apostrophe(‘) in PHP
  13. Read large data from csv file in php [duplicate]
  14. How to set UTF-8 encoding for a PHP file
  15. php header excel and utf-8
  16. json_encode() non utf-8 strings?
  17. UTF-8 encoding for subject in contact form email
  18. Remove trailing delimiting character from a delimited string
  19. How to iterate UTF-8 string in PHP?
  20. URL Decoding in PHP
  21. How can I detect a malformed UTF-8 string in PHP?
  22. How to use the CSV MIME-type?
  23. how do i parse a csv file to grab the column names first then the rows that relate to it?
  24. utf8_(en|de)code removed from php7?
  25. PHP json_encode json_decode UTF-8
  26. Reports in Codeigniter
  27. Process very big csv file without timeout and memory error
  28. Decoding numeric html entities via PHP
  29. Send emails with international accent and special characters
  30. Trim unicode whitespace in PHP

Leave a Comment