Wednesday, March 8, 2017


                                    Use the tool on this page to convert CSV data to JSON

What can this tool do?

Choose from the following 5 JSON conversions offered by this tool:

  • CSV to JSON - array of JSON structures matching your CSV plus MongoDB mode
  • CSV to Keyed JSON - Generate JSON with the specified key field as the key value to a structure of the remaining fields, also known as an hash table or associative array. If the key field value is unique, then you have "keyvalue" : { object }, otherwise "keyvalue" : [ {object1}, {object2},... ]
  • CSV to JSON Array - An array of CSV values where the CSV values are in an array, or a structure with column names and data as an array
  • CSV to JSON Column Array - An array of CSV values where each column of values are in an array
  • Generate JSON via Template - Using our template engine, easily customize your JSON output NEW
  • Automatic detection of numeric values, logical values, and nulls.
What are your optional?

  • Choose your attribute names to be upper or lower case
  • Choose to limit the number of records processed
  • Select the fields to output and also rearrange JSON fields
  • Filter JSON output by using the query tool
  • Create nested JSON output by using / in the column headings of CSV. See Output Options NEW
  • Sort CSV data in ascending or descending order before converting to JSON
  • Convert value of NULL in CSV to be null in JSON
  • Optionally output null instead of "" for empty fields
  • Optionally do not write out field : value if field value is empty. See Output Options
  • MongoDB Mode - one object per line with no commas separating objects. NEW See Output Options.

Step 1: Select your input
Option 1 - Choose a CSV file 
Option 2 - Enter a URL 
Option 3 - Paste content into text box 

Step 2: Choose input options

Step 3: Choose out put options

Step 4: Create custom output via Template

Step 5: Generate output

Tuesday, March 7, 2017


                                   Use this tool to convert JSON into CSV

    You can also force double quotes around each field value or it will be determined for you. The output CSV header row is optional. 

    Your JSON input should contain an array of objects consistings of name/value pairs. It can also be a single object of name/value pairs or a single object with a single property with an array of name/value pairs. You can also identify the array using Javascript notation. 
     You can conduct below:

     Step 1: Select your input
                Option 1 - Choose JSON file
                Option 2 - Enter an URL
                Option 3 - paste into Text Box

      Step 2: Choose output optional
Output OptionsOutput Field Separator:                  
 If JSON variable A, name the array to convert:  
 Force Wrap values in double quotes 

Step 3: Generate output


Tuesday, February 28, 2017

Introducing Json

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write.

JSON is a text format that is completely language independent but uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others. JSON is built on two structures:
  • A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array.
  • An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence.
  • Exchanging Data

    When exchanging data between a browser and a server, the data can only be text.
    JSON is text, and we can convert any JavaScript object into JSON, and send JSON to the server.
    We can also convert any JSON received from the server into JavaScript objects.
    This way we can work with the data as JavaScript objects, with no complicated parsing and translations.
  • Sending Data

    If you have data stored in a JavaScript object, you can convert the object into JSON, and send it to a server