Import Tools
Import existing schedules instead of entering data manually. CheerKeeper supports Excel, CSV, and PDF files.
Supported Formats
| Format | Extension | Best For |
|---|---|---|
| Excel | .xlsx, .xls | Most schedules |
| CSV | .csv | Simple data |
.pdf | AI Extraction |
Excel/CSV Import
Step 1: Prepare Your File
Your spreadsheet should have columns for:
- Team Name
- Organization/Program
- Division
- Level
- Performance Time
- Room/Hall (optional)
Step 2: Upload
- Go to your event's Schedule page
- Click Import → Upload File
- Select your Excel or CSV file
- CheerKeeper auto-detects columns
Step 3: Map Columns
If auto-detection isn't perfect:
- Match your columns to CheerKeeper fields
- Preview the data
- Confirm mapping
Step 4: Review & Import
- Review the preview
- Fix any errors shown
- Click Import
Column Mapping
CheerKeeper recognizes these column names automatically:
| Your Column | Maps To |
|---|---|
| Team, Team Name, Name | Team Name |
| Org, Organization, Program, Gym, Studio | Organization |
| Division, Div, Age | Division |
| Level, Lvl | Level |
| Time, Performance Time, Perf Time | Performance Time |
| Room, Hall, Location | Room/Hall |
| Check In, Check-In | Check-In Time |
Time Formats
CheerKeeper accepts various time formats:
8:00 AM/8:00 am08:00(24-hour)8:00(assumes AM if ambiguous)8:00:00(with seconds)
Handling Errors
Missing Required Fields
If team name or time is missing, the row is skipped. You'll see an error count after import.
Duplicate Teams
Same team at same time? CheerKeeper warns you and lets you decide how to handle.
Invalid Times
Times outside your event dates are flagged for review.
Tips for Clean Imports
- Remove headers - Keep only one header row
- No merged cells - Unmerge before importing
- Consistent formatting - Use same time format throughout
- Clean data - Remove extra spaces, fix typos
- Test with small file - Try a few rows first
Related Docs
- AI PDF Extraction - Import from PDF files
- Schedule Management - Editing after import