{"id":132287,"date":"2023-03-07T05:06:52","date_gmt":"2023-03-07T05:06:52","guid":{"rendered":"https:\/\/phppot.com\/?p=20285"},"modified":"2023-03-07T05:06:52","modified_gmt":"2023-03-07T05:06:52","slug":"convert-php-json-to-csv","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2023\/03\/07\/convert-php-json-to-csv\/","title":{"rendered":"Convert PHP JSON to CSV"},"content":{"rendered":"
by Vincy<\/a>. Last modified on March 7th, 2023.<\/div>\n

This tutorial gives examples for converting a PHP JSON variable content into a CSV file.<\/p>\n

This quick example achieves it in a few steps. It uses the PHP fputcsv() method to prepare the CSV output.<\/p>\n

    \n
  1. It reads the input JSON and decodes it into an array.<\/li>\n
  2. Iterate the JSON array to read the line of the record.<\/li>\n
  3. Apply PHP fputcsv() to write the array keys in the header, followed by array values.<\/li>\n<\/ol>\n

    Quick example<\/h2>\n
    \n
    <?php function convertJsonToCSV($jsonFile, $csvFile)\n{ if (($json = file_get_contents($jsonFile)) == false) { die('Unable to read JSON file.'); } $jsonString = json_decode($json, true); $fp = fopen($csvFile, 'w'); fputcsv($fp, array_keys($jsonString[0])); for ($i = 0; $i < count($jsonString); $i ++) { fputcsv($fp, array_values($jsonString[$i])); } fclose($fp); return;\n}\n$jsonFile = 'animals.json';\n$csvFile = 'animals.csv'; convertJsonToCSV($jsonFile, $csvFile);\necho 'JSON to CSV converted. <a href=\"' . $csvFile . '\" target=\"_blank\">Download CSV file<\/a>';\n<\/code><\/pre>\n<\/div>\n
    The input JSON file is in the local drive and specified to a PHP variable $jsonFile.<\/p>\n
    This example creates a custom function convertJsonToCSV(). It requires the input JSON and the target CSV file names.<\/p>\n
    It converts the input JSON object to a PHP array. Then, it iterates the PHP array<\/a> to read the row.<\/p>\n
    This function uses the PHP fputcsv() function to write each row into the target CSV file.<\/p>\n
    Output:<\/strong><\/p>\n
    The above program will return the following CSV content in a file. In a previous tutorial, we have seen how to export to a CSV file using the PHP fputcsv() function<\/a>.<\/p>\n
    Id,Name,Type,Role\n1,Lion,Wild,\"Lazy Boss\"\n2,Tiger,Wild,CEO\n3,Jaguar,Wild,Developer\n<\/code><\/pre>\n
    Note: The input JSON must be a one-dimensional associative array to get a better output.<\/p>\n
    \"php<\/p>\n
    JSON string to CSV in PHP<\/h2>\n
    This example has a different approach to dealing with PHP JSON to CSV conversion.<\/p>\n
    It uses a JSON string as its input instead of reading a file. The JSON string input is initiated in a PHP variable and passed to the convertJSONtoCSV()<\/em> function.<\/p>\n
    It reads the JSON string and converts it into a JSON array to prepare CSV. The linked article has an example of reading CSV using PHP<\/a>.<\/p>\n
    Then, it iterates the JSON array and applies PHP fputcsv() to write the CSV row.<\/p>\n
    It reads the array_keys to supply the CSV header. And this will be executed only for the first time. It writes the column names as the first row of the output CSV.<\/p>\n
    json-string-to-csv.php<\/p>\n
    <?php\nfunction convertJsonToCSV($jsonString, $csvFile)\n{ $jsonArray = json_decode($jsonString, true); $fp = fopen($csvFile, 'w'); $header = false; foreach ($jsonArray as $line) { if (empty($header)) { $header = array_keys($line); fputcsv($fp, $header); $header = array_flip($header); } fputcsv($fp, array_merge($header, $line)); } fclose($fp); return;\n}\n$jsonString = '[ { \"Id\": \"1\", \"Name\": \"Lion\", \"Type\": \"Wild\", \"Role\": \"Lazy Boss\" }, { \"Id\": \"2\", \"Name\": \"Tiger\", \"Type\": \"Wild\", \"Role\": \"CEO\" }, { \"Id\": \"3\", \"Name\": \"Jaguar\", \"Type\": \"Wild\", \"Role\": \"Developer\" }\n]';\n$csvFile = 'animals.csv'; convertJsonToCSV($jsonString, $csvFile);\necho 'JSON to CSV converted. <a href=\"' . $csvFile . '\" target=\"_blank\">Download CSV file<\/a>';\n<\/code><\/pre>\n
    Upload CSV file to convert into JSON in PHP<\/h2>\n
    This example is to perform the JSON to CSV with a file upload option.<\/p>\n
    This code will be helpful if you want to convert the uploaded JSON file into a CSV.<\/p>\n
    It shows an HTML form with a file input field. This field will accept only \u2018.json\u2019 files. The restriction is managed with the HTML \u2018accept\u2019 attribute. It can also be validated with a server-side file validation script in PHP<\/a>.<\/p>\n
    The $_FILES[\u2018csv-file\u2019][\u2018tmp_name\u2019] contains the posted CSV file content. The JSON to CSV conversion script uses the uploaded file content.<\/p>\n
    Then, it parses the JSON and converts it into CSV. Once converted, the link will be shown to the browser to download the file.<\/p>\n
    upload-json-to-convert-to-csv.php<\/p>\n
    <?php\nif (! empty($_FILES[\"csv-file\"][\"tmp_name\"])) { $csvFile = 'animal.csv'; if (($json = file_get_contents($_FILES[\"csv-file\"][\"tmp_name\"])) == false) { die('Unable to read JSON file.'); } $jsonString = json_decode($json, true); $fp = fopen($csvFile, 'w'); fputcsv($fp, array_keys($jsonString[0])); for ($i = 0; $i < count($jsonString); $i ++) { fputcsv($fp, array_values($jsonString[$i])); } fclose($fp); echo 'JSON to CSV converted. <a href=\"' . $csvFile . '\" target=\"_blank\">Download CSV file<\/a>';\n}\n?>\n<HTML>\n<head>\n<title>Convert JSON to CSV<\/title>\n<style>\nbody { font-family: arial;\n} input[type=\"file\"] { padding: 5px 10px; margin: 30px 0px; border: #666 1px solid; border-radius: 3px;\n}\ninput[type=\"submit\"] { padding: 8px 20px; border: #232323 1px solid; border-radius: 3px; background: #232323; color: #FFF;\n}\n<\/style>\n<\/head> <body> <form method=\"post\" enctype=\"multipart\/form-data\"> <input type=\"file\" name=\"csv-file\" accept=\".json\" \/> <input type=\"submit\" name=\"upload\" value=\"Upload\"> <\/form>\n<\/body>\n<\/HTML>\n<\/code><\/pre>\n
    Download<\/a><\/p>\n
      <\/p>\n
    \n
    Popular Articles<\/h2>\n<\/p><\/div>\n
     \u2191 Back to Top<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"
    by Vincy. Last modified on March 7th, 2023. This tutorial gives examples for converting a PHP JSON variable content into a CSV file. This quick example achieves it in a few steps. It uses the PHP fputcsv() method to prepare the CSV output. It reads the input JSON and decodes it into an array. Iterate […]<\/p>\n","protected":false},"author":2,"featured_media":132288,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-132287","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php-updates"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/132287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=132287"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/132287\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media\/132288"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=132287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=132287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=132287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}