How can I load 10,000 rows of test.xls file into mysql db table?

How can I load 10,000 rows of test.xls file into mysql db table?

How can I load 10,000 rows of test.xls file into mysql db table?
When I use below query it shows this error.
LOAD DATA INFILE 'd:/test.xls' INTO TABLE
karmaasolutions.tbl_candidatedetail
(candidate_firstname,candidate_lastname);

My primary key is candidateid and has below properties.

The test.xls contains data like below.
I have added rows starting from candidateid 61 because upto 60 there are
already candidates in table.
please suggest the solutions.