csv to json api

How to convert CSV to JSON with Node.js API.

CSV (Comma-Separated Values) is one of the most commonly used formats for storing tabular data. However, when working with APIs, applications, or modern web environments, JSON (JavaScript Object Notation) is preferred due to its hierarchical and easily parsable structure.

This article guides you through converting CSV to JSON using REST API, designed for seamless data transformation in cloud-based environments.

Node.js API for CSV to JSON Conversion

The Aspose.Cells Cloud SDK for Node.js allows you to convert files like CSV to JSON quickly, accurately, and without the need for any local software installation.

Key Features

  • Convert spreadsheets and CSV files to JSON.
  • Maintain structure and data types during conversion.
  • Upload, process, and download files using cloud APIs.
  • Supports over 50 file formats.

Getting Started

  1. Install SDK via npm:
npm install asposecellscloud --save
  1. Set up credentials: Create a free account at the Aspose.Cloud Dashboard and obtain your Client ID and Client Secret. For further details, you may consider visiting quick start article.

Convert CSV to JSON in Node.js

Here’s a step-by-step guide to converting CSV to JSON programmatically using Node.js:

Step 1: Initialize the API:

const { CellsApi, PostWorkbookSaveAsRequest, SaveOptions } = require("asposecellscloud");
const cellsApi = new CellsApi("YOUR_CLIENT_ID", "YOUR_CLIENT_SECRET");

Step 2: Upload the CSV File to Cloud Storage:

const fs = require("fs");
const path = require("path");
const filePath = path.resolve("sample.csv");

await cellsApi.uploadFile("sample.csv", fs.createReadStream(filePath));

Step 3: Configure and Send the Conversion Request:

const saveOptions = {
    SaveFormat: "JSON"
};

const request = new PostWorkbookSaveAsRequest({
    name: "sample.csv",
    newfilename: "converted/output.json",
    saveOptions: saveOptions,
    isAutoFitRows: true,
    isAutoFitColumns: true
});

await cellsApi.postWorkbookSaveAs(request);
console.log("CSV successfully converted to JSON.");
csv to json

A preview of CSV to JSON conversion.

CSV to JSON Conversion with cURL

If you prefer the command-line prowess, then accomplishing the CSV to JSON conversion using cURL commands is seamless solution. This approach offers a quick and scriptable approach without the knowledge of programming language.

Step 1 – Generate Access Token:

The first step in this approach is to generate a JWT access token:

curl -v "https://api.aspose.cloud/connect/token" \
-X POST \
-d "grant_type=client_credentials&client_id=YOUR_CLIENT_ID&client_secret=YOUR_CLIENT_SECRET" \
-H "Content-Type: application/x-www-form-urlencoded" \
-H "Accept: application/json"

Step 2 – Perform the CSV to JSON Conversion:

curl -v "https://api.aspose.cloud/v3.0/cells/{sourceFile}/SaveAs?newfilename={resultantFile}&isAutoFitRows=true&isAutoFitColumns=true&checkExcelRestriction=false" \
-X POST \
-H "accept: application/json" \
-H "authorization: Bearer {accessToken}" \
-H "Content-Type: application/json" \
-d "{  \"SaveFormat\": \"JSON\",  \"ClearData\": true,  \"CreateDirectory\": true,  \"EnableHTTPCompression\": true,  \"RefreshChartCache\": true,  \"SortNames\": true,  \"ValidateMergedAreas\": true}"

Replace sourceFile with the name of input CSV file, resultantFile with the JSON file and accessToken with JWT access token generated above.

  • The sample files used in above example can be downloaded from:

Try Free Online CSV to JSON Converter

Experience the API in action without writing a line of code! Try the CSV to JSON Converter Online powered by Aspose.Cells Cloud.

csv to json converter

Free online CSV to JSON converter App.

📚 Useful Resources

Conclusion

Whether you’re processing data for a web app, exporting spreadsheets for API consumption, or modernizing your data pipelines, Aspose.Cells Cloud SDK for Node.js provides a fast and reliable solution for CSV to JSON conversion. Use the REST API for full integration or opt for cURL for quick and scriptable tasks.

Transform your CSV files into structured JSON with just a few lines of code — and make your data work smarter.

🔗 Related Articles

We highly recommend visiting the following blogs: