I’ll check tomorrow; I can’t remember having only worked on it once.
===============
Edit: update
- I downloaded the activities in csv format
- Opened in Excel
- Tab 1 = Paste download
- Tab 2 = Convert (lots of formulae to workout the required values)
- Tab 3 = list of all run activities, with lookups to the converted data
- Copy the three columns in Excel and paste in Google sheets
- Run the script to upload to Intervals
I recently became friends with Claude code (AI), but haven’t tried asking for assistance with a VBA script to do this in Excel. ChatGPT was incapable do successfully providing code for me on a few projects, but Claude Code was. I’ll see if I can get automation in Excel using Claude Code.
If you want the Excel file and Google sheets (file and script), let me know.
Open the .csv file in Excel, then use the text import wizard to convert to columns.
