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

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


You need to maintain consistency between what a user sees on the screen and what they get within the exported CSV/Excel file. You shouldn't force the user to re-preform the actions that they took on screen when filtering, sorting, showing/hiding columns, reordering columns, etc.

The user should be driving the action and telling the UI and its export what to do.

Maintain expectation.

share|improve this answer
Brian is on point here. If you're going to allow the user to sort the data, I personally feel like it's a must for that data to be exported the way the user sorted it. – Daniel Zahra Mar 21 at 15:19

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.