<< Click to Display Table of Contents >> Navigation:  How do I? > Output nested JSON or XML

You can use the dot ('.') character in the column header to show nesting. For example:

Is output to JSON as:

[

 {

   "name": "Avocado Dip",

   "carb": "2",

   "cholesterol": "5",

   "fiber": "0",

   "minerals": {

     "ca": "0",

     "fe": "0"

   },

   "protein": "1",

   "sodium": "210",

   "vitamins": {

     "a": "0",

     "c": "0"

   }

 }

]

 

And to XML as:

<?xml version="1.0" encoding="UTF-8"?>

<root>

 <record>

   <name>Avocado Dip</name>

   <carb>2</carb>

   <cholesterol>5</cholesterol>

   <fiber>0</fiber>

   <protein>1</protein>

   <sodium>210</sodium>

   <minerals>

     <ca>0</ca>

     <fe>0</fe>

   </minerals>

   <vitamins>

     <a>0</a>

     <c>0</c>

   </vitamins>

 </record>

</root>

 

For more details see:

•JSON format

•XML format

 

See also:

•Video: How to convert CSV to XML

•Video: How to convert CSV to JSON