Export CSV by PHP for utf-8 characters

Question

I need to export a .csv file with php. I used below code to do that:

header('Content-Encoding: UTF-8');
header('Content-type: application/csv; charset=UTF-8');
header("Content-Disposition: attachment; filename=$fn");
echo "\xEF\xBB\xBF"; // UTF-8 BOM
print($csv);

$csv contains some persian characters. When i opened the exported file with ms excel, wrong characters showed. When i opened file with notepad characters showed right. how can i solve this problem?

is your original content in utf8? if you use utf8_encode on your $csv does that help? — scott
– scott, Commented Apr 28, 2012 at 7:25
Original content is in utf8. But i did not use any tag in php file for defining that, like [<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />] — sajad nabavi
– sajad nabavi, Commented Apr 28, 2012 at 7:33
You may want to test that. I've had problems in the past with such. At all points it should be in utf8 (ie. your database you are loading it from). Also reading this drupal.org/node/172996 seems it could be an inherent problem with csv files; one person suggests saving as .txt and opening the .txt as a csv in excel since .txt supports utf8 and csv only ascii — scott
– scott, Commented Apr 28, 2012 at 7:37
Excel is just notoriously bad at importing "weird" (in large quotes) encodings. Try its File > Import functions, not the regular double click. — deceze
– deceze ♦, Commented Apr 28, 2012 at 7:58

hyperplural · Accepted Answer · 2018-09-04 06:06:05Z

2

Here's how I did it.

header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header("Content-Disposition: attachment; filename=file.csv");
header("Pragma: no-cache");
header("Expires: 0");
header('Content-Transfer-Encoding: binary');
echo "\xEF\xBB\xBF";

Earlier i was getting garbage characters now correct data is exported.

edited Sep 4, 2018 at 6:06

hyperplural

2356 silver badges23 bronze badges

answered Apr 29, 2014 at 10:55

Dinum Dissanayaka

3862 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export CSV by PHP for utf-8 characters

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related