How To Convert Csv To Json In Node Js

Converting CSV to JSON in Node.js is a common task for many developers working with data. Fortunately, Node.js provides us with powerful tools and libraries to make this process straightforward and efficient. In this article, we will guide you through the steps to convert CSV data to JSON format using Node.js.

Firstly, we need to install the 'csvtojson' package, which is a popular Node.js module that simplifies the conversion process. You can install it via npm using the following command:

npm install csvtojson

Once the package is installed, you can require it in your Node.js script by adding the following line at the beginning of your file:

const csvConverter = require('csvtojson');

Next, you need to specify the path to your input CSV file and the path where you want to save the output JSON file. You can achieve this by defining two variables in your script:

const csvFilePath = 'input.csv';
const jsonFilePath = 'output.json';

After setting up the file paths, you can start the conversion process by using the 'fromFile' method provided by the 'csvtojson' package. Here's how you can convert the CSV data to JSON and write it to a new file:

csvConverter()
  .fromFile(csvFilePath)
  .then((jsonObj) => {
    const jsonString = JSON.stringify(jsonObj, null, 2);
    
    fs.writeFile(jsonFilePath, jsonString, (err) => {
      if (err) {
        console.error('Error writing JSON file:', err);
        return;
      }
      console.log('Conversion successful! JSON file saved at', jsonFilePath);
    });
  })
  .catch((err) => {
    console.error('Error converting CSV to JSON:', err);
  });

In the above code snippet, we read the CSV file using the 'fromFile' method, which returns a JSON object representing the CSV data. We then convert this object into a JSON-formatted string with proper indentation using 'JSON.stringify'.

Finally, we write this JSON string to a new file specified by 'jsonFilePath' using the 'fs.writeFile' method. In case of any errors during the conversion or file writing process, appropriate error messages will be logged to the console.

By following these simple steps, you can easily convert CSV data to JSON format in Node.js. This process can be very useful when dealing with data manipulation and interchange between different systems. Feel free to experiment with different CSV files and tweak the conversion logic to suit your specific requirements.

We hope this article has been helpful in guiding you through the process of converting CSV to JSON in Node.js. Happy coding!