Our internal application, Frontline Absence Management has been solving the problem of data importing for over 10 years, and users know what to expect from it.
Hubspot's wizard is very clear and handholds users well through the process.
Mailchimp's wizard is clear and helps pretty well if errors are found.
Pipedrive has some nice UI elements especially around merging duplicate records.