Wednesday, March 8, 2017

CONVERT CSV TO JSON

                                    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.
Conducting

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






No comments:

Post a Comment