In Connect I can display the list of all my Activities. Date, Distance, Place, etc... I want to download this to Excel. There is a menu option 'Export CSV". BUT it just doesn't work. It brings up a new browser window with all the data separated by " ".But that isn't a CSV file! I try Copy and Paste into Excel, the date isn't separated into the boxes... SO - how can I get a real CSV file?
When I hit export file it opens a new browser window full of the data. Copy All the Data and paste into Excel . The problem is that numbers over 999 such as Elevation are in 1,234 format. You need to eliminate the commas. So reformat all numbers with a comma included. Do Replace "1, with "1 (All) ditto for 2 and 3. This should clean up all the elevation numbers. Unless you have climbed over 4,000m in which case carry on! Save as csv file. Open new Excel file. Import the csv file. Deselect all delimiters. Select delimiter Comma, and text delimiter None. Import.
