Step 1: Open Excel sheet or Text file and save as Unicode format.
Step 2: If u want to upload data in other font(Hindi,Urdu,Chinese etc) then save as .utf8 format.
Step 3: create a temporary table based on your file structure;
step 4: Now Upload your file
LOAD DATA LOCAL INFILE ‘C:\\Users\\abc\\Documents\\fileName.txt’
INTO TABLE temprary_table_name
CHARACTER SET UTF8
FIELDS TERMINATED BY ‘\t’ //based on file data terminated by
LINES TERMINATED BY ‘\n’
IGNORE 1 LINES;step 5: Now from temporary table you can move data to main table as on adding filter if needed.
INSERT INTO main_table_name(column1,column2,…column n) SELECT field1,field2,….fieldn FROM temprary_table_name WHERE condition1 and condition2.