@tiffany Thanks, there does seem to be a difference in that export to CSV functionality. I'll submit a bug report for that now.
In terms of best practices, there are a few other threads (1, 2, as a couple of examples) in the Forum that have some discussion on the topic. Most users are using a third party service, though I'd imagine that you could also write a workflow to do this as well.