User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

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

On a site we are building, users have the ability to sort and page data. There is also an export function which returns data from all pages.

Should the data be sorted in the same way that it is on screen or in its original, unsorted order? Why?

share|improve this question

I'd say it depends on the destination of the export.

If it can do sorting (or indeed any form of processing) then it probably doesn't matter whether the data is exported in it's sorted form or not. In this case the data is likely to be sorted (processed) in the target application so exporting the data sorted might be counter-productive. As this is the usual case then don't export the sorted data.

If the destination can't do sorting then I'd recommend keeping the sort order specified by the user.

The only thing I would add is that if the data is filtered (i.e. the user has selected a subset of the data) then only the selected data should be exported.

share|improve this answer

The most common way to export tabular data is in CSV, if that is the case then no need to add sorting as Excel and other programs will handle that just fine for the user.

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.