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 lap times to CSV

Has there been an update of the lap time export function? Up to last week, it worked satisfactorily, with a lay-out to open it correctly in Excel with European decimal & thousands separators.

Now, when opened in Excel several lines are missing, and when opened with notepad, the lay-out shows the data between " and a lot of spaces in the values:

before:

after:

Why to change a winning team... ?

0 trux over 5 years ago

Which version of Excel do you use? You may consider trying OpenOffice / LibreOffice - they are much more flexible as for CSV import

Jannie said:
Why to change a winning team... ?

I guess because Excel often misinterpreted time formats when the time values were not quoted. However, I think that the extra whitespace and line breaks currently included in the values are there by mistake, and I'd tell it will get fixed soon.

0 Jannie over 5 years ago in reply to trux

Thanks for your quick reply!

I'm an old guy, so I still use Excel 2007 (very pleased with it...), but on my new HP notebook, the problem is identical. Sorry for my computer ignorance, but I'm not familiar with OpenOffice. Can you download it, is it for free, and can you export (eventually with VB for Excel) to Excel?

0 trux over 5 years ago in reply to Jannie

Yes, those are free Open Source applications. But wait a moment, I'll test whether it really works. I'll report here later. Another possbility is removing the extra whitespace and line-breaks by hand or with search & replace in Notepad or similar text editor.

0 trux over 5 years ago in reply to trux

Yes, so it works fine with Open Office. When importing, you can select the delimiter, so if it is not preselected, you need to chose the comma. The only small cosmetic problem is the extra line-break from the data that is included in the first field (lap number), so the rows of the table are double in height. That can be easily fixed by replacing the extra line-break with search & replace in the Open Office Calc application.

0 Jannie over 5 years ago in reply to trux

Thanks a lot!

I've downloaded OpenOffice. I will install it and look into it later (no time right now...). I'll give feedback on the proceedings :-)

0 trux over 5 years ago in reply to Jannie

BTW, if you prefer working with Excel, you can export it from OpenOffice Calc in Excel format, and continue then in Excel. However, the basic work with both applications is very similar.

0 Former Member over 5 years ago in reply to trux

trux,

It got nothing to do with Excel version or Excel at all. Garmin changed the format of the the export. I open the csv file in Notepad++ and already there I see the the difference and as you can see on Jannies uploaded screenshots (from notepad) there is a difference.

0 trux over 5 years ago in reply to Former Member

Yes, of course, I saw the difference since the beginning too. But depending on the Excel version, you have more or less possibilites to adjust the import of the CSV file. However, with the above recommended OpenOffice Calc it is even simpler.

0 Former Member over 5 years ago in reply to trux

No matter if you use Excel or OpenOffice, you can't adjust away all the empty spaces after line 1.

0 Former Member over 5 years ago in reply to trux

And furthermore I use Macros and VBA to create graphs from the table and it doesn't work anymore. And to my knowledge OfficeOpen doesn't support that.