The Export feature in the Health app currently exports all data as a large XML blob, which is not easy to load up into a spreadsheet. (for reference, I wrote a script to extract heart rate data from the XML and get it into a CSV: https://github.com/minimaxir/get-heart-rate-csv)
The workaround is to use a 3rd party app, which complicates privacy.