How can i import data from excel csv into mysql

i have lots of data in my excel csv file and having special strings in many rows

i am trying to load but it is accepting few rows and displaying errors for others string type characters like

20727 row(s) affected, 17 warning(s): 1366 Incorrect string value: '\xBF CHAR...' for column 'Original_Description' at row 26 1366 Incorrect string value: '\xB0 DH78...' for column 'Original_Description' at row 1021 1366 Incorrect string value: '\xB0 B-B5...' for column 'Original_Description' at row 1946 1366 Incorrect string value: '\xBF; FLA...' for column 'Original_Description' at row 6373 1366 Incorrect string value: '\xBF; FIT...' for column 'Original_Description' at row 6398 1366 Incorrect string value: '\xB0 CH78...' for column 'Original_Description' at row 7533 1366 Incorrect string value: '\xBF\xBF; IM...' for column


i am trying this query but it is not importing showing errors as shown above

LOAD DATA LOCAL INFILE 'd:/TEST_IP.csv' INTO TABLE projects.tblprod_agr_002 CHARACTER SET utf8 FIELDS TERMINATED BY ',' ENCLOSED BY '"' lines terminated by '\n';