Difficulty in loading data for the bank loan case study.

I have tried various methods to load the bank loan case study dataset such as loading from the data tab as text/csv file but only 50000 rows are being loaded in excel. As shown in the attached screenshot it shows that 300000+ files are loaded with 100000+ errors, but only 50000 are visible and can be worked with. What am i supposed to do? Should i proceed with the EDA of these 50000 rows or try some other methods. Please help.