I am collecting data on two different iPads. If I backup both iPads to iCloud, can I export data from the two iPads as a single file or must I always locally export each iPad’s data separately?

You must export the files separately.