CSV and JSON are both widely used formats for storing and exchanging data. They are very different in structure, but you can convert CSV to JSON with Easy Data Transform:
Example CSV input:
CustomerID,CompanyName,ContactName
ALFKI,Alfreds Futterkiste,Maria Anders
ANATR,Ana Trujillo Emparedados y helados,Ana Trujillo
ANTON,Antonio Moreno Taquería,Antonio Moreno
Example JSON output:
[
{
"CustomerID": "ALFKI",
"CompanyName": "Alfreds Futterkiste",
"ContactName": "Maria Anders"
},
{
"CustomerID": "ANATR",
"CompanyName": "Ana Trujillo Emparedados y helados",
"ContactName": "Ana Trujillo"
},
{
"CustomerID": "ANTON",
"CompanyName": "Antonio Moreno Taquería",
"ContactName": "Antonio Moreno"
}
]
To output values as nested JSON see the JSON documentation.
If you have a large number of files to convert you can do it using the batch processing feature.
As well as changing file format, Easy Data Transform also allows you to combine 67 transforms (such as join, filter and dedupe) to quickly and easily create complex data transformations.
v2.1.0 for Windows 11 / 10 / 8 / 7 (61 MB)
Zip file version
v2.1.0 for Mac 15.x to 10.13 (82 MB)
No commitments.
You can uninstall any time.
You don't even have to give us your email address.
Questions or problems?