how do i insert a huge amount of data rows from a CSV to MYSQL?

how do i insert a huge amount of data rows from a CSV to MYSQL?

I have an Excel document (15KB) extracted as .CSV from a monitoring
platform that uses 1 column ip address but contains 1048576 Rows.
how do i insert all this data on my MYSQL database?
also, i have 10 of these excel documents each document maximizes the excel
total rows. so i have a total of 10485760 rows to use.
does MYSQL the appropriate database to use?
i needed to check these data from time to time, but im not sure where to
store them and look/search for a specific row easily when i needed to.
p.s: i dont work for the NSA