Issues with CSV Data Import: Incorrect Cell Mappings Identified

I have had several problems importing data from a CSV over the last week. Most of the data imports correctly, but sometimes cells will be messed up. In the picture below you can see that there are websites and email addresses where there should be city and state information. Most cells import properly, but with over 12k rows, I cannot manually comb through all of the data to make sure it imports properly. I have verified the original CSV data source and everything is correct there