0

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?

Slava Rozhnev
  • 9,510
  • 6
  • 23
  • 39
Sohan Haspula
  • 21
  • 7
  • 1
    Does this answer your question? [Import Data From Excel To MySql With Node JS](https://stackoverflow.com/questions/51257265/import-data-from-excel-to-mysql-with-node-js) – Fourier Dec 20 '19 at 14:40

1 Answers1

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/

Tanner
  • 720
  • 1
  • 8
  • 17