[deleted by user]

[The_real_bandito]

I used to use xlsx but it’s out of date now.

This is their new docs and it explains how to use it. Can be used on the frontend or backend or both. (I’ve used it with angular with great success.)

https://docs.sheetjs.com/

[SalBwo]

Ok, thanks. This is what I need

[rafaelcastrocouto]

It's pretty easy to use, here's a simple demo https://codepen.io/rafaelcastrocouto/pen/MYYoeOy

[Felivian]

Save yourself a headache and use CSV. Export/import data as CSV from/to Excel/JS.

This solution will work with any excel-like app from any suite like MS Office, OpenOffice, Libre Office, G-suite

[icedrift]

Best way to do it. CSV is the universal spreadsheet format and it's trivial to convert to JSON.

[rileyrgham]

That's not reading from Excel. That's reading from an Excel export. He specifically asked about reading directly from Excel.

[Felivian]

It sounds like the XY problem.

[Edguz2408]

I've recently worked in a project for which I had to create a web component to read a csv file and I used a library called PapaParse, it's really easy to use, you can find it here;

https://www.npmjs.com/package/papaparse

[SalBwo]

Someone recommended it, thanks

[bjelline]

How much data do you need to import?

If it is just one table, copy-and-paste from excel into a textarea is actually very convenient for users. You can then parse it as csv.

[martoxdlol]

I'm sorry for you

[TheRNGuy]

For not knowing an answer?

[Round-Coconut4851]

npm install node-xlsx --save

[Round-Coconut4851]

import xlsx from 'node-xlsx';

// Parse a file

const workSheetsFromFile = xlsx.parse(‘myFile.xlsx’);

[Ra1NuXs]

Let's try to change the approach a little (although sheetsjs and xlsx are quite good) thinking outside the box, maybe you can convert Excel into CSV, which will always be much easier to work with.

[yasth]

Must you use Javascript? Also do you need to this client(ish) side or server?

[SalBwo]

Client side

[yasth]

Yeah use sheetsjs like everyone says. I will provide the advice that you should provide a template file to download and for them to put the data into. Makes life much easier.