Active Event:
Step 1 — Download Template
Fill in the raw template (URLs, km, HH:MM:SS) — the system will auto-convert on upload
?? Template Columns & ?? Auto-conversion Reference
? Show
Step 2 — Upload & Preview
Drag the filled template here — duplicates auto-detected before import
Click to select CSV or drag & drop here
Supports template format (raw) or standard DB format
Distance Unit in CSV:
Importing...
0%
Generate SQL Import File
Upload your raw file ? get a SQL file ready to paste directly in Supabase SQL Editor
Step 1 — Download Template
Same raw format: Athlete URL, Activity URL, Distance (km), Duration (H:MM:SS). Fill it with your data.
Step 2 — Upload ? Get SQL
Drop your filled template here. System converts and generates a complete .sql file ready for Supabase.
No database connection needed — pure offline conversion
Click to select your raw CSV file
Upload the filled template ? SQL file will be generated
? SQL File Ready
SQL file generated with X activities. Download and paste into Supabase SQL Editor.
?? How to import in Supabase:
- Go to Supabase ? SQL Editor
- Click New query
- Open the downloaded .sql file and copy all contents
- Paste into SQL Editor ? Click Run
- Verify with:
SELECT COUNT(*) FROM activities;
What the SQL File Contains
-- Generated by Team UCC Data Upload
-- Paste in Supabase SQL Editor ? Run
INSERT INTO activities (
strava_activity_id, strava_athlete_id, activity_name, sport_type,
activity_date, distance_meters, moving_time_seconds,
avg_speed, steps, elevation_gain, is_flagged, is_deleted
)
VALUES
(98765432, 12345678, 'Morning Walk', 'Walk',
'2026-06-14T06:30:00', 5230, 2730, 1.915, 7500, 45, false, false),
(...)
ON CONFLICT (strava_activity_id) DO NOTHING;
-- ON CONFLICT DO NOTHING = auto-skip duplicates
-- Paste in Supabase SQL Editor ? Run
INSERT INTO activities (
strava_activity_id, strava_athlete_id, activity_name, sport_type,
activity_date, distance_meters, moving_time_seconds,
avg_speed, steps, elevation_gain, is_flagged, is_deleted
)
VALUES
(98765432, 12345678, 'Morning Walk', 'Walk',
'2026-06-14T06:30:00', 5230, 2730, 1.915, 7500, 45, false, false),
(...)
ON CONFLICT (strava_activity_id) DO NOTHING;
-- ON CONFLICT DO NOTHING = auto-skip duplicates
Distance Override
Apply bulk distance overrides to activities and backup the original values
Click to select Distance CSV or drag & drop here
Format: activity_id, new_distance_km
Flag / Status Override
Moderate activity eligibility, apply standard flag reasons, or unflag activities
Click to select Flag Status CSV or drag & drop here
Format: activity_id, action (flag/clear), reason