Hello all - hoping for som ehelp here. I have just completed my first ever Garmin range session and shared the .csv data to excel. After having nomralised the data from comma-seperated into columns I can now see very odd data results eg for club head speed and ball speeds? How do I convert the data to usable data stats? Example: (Danish language) [km/t] Club head speed [deg] Attack angle [deg] Club path [deg] Club face [deg] [km/t] Ball speed Smach factor [deg] attack angle 06/19/23 11:10:02 AM Carsten [edited] 7j Taylormade M2 Tour 7-jern 1.338.134.490.966.790 -15.018.465.518.951.400 -0.5069372653961182 0.678464949131012 11.854.022.145.271.300 18.459.044.494.628.900 13.794.610.795.281.300 15.353.713.035.583.400 I know that I am not striking my ball with a club head speed of billions og km/t :-) Nor is my smash factor above 13 billion (I wish), nor is my : Dist af carry [m] 1.413.203.125 Sooo... how do I get usable data out of these?? Best Carsten Edit made to remove full name for the privacy and maintaining public anonymity of forums use per terms of use.

Garmin R10 csv data all weird?

CDI2025 over 2 years ago

Hello all
- hoping for som ehelp here. I have just completed my first ever Garmin range session and shared the .csv data to excel. After having nomralised the data from comma-seperated into columns I can now see very odd data results eg for club head speed and ball speeds? How do I convert the data to usable data stats? Example: (Danish language)

				[km/t] Club head speed	[deg] Attack angle	[deg] Club path	[deg] Club face	[deg]	[km/t] Ball speed	Smach factor	[deg] attack angle
06/19/23 11:10:02 AM	Carsten [edited]	7j Taylormade M2 Tour	7-jern	1.338.134.490.966.790	-15.018.465.518.951.400	-0.5069372653961182	0.678464949131012	11.854.022.145.271.300	18.459.044.494.628.900	13.794.610.795.281.300	15.353.713.035.583.400

I know that I am not striking my ball with a club head speed of billions og km/t :-) Nor is my smash factor above 13 billion (I wish), nor is my :

Dist af carry

[m]

1.413.203.125

Sooo... how do I get usable data out of these??
Best Carsten

Edit made to remove full name for the privacy and maintaining public anonymity of forums use per terms of use.

Top Replies

odd tore over 2 years ago in reply to Pierre1969 +1

This program is not for import of data, but analyse them.

Really useful actually.

All Replies

0 Pierre1969 over 2 years ago

Hi Carsten (PS: I just visited Denmark and loved the courses!) How are you importing the csv into Excel?

Below is the best method to avoid any transformations in data.

For me the result is a file that "only" is misalgined on the decimal separator, which makes sense, as my regional settings on my laptop are USA.

(and a spectacular R10 clubspeed misread on the last line :-))

If you just attempt to leave it to let Excel decide on how to convert and open the CSV by double clicking on it, you could end up with numbers that are harder to convert - even though in my case (Excel 365 Enterprise edition) it's still not far off:

0 odd tore over 2 years ago in reply to Pierre1969

Tip for both:

If You have a windows pc do a Google search for Marc Overmars, golf shot analysis.

If You ask me a must have for all r10 users wanting to improve their game.

And for reasons I really don't understand I can't link to the program here.

0 Pierre1969 over 2 years ago in reply to odd tore

Thank God that's really Mark Overmars, not the ex-Ajax football player Marc. He wouldn't be able to write a (VB?) code to convert the csv for us. Anyhow, I am fine with my own imports

0 Former Member over 2 years ago in reply to Pierre1969

VB code, or any other code, shouldn't be necessary. It's not as if CSV is particularly challenging. If Garmin isn't creating/exporting CSV in a format such that it can just be read in to Excel, LibreOffice Calc, or any other capable spreadsheet program in such a manner that one ends up with usable data, then they're doing it wrong.

0 Garmin-Cody over 2 years ago in reply to Former Member

The Garmin Golf app allows export of the session data which translates into basic text formatted .CSV where the cells are formatted to display the session data by Date, Player, Club Name, Club Type, Club Speed, and the rest of the metrics provided in the app during the session.

Depending on the source you save the .CSV file to from the Garmin Golf app > To smartphone ...the .CSV could be altered depending on the app used to store file.

0 odd tore over 2 years ago in reply to Pierre1969

This program is not for import of data, but analyse them.

Really useful actually.

0 Garmin-Cody over 2 years ago in reply to odd tore

I understand part of the conversation is regarding virtual basic, ..etc. I was simply elaborating on the .CSV file exportable. Anything past the .CSV being sent from the app falls to the user to figure out what/where/how they would like to use the info from the file.

0 odd tore over 2 years ago in reply to Garmin-Cody

So why is it not allowed to link to a program that use the data?

This is what I don't understand.

Garmin golf app is not very useful for analysing data, I think most can agree on that. Golf Shot Analysis program is.