CSV vs XML vs JSON – Best Response Knowledge Format?

Whether you ‘re building a skinny shopper (web application) or thick shopper (client-server application) at some purpose you ‘re most likely creating requests to an online server and want a decent data formatting for responses. As of these days, there square measure 3 major knowledge formats getting used to transmit knowledge from an online server to a client: CSV, XML, and JSON. so as to develop an application with a solid design, it is a sensible plan to grasp the variations between every format and know once to use them. the aim of this post is to outline every data formatting, lay out the professionals and cons for every, and see that things work best with every format.

Which is the best format : CSV vs XML vs JSON ?


CSV stands for “comma separated values”. because the name implies, this data formatting is largely a listing of components separated by commas. as an instance that your response is causing back a listing of individuals in an exceedingly specific family. The format would seem like this:

Pros – This format is that the most compact of all 3 formats. usually speaking, CSV formats square measure concerning [*] the scale of XML and JSON formats. this is the most important advantage of CSV as a result of it can facilitate scale back information measure

Cons – This format is that the least versatile of all 3 formats. this can be as a result of a home-cured computer programme is needed to convert the CSV knowledge into a native arrangement. As a result, if the info structure changes, there’s an associated overhead of getting to vary or perhaps plan your parsers. moreover, since the program making the CSV and also the program parsing the CSV reside on totally different machines (remember that we tend to square measure passing knowledge from one machine to another) then each programs should be updated at the same time to stop the receiving program to crash. Otherwise, an outage is needed to update each programs one by one to stop incompatibility problems.

Finally, CSV doesn’t very support knowledge hierarchies, a technique to resolve this downside is to use another delimiter like ; to separate every attribute:

Asha ;Female;26,Usha ;female;26,Nisha ;Female;8

The problem with making bespoken formats, however, is that you simply incur AN overhead of maintaining a good a lot of complicated computer programme.


XML stands for “extensible markup language”. XML was designed in 1996 and formally became a W3C commonplace in 1998. it had been created to higher represent knowledge formats with a hierarchical data structure.

Pros – This data formatting totally supports ranked knowledge structures and is extremely acceptable once receiving complicated knowledge as a response. it’s additionally terribly human decipherable. Most browsers have inbuilt XML readers that enable you to examine XML files. Since XML was the primary commonplace ranked data formatting, most Apis have inbuilt practicality to mechanically convert XML knowledge streams into native knowledge structures like objects.

Cons – This data formatting is concerning thrice as massive as CSV. this can be as a result of every knowledge component has AN associated open and shut parameter tag.


JSON stands for (Javascript Object Notation). it had been fictional in 2001 and have become popularized by Yahoo and Google in 2005 and 2006. it had been created as another to XML. Like XML, however, it represents ranked knowledge with the employment of commas, curling braces and brackets.

Pros – This data formatting supports ranked knowledge whereas being smaller in size than XML. As its name implies, it had been additionally created to a lot of simply break down knowledge into native Javascript objects, creating it terribly helpful for internet applications. JSON is that the better of each worlds with regard to CSV and XML. It’s straightforward and compact like CSV, however supports ranked knowledge like XML. Unlike XML, JSON formats square measure solely concerning doubly as massive as CSV formats.

Cons – This data formatting incorporates a bit less support than XML. Since JSON is comparatively newer than XML, fewer Apis exist to mechanically convert JSON to native knowledge structures. However, this can be chop-chop dynamic as a result of newer Apis and plugins square measure supporting each XML and JSON.


As a general rule of thumb, JSON is that the best knowledge exchange format to this point. It’s light-weight weight, compact, and versatile. Today, XML must not be used as a knowledge exchange format as a result of it’s higher suited to document markups.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s