You could try using this to get it into a .csv file and then import that into excel:

https://www.reddit.com/r/miband/comments/2v411b/i_created_a_desktop_app_to_extract_data_from_mi/

Thank you.

Please let me know the steps to obtain the CSV file.

Regards

Sir, Kindly follow the link

http://c.mi.com/sg/thread-567-1-1.html

Dear Atanu Kumar Pati

You may take a look at the Gadgetbridge app supporting Mi Band 1, 2 and 3 amongst other bracelets:

https://github.com/Freeyourgadget/Gadgetbridge/blob/master/README.md

The app stores data in sqlite database that you can export to csv:

https://github.com/Freeyourgadget/Gadgetbridge/wiki/Developer-Documentation#extracting-csv-data-from-the-sqlite-database

No; I didn't.

Best, Atanu

Try also the following:

Open Mi Fit apk and Go to:

profile -> settings -> about -> exercising user rights -> export

If it doesn't work try to change Locale to EU country.

The above hidden function was added because of Europeans and their GDPR law.

Bénédicte Thonon thank you for the information that with iPhone, and the use of QS Access you can have more analytical data during the day.

Well most of the owners of Mi band usualy don't own iPhone here in Europe but if someone wants to do a more detailed research work with Mi band I think he can easily find a used one or borrow an iPhone for this porpose.

Bénédicte Thonon do you know from which version of iOS and above the above process is working ?@ Bénédicte Thonon

To export your data, sign in to mifit.huami.com/t/account_mifit and select "Export data".

Source and step-by-step guide: https://medium.com/@korniichuk/export-xiaomi-data-87f7e284b379