Import data from excel to database using Navicat : Q2 Customer Support

Import data from excel to database using Navicat Print

Modified on: Fri, 1 Oct, 2021 at 4:47 PM

Click on Import Wizard from destination schema

Choose XLS format

Choose XLS file and select sheet to be uploaded

Change date format according to your date format in excel

Above format chosen because the format in excel is 2021-01-27 (YMD) and using – as separator

Make sure all tables are match

Verify if the fields are mapped correctly

Choose required option below

Choose Start, and verify the result

Did you find it helpful? Yes No