Convert JSON to Excel using an API

Use our API to convert your JSON data to Excel 2007+ (.xlsx)

Convert to
POST https://dataconverter.io/api/v1/convert/json-to-xlsx

After signing up and verifying your email, you will be able to create an API Token in your account settings.

Headers
  • Authorization (required) Bearer <<YOUR_API_TOKEN_HERE>>
Request Body — (multipart/form-data)
  • file (required) string <binary>
  • uploadSettings

    object
    {
      "treeNodes" : [ {
        "name" : "object",
        "fieldName" : "data_object",
        "xpathExpression" : "/object/data/array/object",
        "recordBreak" : true,
        "field" : false
      }, {
        "name" : "title",
        "fieldName" : "title",
        "xpathExpression" : "/object/data/array/object/title",
        "recordBreak" : false,
        "field" : true
      }, {
        "name" : "lang",
        "fieldName" : "lang",
        "xpathExpression" : "/object/data/array/object/lang",
        "recordBreak" : false,
        "field" : true
      }, {
        "name" : "price",
        "fieldName" : "price",
        "xpathExpression" : "/object/data/array/object/price",
        "recordBreak" : false,
        "field" : true
      } ]
    }
  • downloadSettings

    object
    {
      "sheetName" : "Sheet1",
      "firstRowIndex" : 0,
      "firstColumnIndex" : 0,
      "autofitColumns" : false,
      "autoFilterColumns" : false,
      "fieldNamesInFirstRow" : true
    }
Request Sample

curl -X POST "https://dataconverter.io/api/v1/convert/json-to-xlsx" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.json;type=application/json" \
-F "uploadSettings={\"treeNodes\":[{\"name\":\"object\",\"fieldName\":\"data_object\",\"xpathExpression\":\"/object/data/array/object\",\"recordBreak\":true,\"field\":false},{\"name\":\"title\",\"fieldName\":\"title\",\"xpathExpression\":\"/object/data/array/object/title\",\"recordBreak\":false,\"field\":true},{\"name\":\"lang\",\"fieldName\":\"lang\",\"xpathExpression\":\"/object/data/array/object/lang\",\"recordBreak\":false,\"field\":true},{\"name\":\"price\",\"fieldName\":\"price\",\"xpathExpression\":\"/object/data/array/object/price\",\"recordBreak\":false,\"field\":true}]};type=application/json" \
-F "downloadSettings={\"sheetName\":\"Sheet1\",\"firstRowIndex\":0,\"firstColumnIndex\":0,\"autofitColumns\":false,\"autoFilterColumns\":false,\"fieldNamesInFirstRow\":true};type=application/json" \
--output converted.xlsx
          
Show All APIs