Examples of data formats

Table 1 Initial data

Country	Population	Estimate
China	1 341 990 000	2011
India	1 193 290 000	2011
United States	311 960 000	2011
Indonesia	237 556 363	2010

XML

<?xml version="1.0" encoding="UTF-8"?>
<data>
  <item id="1">
  <country> China </country>
  <population> 1 341 990 000 </population>
    <year> 2011 </year>
  </item>
  ...
  <item id="4">
  <country>  Indonesia </country>
  <population> 237 556 363 </population>
    <year> 2010 </year>
  </item>
</data>

You are not limited to the above xml format, check Data Mapping for instruction how any xml file can be loaded in the datagrid.

JSON

[
  { id:"1", country: "China", population: "1 341 990 000", year: "2011" },
  { id:"2", country: "India", population: "1 193 290 000", year: "2011" },
  { id:"3", country: "United States", population: "311 960 000", year: "2011" },
  { id:"4", country: "Indonesia", population: "237 556 363", year: "2010" }
]

JsArray

[
  [ "China", "1 341 990 000", "2011" ],
  [ "India", "1 193 290 000", "2011"],
  [ "United States", "311 960 000", "2011"],
  [ "Indonesia", "237 556 363", "2010"]
]

CSV

China, 1 341 990 000, 2011
India, 1 193 290 000, 2011
United States, 311 960 000, 2011
Indonesia, 237 556 363, 2010