📋 File Upload Templates
Need help formatting your files?
This page shows you exactly how your roster and results files should be structured.
This page shows you exactly how your roster and results files should be structured.
Roster File Format (.csv)
Most spreadsheets just work now.
Add a normal header row with a "Name" column and your team's name
for the file — the analyzer detects which columns are events automatically. Export
straight from Google Sheets/Excel with no reformatting.
Recommended Structure (header row, any column order):
| Name | Email (ignored) | Phone (ignored) | Event 1 | Event 2 | Event 3 | ... |
|---|---|---|---|---|---|---|
| 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:
- Header row required: one column should be named "Name" (or "Student"/"Participant")
- Team name: taken from the file name you upload, e.g. "Gold Team.csv" → team "Gold Team"
- Event columns: any other column is treated as an event — column order doesn't matter
- Long format also works: a "Name" column plus an "Event" column, one row per student/event pair
- Empty cells: if a student isn't doing an event, leave it blank
- File format: CSV (export from Excel/Google Sheets as "Comma Separated Values")
CSV Format Example (wide):
Name,Email,Phone,Event 1,Event 2,Event 3
Person1,person1@gmail.com,123-456-7891,Chemistry Lab,Dynamic Planet,Designer Genes
Person2,person2@gmail.com,123-456-7891,Forensics,Codebusters,Experimental Design
Person3,person3@gmail.com,123-456-7891,Chemistry Lab,Water Quality,Material ScienceCSV Format Example (long, one row per event):
Name,Event
Person1,Chemistry Lab
Person1,Dynamic Planet
Person2,Forensics
Person2,Codebusters
Older files still work: the original
format (team name in cell A1, names in column A, events starting at column D) is still
supported automatically if no header row is detected.
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,3Don't want to download anything?
Go to the Upload page and use "Search Duosmium" to find your competition by name — we'll fetch the results file for you automatically.
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