I have my run data for the last year in Excel format, which I'd like to somehow import into Sweat365.com to avoid a time-consuming manual import process. Ideas?
Forums » Sweat365 Support » Feature Ideas
Importing data into Sweat365 from an Excel run log?
(2 posts)-
Posted 6 months ago #
-
Piece of cake. Export (aka "Save As") a Comma Separated Value (CSV) file and from the Dashboard under Manage there is an Import function.
The format of the CSV file is pretty simple. What you want is a description field in row 1. It will make life a little easier if the descriptions match the names for each field used by Sweat365. For example; Date", "Distance", "Average Speed", "Average Heartrate", etc. The order of the fields doesn't matter (i.e. Date doesn't need to be column A). Below the description each column will have all of your data.
If the data is all numeric life should be simple. If you have text fields, for instance you have a text cell which contains comments on the day's run, then you have to make sure you're not mixing up stuff like commas and quotes which will confuse the import.
I HIGHLY recommend that you NOT try to import all of the data at once. Start with say one weeks worth of data. Important safety tip. Look at your .CSV file (i.e. in a command window "type mydata.csv") and be double extra sure that you don't have a bunch of extra blank lines in the file. Sweat365 will import them as empty workouts with today's date and since you have to go back and delete each one manually it can take hours to recover from this gotcha.
Posted 6 months ago #
Reply
You must log in to post.
