Json to csv with cyrillic

Question

This is my php code:

<?php 
$jsonData = file_get_contents("1.json");
$jsonDecoded = json_decode($jsonData);

$csv = '1.csv';
$fileCsv = fopen($csv, 'w');
foreach($jsonDecoded as $i){
    fputcsv($fileCsv, $i);
}

fclose($fileCsv);

?>

In 1.json I have data written in cyrillic. Whene 1.csv is opened via Excel, there is a problem with decoding it. It shows me non-cyrillic random symbols. Why is it so? How can I fix it?

I'm not sure where this problem comes from. It could be just problem with Excel? I'm using Excel 2016.

The desired ecxel:

How it actually looks like:

Please check https://stackoverflow.com/q/6002256/367456 and https://stackoverflow.com/q/155097/367456 . — hakre, Dec 02 '22 at 22:11

score 0 · Accepted Answer · answered Dec 02 '22 at 22:11

0

A utf8 CSV file has a Byte Order Mark as its first three octets. These are the hex values 0xEF, 0xBB, 0xBF. So you can do:

$fileCsv = fopen($csv, 'w');
fprintf($fileCsv, chr(0xEF).chr(0xBB).chr(0xBF));
foreach($jsonDecoded as $i){
    fputcsv($fileCsv, $i);
}

fclose($fileCsv);

answered Dec 02 '22 at 22:11

dave

62,300
5
72
93

Thank you! It worked. Just one last question. What does chr(0xEF) mean? – Uli Dec 02 '22 at 23:08
it's converting the hex value 0xEF to a character so we can write it to the file. – dave Dec 03 '22 at 00:38

Json to csv with cyrillic

1 Answers1