How to Convert XLSX to JSON in Node.JS

Though Excel is often the preferred spreadsheet creation program, you may run into a situation that requires creating a web-based spreadsheet program that can be accessed by multiple users. In order to simplify this process, the following API will allow you to convert any already existing Excel file to JSON instantly for insertion into your program. This function will maintain the previously dictated formatting as well, so you wont have to worry about data loss or degradation.

Image for post
Image for post

To use this API, run this command to install the SDK:

npm install cloudmersive-convert-api-client --save

You can also add this snippet to your package.json:

"dependencies": {
"cloudmersive-convert-api-client": "^2.4.8"

Then, you can call the function:

var CloudmersiveConvertApiClient = require('cloudmersive-convert-api-client');
var defaultClient = CloudmersiveConvertApiClient.ApiClient.instance;
// Configure API key authorization: Apikey
var Apikey = defaultClient.authentications['Apikey'];
Apikey.apiKey = 'YOUR API KEY';
var apiInstance = new CloudmersiveConvertApiClient.ConvertDataApi();var inputFile = Buffer.from(fs.readFileSync("C:\\temp\\inputfile").buffer); // File | Input file to perform the operation on.var callback = function(error, data, response) {
if (error) {
} else {
console.log('API called successfully. Returned data: ' + data);
apiInstance.convertDataXlsxToJson(inputFile, callback);

With this, you can easily optimize your spreadsheets for use in a web-based format that will increase overall accessibility.

You can retrieve the API Key from Cloudmersive at no cost and with no commitment. This will give you access to 800 monthly calls across our library of APIs.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store