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

Issue when exporting CSV data to Excel

When I export Splits to CSV an Excel file is created.

What I typically would like to export is a run consisting of some laps where time for each lap varies between 5 and 15 minutes, and the total time can be less or more than 1 hour.

The problem I have is when I use the the "Text to Colums" function in Excel. Then lap times less than 10 minutes are presented correctly, (as mm:ss,0), but lap times above 10 minutes are presented as hh:mm.

Tables below shows what the imported values looks like in Excel and Garmin Connect. At first glance the time numbers may look the same, but as stated above most numbers are in hours and minutes, not minutes and seconds.

Are there anyone that has seen and solved this issue before?

PS I have tried changing decimal delimiter from , to . but it did't make a difference.

Runder	Tid	Samlet tid	Avstand	Gjennomsnittlig tempo
1	07:04,5	07:04,5	1,08	06:34
2	14:38	21:42	2,73	05:22
3	07:19,7	29:02:00	1,3	05:38
4	12:56	41:58:00	2,86	04:31
5	09:57,0	51:55:00	1,74	05:43
Sammendrag	51:55:00	51:55:00	9,71	05:21

Same table but from Garmin Connect:

Top Replies

All Replies

0 trux over 5 years ago

This is more a problem of Excel, than a problem of GC. The CSV file format does not allow for any formatting, and unfortunatelly Excell tries to be "smart" and decides itself what format it finds to be te best fitting for individual columns. That often leads to wrong assumptions.

An available workaround, is the using of free Open Source alternatives like Open Office Calc, or Libre Office - unlike at Excel, when using these applications, you can chose the column formatting yourself.

0 Doddo1 over 5 years ago in reply to trux

Thanks for å good description of å way to work arround the Excel issue.

0 trux over 5 years ago in reply to Doddo1

Today, I have found another workaround that allows you using the CSV file directtly with Excel. You just need to copy the activity numeric ID from the URL line, when you are on the screen of the concerned activity, and then calling the following URL in the browser:

https://connect.garmin.com/proxy/download-service/export/csv/activity/NNNNNN (where the NNNNNN is the numeric id of the activity)

In this way, unlike at the export through the menu of the activity, you will download the CSV file with laps containing non-rounded values. All lap times will be including milliseconds (thousands of a second) and hence will format correctly in Excel too.