Node.js Tutorial to Convert Microsoft Excel (XLSX) File to JSON File Using xlsx Library in Terminal

geekygautam1997 April 9, 2025No Comments

npm i xlsx

index.js

const xlsx = require('xlsx');
const fs = require('fs');

const workbook = xlsx.readFile('output.xlsx');
const sheetName = workbook.SheetNames[0];
const data = xlsx.utils.sheet_to_json(workbook.Sheets[sheetName]);

fs.writeFileSync('output.json', JSON.stringify(data, null, 2));
console.log('Excel to JSON conversion complete!');

const xlsx = require('xlsx');

const fs = require('fs');

const workbook = xlsx.readFile('output.xlsx');

const sheetName = workbook.SheetNames[0];

const data = xlsx.utils.sheet_to_json(workbook.Sheets[sheetName]);

fs.writeFileSync('output.json', JSON.stringify(data, null, 2));

console.log('Excel to JSON conversion complete!');

geekygautam1997

View All Posts

Comments

No comments yet. Why don’t you start the discussion?

Node.js Tutorial to Convert Microsoft Excel (XLSX) File to JSON File Using xlsx Library in Terminal

Comments

Leave a Reply Cancel reply

Archives