📋 File Upload Templates

Need help formatting your files?
This page shows you exactly how your roster and results files should be structured.

Roster File Format (.csv)

Visual Example:
Roster Example Your roster should look like the image you uploaded!
Structure Requirements:
Cell A1 Cell B1 Cell C1 Cell D1 Cell E1 Cell F1 ...
Team Name
(e.g., "Gold Team")		 Email
(optional)		 Phone
(optional)		 Event 1 Event 2 Event 3 Event 4...
Student 1 email@example.com 123-456-7890 Chemistry Lab Forensics
Student 2 student2@example.com 123-456-7891 Astronomy Rocks and Minerals Water Quality
Student 3 student3@example.com 123-456-7892 Codebusters Dynamic Planet Experimental Design Designer Genes
Key Points:
  • Cell A1: MUST contain your team name (e.g., "Gold Team", "Varsity", "JV Team")
  • Column A: Participant names (starting from A2)
  • Columns B & C: Optional contact info (can be empty)
  • Column D onwards: Event names for each participant
  • Empty cells: If a student isn't doing an event, leave it blank
  • File format: Save as CSV (Comma Separated Values)
CSV Format Example:
Gold Team,,,
Person1,person1@gmail.com,123-456-7891,Chemistry Lab,Dynamic Planet,Designer Genes
Person2,person2@gmail.com,123-456-7891,Forensics,Codebusters,Experimental Design,Designer Genes
Person3,person3@gmail.com,123-456-7891,Chemistry Lab,Water Quality,Material Science

Results File Format (.csv)

Structure Requirements:
Number School Team Chemistry Lab Forensics Astronomy ...
1 Langley HS A 3 1 5 ...
2 Langley HS B 8 4 2 ...
3 Other School A 2 7 1 ...
Key Points:
  • School column: Must contain the school name
  • Team column: Must contain the team designation (A, B, C, etc.)
  • Event columns: Each event is a separate column
  • Values: Numeric placements (1, 2, 3, etc.)
  • Compatible with: Duosmium export format
CSV Format Example:
Number,School,Team,Chemistry Lab,Forensics,Astronomy,Rocks and Minerals
1,Langley HS,A,3,1,5,2
2,Langley HS,B,8,4,2,6
3,Example High School,A,2,7,1,3
Getting Results from Duosmium:
  1. Go to your competition results on Duosmium.org
  2. Look for the "Export" or "Download CSV" button
  3. Download the CSV file
  4. Upload it to SciOly Analyzer!

Download Template Files

Roster Template

CSV template for team rosters

Results Template

CSV template for competition results

Tips:
  • Open templates in Excel, Google Sheets, or any spreadsheet program
  • Fill in your data following the examples
  • Save as CSV format when done
  • Upload to SciOly Analyzer!
Still Need Help?

Check out these resources:

  • About Page - Detailed documentation
  • Upload Page - Try uploading with examples
  • Contact your coach or team administrator for sample files