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.
Convert JSON with attributes to CSV - open JSON

2. Set JSON custom columns.
Convert JSON with attributes to CSV - set custom columns

3. Set CSV options.
Convert JSON with attributes to CSV - set CSV options

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

JSON → CSV reference

Type mapping

Value kindin JSONin CSV
Int1234 (number)1234
Decimal1234.56 (number)1234.56
Float1.234e10 (number)1.234e+10
Text"text" (string)quoted only when it contains a comma or a quote
Long text"multi-line\ntext" (escaped newline inside a string)must be quoted; line breaks inside force multi-line records
Date"2026-09-18" (string)2026-09-18
Datetime"2026-09-18T14:30:00Z" (string)2026-09-18 14:30:00
Binary"base64:..." (string)not representable - base64 or hex string
Booleantrue / false (boolean)TRUE / FALSE, or 1 / 0 depending on the writer
JSONnested object or array, kept as structurethe whole JSON value quoted, with internal quotes doubled

Dialect differences

Both JSON and CSV are file formats, so what differs below is how each one chooses to represent a value.

Propertyin JSONin CSV
identifiersDouble quotes; backslash escapesDouble quotes; a literal quote is doubled ("" )
datesNo date type: dates arrive as strings and the reader must p...Conventional text: 2026-09-18 or 2026-09-18 14:30:00
binaryNot supported natively - base64 inside a stringNot supported
separatorBraces and commasComma ","
encodingUTF-8 by definitionNo declaration - UTF-8 works only with a BOM
typingstring, number, boolean, null, object, array - no date typeNone - every field is text
shapeNested objects and arraysFlat table, optional header row
ceilingWhole document is usually parsed into memoryNo formal limit; row count bounded by memory

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.


Posted

in

by

Tags: