Converting CSV and Text and vice versa with a Salesforce Visualforce Page tool
What is CSV?
CSV (comma-separated values) is a simple file format that is used to store tabular data, like a spreadsheet or database with its data fields separated by a comma.
The first row in a CSV file lists the field names for the object and each subsequent row maps to a record in Salesforce. Every record consists of a series of fields that are delimited by commas and all records must be for the same object.
What is JSON?
JSON or JavaScript Object Notation is a lightweight, language-independent, data-interchange format, easy for humans to read and write and machines to parse and generate.
JSON has become a de-facto computer format readable by humans to store structured data and many APIs such as Twitter, Facebook, and Google heavily rely on it. From APIs to configuration files, JSON is used everywhere.
For Live Demo Click here
CSV and JSON
While CSV represents tabular data widely used in database import/export, and spreadsheet applications, JSON is used for APIs and configuration files. Both the data formats complement each other but have an overlap.
Though tabular data can be represented in JSON with an array of arrays it would be inconvenient and complex for any human to write in or read those square brackets and lack of newline characters. CSV is here to stay, and JSON is required by the developers for multiple technologies and import or export of data. So, developers always need to convert between one format to the other.
Thus, we created a Visualforce Page tool to convert CSV file and text into JSON and vice versa with a built-in CSV parser, which transforms a CSV data string into a JSON object.
How does it work?
There are two ways to convert CSV into JSON.
- Copy/paste your CSV to convert it into JSON under the ‘Enter Data’ box.
- Click on the ‘Convert’ button
- Your converted JSON object will be displayed in the ‘Result Data’
- Upload your CSV file to convert it to JSON.
- Click on ‘Convert & Download’ button.
- Your converted JSON object file will be downloaded.
Reach out to us if you have any issues converting your files or if you would like to add something to this tool!
India 
USA
UK
Canada