Nodejs Upload Excel files to MySQL/PostgreSQL – (Express RestAPI Upload/Import Download/Export Multiple Excel files)

Nodejs Upload Excel files to MySQL/PostgreSQL – (Express RestAPI Upload/Import Download/Export Multiple Excel files)

In the tutorial, I will introduce how to build a Nodejs/Express RestAPIs application to upload/import and download/extract data from multiple Excel files to MySQL or PostgreSQL database by:

  • Express is used to build Nodejs RestApis
  • Multer is used to upload/download Excel files
  • Sequelize ORM is used to manipulate data with MySQL/PostgreSQL
  • Exceljs is used to save data objects to Excel file
  • Read-excel-file is used to parse Excel file to data objects
Related posts:


Continue reading “Nodejs Upload Excel files to MySQL/PostgreSQL – (Express RestAPI Upload/Import Download/Export Multiple Excel files)”

Token Based Authentication in Node.js using JWT (JSON Web Tokens) + MySQL Example

“How to implement Token Based Authentication in Node.js using JWT (JSON Web Tokens)?” is one of the most common question in the development world? So in the tutorial, I will introduce details step by step how to do it with 100% running coding example by Express RestAPIs, JWT(JSON Web Token), BCryptjs, Sequelize and MySQL/PostgreSQL database.

What will we do?


Continue reading “Token Based Authentication in Node.js using JWT (JSON Web Tokens) + MySQL Example”