php export data with accents into csv

Question

I have the following code that creates a csv file:

$data=array();
array_push($data,"Société"); //word with french accent


header('Content-Type:text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="test.csv"');


$fp = fopen('php://output', 'w');
foreach ( $data as $line ) {
    $val = explode(",", $line);
    fputcsv($fp, array_map('utf8_decode',array_values($val)), ',', '"');
}
fclose($fp);

However when I open the csv file, the character é is replaced by a question mark ?.

Any help how to resolve this?

Fanghornn · Accepted Answer · 2015-02-05 13:21:59Z

1

Did you tried removing the "utf8_decode" argument in your array_map call ?

If you call the function "utf8_decode" on a UTF-8 string, it will return it under LATIN-1 encoding which doesn't support accents.

See the PHP documentation of utf8_decode > http://php.net/manual/en/function.utf8-decode.php

Bon courage.

answered Feb 5, 2015 at 13:21

Fanghornn

563 bronze badges

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

1 Comment

Ketan Over a year ago

I have replaced the line by fputcsv($fp, $val); and it still does not show correctly when I open the resulting file in OpenOffice.

Eun · Accepted Answer · 2015-02-05 13:20:41Z

0

I had an similar problem a while ago, I fixed it by adding the 3 byte UTF8 representation before any csv line:

header('Content-Type: application/x-download');
header("Content-Transfer-Encoding: binary");
header('Content-Disposition: attachment; filename="export-'.time().'.csv"');

echo chr(0xEF);
echo chr(0xBB);
echo chr(0xBF);

answered Feb 5, 2015 at 13:20

Eun

4,1885 gold badges32 silver badges51 bronze badges

Comments

Ketan · Accepted Answer · 2015-02-13 06:39:40Z

0

I used UTF-8 characters in the string. I replaced

array_push($data,"Société"); //word with french accent

with

array_push($data,"Soci\xc3\xa9t\xc3\xa9"); //word with french accent

answered Feb 13, 2015 at 6:39

Ketan

1231 gold badge2 silver badges10 bronze badges

Collectives™ on Stack Overflow

php export data with accents into csv

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related