"Golf Sim Sessions' Data Export

Well, I am still waiting for the download link from Garmin..
So as of now I have no data available. (Like I said: 1995-solution...)

i have gone for a download several times the last one yesterday.  They usually answer the same day as they did yesterday.  with this new app they may be innundated.

in garmin.com >click on icon to the left of the cart in the upper right

select Account

scroll down to MANAGE YOUR DATA

select EXPORT YOUR DATA

select REQUEST DATA EXPORT

wait a little and you should finally see in green 'Your request has successfully submitted'

in an hour so or maybe longer you will get an email with a zip file.  in the zip file is the file you are looking for.

Dear Sir, 

Thank you Very much, i have followed your instructions and now waiting for the zip file...

You can easily Import JSON data in ms excel. Just Google it

you will find the JSON file into the Download request from GarmiN

• Start a request at garmin
• receive an Email (you have to wait some Hours)
• Download the file(.rar or .zip)
• open the file
• browse to the folder  /DI_CONNECT/DI-GOLF/
• here you will find a JSON file with _Golf (its the biggest one)
• Import it via excel
• have fun

A problem with this approach is that the main session information file does not contain information about the clubs. It only has an id for each clubs. You need to combine the data with two other JSON files to get the club names and types. If you install my R10Analytics program (www.r10analytics.com) you can import the data there. You can then either inspect the data in the program or export it as a .CSV file that combines shots and club information. This can then be inspected in Excel. (Program is free; only for Windows)

on the opening screen of Power BI click 'Get Data'.  this will take you to a screen where you can select JSON

select the gamin file GolF-SIM_SESSION.JSON.  a large table opens up with all sessions, shots and parameters. one row per shot with 38 columns.

you are still in Power BI.  in the upper left corner of the table is a little icon (like a little spreadsheet).  Click it and select 

Copy Entire Table.  paste it in an excel sheet.  

Lookt at Mark Overmars solution.  It is more elegant.

I saw your software and thought how cool, but I didn’t manage to install python etc. 

after that I saw the excel import of json and that’s pretty easy to get the data into excel to analyze 

Sound similar helpful to get the data into Excel