User Experience Stack Exchange is a question and answer site for user experience researchers and experts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

  1. Are there any articles or papers written on the subject that provide research-backed guidance on this topic?

  2. 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"?

share|improve this question
I think "uploading and verifying some data" is a bit to broad to be properly discussed here. What is the actual problem here? What is not user-friendly about what? – Koen Lageveen Jun 20 '13 at 15:13

Most of the products follow Windows based guidelines for such general upload and import. But for verification, yes I agree there are not such research based guideline. I tried to address this in my project Informatica Cloud, you can register for free and try to upload flat file in source. Also you can refer for some examples.

share|improve this answer

I'd say it is not very hard programming task for implementation. First, you should check every line for error. Checking for errors is easy performed with regular expressions. Records which have no errors are recorded to database.

Lines which have errors could be shown to user for error correction. Fields which contains errors are highlighted and editable. So a user could correct them. Also user could perform some other actions on each row.

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.