Withdata Software

Convert JSON with attributes to CSV

I want to convert some NFT metadata JSON files to CSV for opensea.

JSON data like this:

{
  "name": "5",
  "description": "",
  "external_url": "",
  "image": "5.png",
  "attributes": [
    {
      "trait_type": "Background",
      "value": "DOT-6"
    },
    {
      "trait_type": "Luckbox",
      "value": "3"
    }
  ],
  "properties": {
    "files": [
      {
        "uri": "5.png",
        "type": "image/png"
      }
    ],
    "category": "image",
    "creators": []
  },
  "compiler": "NFTexport.io"
}

The “attributes” array, need to be converted to

attributes[Background], attributes[Luckbox]
DOT-6, 3

I used Data File Converter, figured out to converting these JSON file to CSV, in a minutes.

1. Open JSON file in DataFileConverter, set JSON options.

2. Set JSON custom columns.

3. Set CSV options.

4.”Next” and “Next”, convert, get the output CSV file.