how to import excel file to MySQL using node.js?

Question

I'm trying to upload excel sheet data to MySQL for that Can anyone suggest to me on how to import excel file import to MySQL DB / give an example/ link on I'm using express and Node.js?

Does this answer your question? Import Data From Excel To MySql With Node JS — Fourier
– Fourier, Commented Dec 20, 2019 at 14:40

Tanner · Accepted Answer · 2019-12-20 14:02:42Z

0

You'd want to convert the excel data to a csv

Convert XLS to CSV on the server in Node

Then you can import that csv data file into mysql.

http://www.mysqltutorial.org/import-csv-file-mysql-table/

answered Dec 20, 2019 at 14:02

Tanner

8681 gold badge10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sohan Haspula Over a year ago

I wanted to import using UI. Your suggestion is without UI I'm using ejs template for import.

Collectives™ on Stack Overflow

how to import excel file to MySQL using node.js?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related