PHP
(quick examples)
JSON TO ARRAY $json = '[ ["Jon Doe","jon@doe.com"], ["Joy Doe","joy@doe.com"] ]'; $data = json_decode($json);
WRITE TO CSV $fh = fopen("demoA.csv", "w"); foreach ($data as $r) { fputcsv($fh, $r); } fclose($fh);
JSON TO ARRAY $json = '{ "NAME":["Jon Doe","Joy Doe"], "EMAIL":["jon@doe.com","joy@doe.com"] }'; $data = json_decode($json, true);
GET KEYS & TOTAL ENTRIES $keys = array_keys($data); $all = count($data[$keys[0]]);
WRITE TO CSV $fh = fopen("demoB.csv", "w"); fputcsv($fh, $keys); for ($i=0; $i<$all; $i++) { $r = []; foreach ($keys as $k) { $r[] = $data[$k][$i]; } fputcsv($fh, $r); } fclose($fh);