{"id":22501,"date":"2024-10-26T08:16:52","date_gmt":"2024-10-26T08:16:52","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=22501"},"modified":"2024-10-26T08:16:52","modified_gmt":"2024-10-26T08:16:52","slug":"format-multiple-json-files-into-one-csv-for-ntfs-on-opensea","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/use\/format-multiple-json-files-into-one-csv-for-ntfs-on-opensea.html","title":{"rendered":"Format multiple JSON files into one CSV for NTFS on OpenSea"},"content":{"rendered":"<p>If you want to format multiple JSON files into one CSV for NTFS on <a href=\"https:\/\/opensea.io\/\" target=\"_blank\" rel=\"noopener\">OpenSea<\/a>, you can try <a href=\"https:\/\/www.withdata.com\/data-file-converter\/\" target=\"_blank\" rel=\"noopener\">Data File Converter<\/a>, just in a few mouse clicks.<\/p>\n<p>1. Open Data File Converter, select &#8220;Files&#8221; &#8211; &#8220;JSON&#8221;, &#8220;File&#8221; &#8211; &#8220;CSV&#8221;.<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/case\/opensea-json-to-csv-types.png\" alt=\"format multiple json files into one csv for ntfs on opensea - select types\" width=\"615\" height=\"443\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>2. Choose OpenSea JSON metadata files folder.<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/case\/opensea-json-to-csv-source-folder.png\" alt=\"format multiple json files into one csv for ntfs on opensea - json folder\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Config JSON options.<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/case\/opensea-json-to-csv-config-json.png\" alt=\"format multiple json files into one csv for ntfs on opensea - config json\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>Custom JSON columns.<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/case\/opensea-json-to-csv-custom-columns.png\" alt=\"format multiple json files into one csv for ntfs on opensea - custom columns\" width=\"602\" height=\"465\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>3. Set CSV options.<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/case\/opensea-json-to-csv-config-csv.png\" alt=\"format multiple json files into one csv for ntfs on opensea - set CSV\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>4. &#8220;Next&#8221; and &#8220;Next&#8221;, convert, get the output CSV file, like this:<\/p>\n<pre>name,description,external_url,image,properties\/files,properties\/category,properties\/creators,compiler,attributes[Background],attributes[Luckbox]\r\n1,,,1.png,\"[{\"uri\":\"1.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,BLAU3,4\r\n2,,,2.png,\"[{\"uri\":\"2.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,BLAU2,1\r\n3,,,3.png,\"[{\"uri\":\"3.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,DOT-8,1\r\n4,,,4.png,\"[{\"uri\":\"4.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,HYBRID3,1\r\n5,,,5.png,\"[{\"uri\":\"5.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,DOT-6,3\r\n6,,,6.png,\"[{\"uri\":\"6.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,NOT WHITE 1,1\r\n7,,,7.png,\"[{\"uri\":\"7.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,DOT-8,4\r\n8,,,8.png,\"[{\"uri\":\"8.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,NOT WHITE 3,3\r\n9,,,9.png,\"[{\"uri\":\"9.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,DOT-1,4\r\n10,,,10.png,\"[{\"uri\":\"10.png\",\"type\":\"image\/png\"}]\",image,[],NFTexport.io,HYBRID3,5\r\n\r\n...\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you want to format multiple JSON files into one CSV for NTFS on OpenSea, you can try Data File Converter, just in a few mouse clicks. 1. Open Data File Converter, select &#8220;Files&#8221; &#8211; &#8220;JSON&#8221;, &#8220;File&#8221; &#8211; &#8220;CSV&#8221;. 2. Choose OpenSea JSON metadata files folder. Config JSON options. Custom JSON columns. 3. Set CSV [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3141],"tags":[34,1418,1498,3692,3693],"class_list":["post-22501","post","type-post","status-publish","format-standard","hentry","category-use","tag-csv","tag-json","tag-json-to-csv","tag-ntfs","tag-opeasea"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=22501"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22501\/revisions"}],"predecessor-version":[{"id":22502,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22501\/revisions\/22502"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=22501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=22501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=22501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}