=Convert Excel to MySQL =
httpss://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql
#. Excel save to csv.
#. remove csv field name
#. SQL
LOAD DATA LOCAL INFILE ‘c:\music-2.csv’ INTO TABLE music FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n'(
ID, Title, URL, Favorite, ICON, Playlist, Artist, Genre, Description
)