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

new to garmin, bulk upload old activities though excel

I've just bought a forerunner to track my runs. Before, I've logged all my runs in excel (date, time, distance). The excel contains about 500 rows of data.

Is it somehow possible to get my excel date into garmin connect? I'm not looking forward to manually adding each line into garmin connect.

0 travis.vitek over 10 years ago

There isn't any easy way to do it. You could either do it manually, write a script to do it, or just skip it altogether.

I was in the same position when I got my first Garmin. Not having the old data in the same place as the new was super frustrating (yes, I'm type A). After a few months, I got over it.

Travis

0 eberends over 10 years ago

There is no easy way to do this indeed. There is another option though, you can export your activities to Excel (via the export to .csv option in the activities overview).
That allows you to combine your old and new data in the format that you fancy, independent of any device of website. I do this so now and again (mostly once a month) and it only take a couple of minutes.

0 The_Hunnymonster over 10 years ago

Or.... take a look at one of the other sites (one that's supported by tapiriik, syncmetrics or copymysports) and see if you can import your CSV there and sync it back to GarminConnect...

0 davy.vereycken over 10 years ago

The job is done... with a bit of trial and error. I've exported a manually entered activity to tcx and examined the files. Than I've created one tcx file containing all my runs by adding some headers/footers in excel. By manually uploading this tcx file, all my activities are in garmin connect now.

Example of a tcx file containing 2 activities:

<?xml version="1.0" encoding="UTF-8"?>
<TrainingCenterDatabase
xsi:schemaLocation="www.garmin.com/.../v2 www.garmin.com/.../TrainingCenterDatabasev2.xsd"
xmlns:ns5="www.garmin.com/.../v1"
xmlns:ns3="www.garmin.com/.../v2"
xmlns:ns2="www.garmin.com/.../v2"
xmlns="www.garmin.com/.../v2"
xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:ns4="www.garmin.com/.../v1">
<Activities>
<Activity Sport="Running">
<Id>2014-06-27T15:49:49.000Z</Id>
<Lap StartTime="2014-06-27T11:49:49.000Z">
<TotalTimeSeconds>4835.0</TotalTimeSeconds>
<DistanceMeters>9900.0</DistanceMeters>
<Intensity>Active</Intensity>
<TriggerMethod>Manual</TriggerMethod>
</Lap>
<Creator xsi:type="Device_t">
<Name>Garmin Connect</Name>
<UnitId>0</UnitId>
<ProductID>1</ProductID>
<Version>
<VersionMajor>14</VersionMajor>
<VersionMinor>5</VersionMinor>
<BuildMajor>2</BuildMajor>
<BuildMinor>0</BuildMinor>
</Version>
</Creator>
</Activity>
<Activity Sport="Running">
<Id>2014-06-28T15:49:49.000Z</Id>
<Lap StartTime="2014-06-28T11:49:49.000Z">
<TotalTimeSeconds>5000.0</TotalTimeSeconds>
<DistanceMeters>8000.0</DistanceMeters>
<Intensity>Active</Intensity>
<TriggerMethod>Manual</TriggerMethod>
</Lap>
<Creator xsi:type="Device_t">
<Name>Garmin Connect</Name>
<UnitId>0</UnitId>
<ProductID>1</ProductID>
<Version>
<VersionMajor>14</VersionMajor>
<VersionMinor>5</VersionMinor>
<BuildMajor>2</BuildMajor>
<BuildMinor>0</BuildMinor>
</Version>
</Creator>
</Activity>
</Activities>
<Author xsi:type="Application_t">
<Name>Garmin Connect API</Name>
<Build>
<Version>
<VersionMajor>14</VersionMajor>
<VersionMinor>5</VersionMinor>
<BuildMajor>2</BuildMajor>
<BuildMinor>2</BuildMinor>
</Version>
</Build>
<LangID>en</LangID>
<PartNumber>006-D2449-00</PartNumber>
</Author>
</TrainingCenterDatabase>

0 Former Member over 8 years ago

still valid import method?

Hi Davey. I don't understand how I can make this method work for me. Five years later, I am still trying to figure out how to get about 200 activities in one spreadsheet into my garmin connect account. I can't find a site that uploads a single file with many activities (each day's run got a line with many columns of date, time, route name and such).

Can you help me out and tell me how to use your method? THanks!