This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export Sleep Data to Excel

I want to analyze my sleep patterns and would like to do it using Excel. Currently I can only seem to export the date and how many hours I have slept: not much usage.

I can see hours, levels and movement on the app on my phone. How do I export all of the data?

Thanks.

Top Replies

4728489 over 1 year ago +6

For anyone struggling to find any sleep data in September 2023, it looks like the "sleep" section under the Garmin Connect Web reports is currently MIA in the navigation menu, but I was still able to access…
Karel over 4 years ago +2

I guess I found the way to what you (as well as me) are looking for:

1) Go to https://www.garmin.com/en-US/account/datamanagement/exportdata/
2) Click on Request data export
3) You will obtain an e-mail with…
5754196 over 1 year ago +2

You can do this:
https://connect.garmin.com/modern/report/26/wellness/last_year

Then hit export CSV!

All Replies

0 Karel over 4 years ago in reply to trux

Thanks for mentioning this here as well.

I tried this method and there are two main differences to what I recommend:

1) The file you mention contains data for only one day. If you want to get a longer time series of your sleep patterns you would need to download files for all days one by one or run a script/scraper that would do that for you. On the other hand, the Data Export covers all your history with Garmin day by day.
2) As far as I have tried, the file you mention contains raw data on your movement activity during the night. I (and I guess davidboomstein as well) was actually looking for the interpreted data, i.e. for the times in various sleep phases as estimated by Garmin. That is what you can find in the file mentioned in my answer above.

As to the waiting, the Data Export request took actually a few minutes for me.

Nonetheless, enjoy your data any way you get them.

0 trux over 4 years ago in reply to Karel

Yes, it is always good having more options. I just posted this one, so that anyone can choose whatever fits better their needs.

Karel said:
I (and I guess davidboomstein as well) was actually looking for the interpreted data

The JSON data I mention contain actually both - the interpreted data is in the substructure sleepLevels, while the detailed data containing the movement data is in the branch sleepMovement. HR data is not included in this structure - but the JSON URL for HR can be extrated from the HR page of Garmin Connect Web in the same way as I did here on the Sleep page.

The advantage of the URL method is, that you can fully automate the import - you can write your own script parsing the data live, and showing you the results directly in the way you wish, or saving them, on a daily basis, to your local database for further processing.

0 Adrián over 4 years ago in reply to trux

Do you know if you can do this for a range of dates?

0 6162546 over 2 years ago in reply to Karel

Looks like they don't give this anymore. I looked at that file sleepData.json and it's only summary data for the night.

0 6162546 over 2 years ago in reply to 6162546

I want the minute-by-minute sleep spO2 (or even raw sensor data) that I collected and see in Connect.

0 6162546 over 2 years ago in reply to trux

Does this still work? I tried this and some variants and no luck.

0 BunBun! over 2 years ago in reply to 6162546

It works, just open it through the Developer Tools (F12).

Short script in the Console or edit request in the Network - there you also can find a service you need, just check Responses for JSON files on a page where you see needed data.

This thread has some info: https://forums.garmin.com/apps-software/mobile-apps-web/f/garmin-connect-web/272759/export-data-from-connect-health-statistics---it-looks-as-if-i-will-have-to-write-it-from-the-screen-to-ms-excel-manually--

0 6162546 over 2 years ago in reply to BunBun!

Thank you BunBun!. Once I played around with my browser's Developer Tools (using the F12 keyboard command) and your comments, I think I found a JSON file in Response that is what I am looking for. Need to play around with this more to make it more streamlined.

0 5754196 over 1 year ago

You can do this:
https://connect.garmin.com/modern/report/26/wellness/last_year

Then hit export CSV!

0 6162546 over 1 year ago in reply to 5754196

Per my message from 9 mos ago

“I want the minute-by-minute sleep spO2 (or even raw sensor data) that I collected and see in Connect. “

I’ll check again but Connect’s download button, report, etc. did not provide this. Only low resolution daily summaries and such.