A common task in many applications is when an end user, and not necessarily a power user, has to upload and import a spreadsheet of data (.csv or .xls) from an external source so that the external records are saved in the application. Often the user has to verify and/or correct erroneous data.
I have seen applications take various approaches to this task, none of which are particularly user-friendly.
I am wondering:
Are there any articles or papers written on the subject that provide research-backed guidance on this topic?
Are there any applications (externally accessible) that you believe provide an exceptional end-user experience to what can be a troublesome task (especially when the UI is not friendly) for users who are not "power users"?