{"id":1496,"date":"2023-01-24T01:27:20","date_gmt":"2023-01-23T19:57:20","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=1496"},"modified":"2023-01-24T01:27:20","modified_gmt":"2023-01-23T19:57:20","slug":"how-to-convert-json-to-csv-using-linux-unix-shell","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/","title":{"rendered":"How to convert JSON to CSV using Linux \/ Unix shell"},"content":{"rendered":"<p>There are several ways to convert JSON to CSV using Linux or Unix shell, here are a few popular options:<\/p>\n<ol>\n<li>Using <code>jq<\/code>: <code>jq<\/code> is a command-line JSON processor that can be used to convert JSON to CSV. The basic command to convert a JSON file to CSV using <code>jq<\/code> is:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre-wrap hljs language-lua\">jq -r <span class=\"hljs-string\">'.'<\/span> <span class=\"hljs-built_in\">input<\/span>.json | jq -r -s <span class=\"hljs-string\">'.'<\/span> | jq -r -c <span class=\"hljs-string\">'.[]'<\/span> | jq -r <span class=\"hljs-string\">'map(keys) | add | unique | .[] as $col | map(. as $row | $col | map($row[.]))[]'<\/span> | jq -r -c <span class=\"hljs-string\">'.'<\/span> &gt; <span class=\"hljs-built_in\">output<\/span>.csv<br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"2\">\n<li>Using <code>csvkit<\/code>: <code>csvkit<\/code> is a suite of command-line tools for working with CSV files. To convert a JSON file to CSV using <code>csvkit<\/code>, you can use the following command:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre-wrap hljs language-lua\">in2csv <span class=\"hljs-built_in\">input<\/span>.json &gt; <span class=\"hljs-built_in\">output<\/span>.csv<br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"3\">\n<li>Using <code>python<\/code>: You can also use python and its library <code>pandas<\/code> to convert json to csv. You can use the following command:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre-wrap hljs language-rust\">python -c <span class=\"hljs-symbol\">'import<\/span> pandas <span class=\"hljs-keyword\">as<\/span> pd, json; pd.<span class=\"hljs-title function_ invoke__\">read_json<\/span>(<span class=\"hljs-string\">\"input.json\"<\/span>).<span class=\"hljs-title function_ invoke__\">to_csv<\/span>(<span class=\"hljs-string\">\"output.csv\"<\/span>, index=False)'<br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"4\">\n<li>Using <code>jansson<\/code>: Jansson is a C library for encoding, decoding and manipulating JSON data, you can use the command <code>json_unpack<\/code> to convert json to csv<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre-wrap hljs language-lua\">json_unpack -c <span class=\"hljs-string\">','<\/span> <span class=\"hljs-built_in\">input<\/span>.json &gt; <span class=\"hljs-built_in\">output<\/span>.csv<br \/>\n<\/code><\/div>\n<\/div>\n<p>Please note that all of these commands requires the installation of the mentioned tools. Also, depending on the structure of your JSON file, the output may not be exactly as you expect. It&#8217;s always a good idea to test the command on a small subset of your data before running it on the entire file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are several ways to convert JSON to CSV using Linux or Unix shell, here are a few popular options: Using jq: jq is a command-line JSON processor that can be used to convert JSON to CSV. The basic command to convert a JSON file to CSV using jq is: jq -r &#8216;.&#8217; input.json | &#8230; <a title=\"How to convert JSON to CSV using Linux \/ Unix shell\" class=\"read-more\" href=\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\" aria-label=\"Read more about How to convert JSON to CSV using Linux \/ Unix shell\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1496","post","type-post","status-publish","format-standard","hentry","category-best-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to convert JSON to CSV using Linux \/ Unix shell - TrySitePrice<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to convert JSON to CSV using Linux \/ Unix shell - TrySitePrice\" \/>\n<meta property=\"og:description\" content=\"There are several ways to convert JSON to CSV using Linux or Unix shell, here are a few popular options: Using jq: jq is a command-line JSON processor that can be used to convert JSON to CSV. The basic command to convert a JSON file to CSV using jq is: jq -r &#039;.&#039; input.json | ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\" \/>\n<meta property=\"og:site_name\" content=\"TrySitePrice\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-23T19:57:20+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\"},\"author\":{\"name\":\"Rahul Sahu\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\"},\"headline\":\"How to convert JSON to CSV using Linux \/ Unix shell\",\"datePublished\":\"2023-01-23T19:57:20+00:00\",\"dateModified\":\"2023-01-23T19:57:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\"},\"wordCount\":181,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"articleSection\":[\"Best\/Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\",\"name\":\"How to convert JSON to CSV using Linux \/ Unix shell - TrySitePrice\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\"},\"datePublished\":\"2023-01-23T19:57:20+00:00\",\"dateModified\":\"2023-01-23T19:57:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/trysiteprice.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to convert JSON to CSV using Linux \/ Unix shell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"name\":\"TrySitePrice\",\"description\":\"Free Website Value Calculator Tool\",\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\",\"name\":\"TrySitePrice\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"contentUrl\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"width\":395,\"height\":268,\"caption\":\"TrySitePrice\"},\"image\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\",\"name\":\"Rahul Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"caption\":\"Rahul Sahu\"},\"sameAs\":[\"https:\/\/trysiteprice.com\/blog\"],\"url\":\"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to convert JSON to CSV using Linux \/ Unix shell - TrySitePrice","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/","og_locale":"en_US","og_type":"article","og_title":"How to convert JSON to CSV using Linux \/ Unix shell - TrySitePrice","og_description":"There are several ways to convert JSON to CSV using Linux or Unix shell, here are a few popular options: Using jq: jq is a command-line JSON processor that can be used to convert JSON to CSV. The basic command to convert a JSON file to CSV using jq is: jq -r '.' input.json | ... Read more","og_url":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/","og_site_name":"TrySitePrice","article_published_time":"2023-01-23T19:57:20+00:00","author":"Rahul Sahu","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#article","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/"},"author":{"name":"Rahul Sahu","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4"},"headline":"How to convert JSON to CSV using Linux \/ Unix shell","datePublished":"2023-01-23T19:57:20+00:00","dateModified":"2023-01-23T19:57:20+00:00","mainEntityOfPage":{"@id":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/"},"wordCount":181,"commentCount":0,"publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"articleSection":["Best\/Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/","url":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/","name":"How to convert JSON to CSV using Linux \/ Unix shell - TrySitePrice","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/#website"},"datePublished":"2023-01-23T19:57:20+00:00","dateModified":"2023-01-23T19:57:20+00:00","breadcrumb":{"@id":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/trysiteprice.com\/blog\/how-to-convert-json-to-csv-using-linux-unix-shell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trysiteprice.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to convert JSON to CSV using Linux \/ Unix shell"}]},{"@type":"WebSite","@id":"https:\/\/trysiteprice.com\/blog\/#website","url":"https:\/\/trysiteprice.com\/blog\/","name":"TrySitePrice","description":"Free Website Value Calculator Tool","publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/trysiteprice.com\/blog\/#organization","name":"TrySitePrice","url":"https:\/\/trysiteprice.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","contentUrl":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","width":395,"height":268,"caption":"TrySitePrice"},"image":{"@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4","name":"Rahul Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","caption":"Rahul Sahu"},"sameAs":["https:\/\/trysiteprice.com\/blog"],"url":"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/"}]}},"_links":{"self":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/1496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/comments?post=1496"}],"version-history":[{"count":2,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/1496\/revisions"}],"predecessor-version":[{"id":1501,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/1496\/revisions\/1501"}],"wp:attachment":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/media?parent=1496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/categories?post=1496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/tags?post=1496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}