Sometimes, we want to parse XLSX with Node and create JSON with JavaScript.

In this article, we’ll look at how to parse XLSX with Node and create JSON with JavaScript.

How to parse XLSX with Node and create JSON with JavaScript?

To parse XLSX with Node and create JSON with JavaScript, we use the xlsx package.

To install it, we run

npm i xlsx

Then we use it by writing

const XLSX = require("xlsx");
const workbook = XLSX.readFile("Master.xlsx");
const sheetNameList = workbook.SheetNames;
console.log(XLSX.utils.sheet_to_json(workbook.Sheets[sheetnamelist[0]]));

We call readFile with the path of the file to read.

We get an array of sheet names with workbook.SheetNames.

And we parse the first sheet to JSON with XLSX.utils.sheet_to_json(workbook.Sheets[sheetnamelist[0]]).

Conclusion

To parse XLSX with Node and create JSON with JavaScript, we use the xlsx package.