I was trying to import a CSV file of about 0.65 Million rows in MySQL via Table import wizard but could not as it didn’t complete. Is there any alternative to this? And if not which application I can use to manipulate data of the order of a million rows?

I’m in the middle of my career path as a data scientist and I’m learning SQL, currently working in MySQL. I downloaded this dataset (https://data.insideairbnb.com/italy/lazio/rome/2024-03-22/data/listings.csv.gz) for a cleaning and analysis project. I did the first cleaning in excel, deleting all the columns that I didn’t need, and when I import in MySQL it’s only returning 865 rows instead of more than 30k!!