Excel Integration

Overview

AI Sublimation Software's Excel integration allows you to seamlessly import player data, team information, and personalization details directly from Excel spreadsheets. This feature eliminates manual data entry and ensures accuracy across your entire production workflow.

Required Data Structure

Your Excel file should follow this specific format for team sports data:

Excel File Format Requirements

Team Headers: Use "Team 1", "Team 2", etc. to separate different teams
Size Categories: Each team section should have size columns (YS, YS#, YM, YM#, YL, YL#, YXL, YXL#)
Player Names: Enter in size columns WITHOUT the "#" symbol
Player Numbers: Enter in size columns WITH the "#" symbol

Column Structure Explanation

Column Type	Purpose	Example
YS (Youth Small)	Player names for Youth Small size	Townsend, Coe, Metcalfe
YS# (Youth Small Numbers)	Jersey numbers for Youth Small players	00, 35, 25
YM (Youth Medium)	Player names for Youth Medium size	Miranda, LENDYAK, Sloan
YM# (Youth Medium Numbers)	Jersey numbers for Youth Medium players	76, 54, 62
YL, YXL, etc.	Continue pattern for other sizes	Youth Large, Youth Extra Large

Sample Excel Structure

1) Team 1
YS      | YS# | YM      | YM# | YL     | YL# | YXL   | YXL#
Townsend| 00  | Miranda | 76  | Hull   | 95  | Banks | 35
Coe     | 35  | LENDYAK | 54  | Ellis  | 68  | Patterson | 65
Metcalfe| 25  | Sloan   | 62  | WILFONG| 57  | Dee   | 58
Ward    | 24  | Rich    | 95  | Parlor | 84  | Cook  | 54

💡 Important: For multiple teams, repeat the same column structure after each team header (Team 1, Team 2, Team 3, etc.).

Import Process

Step 1: Prepare Your Excel File

Start with the team header "1) Team 1" in the first row
Add size headers in the second row: YS, YS#, YM, YM#, YL, YL#, YXL, YXL#
Fill player names in columns without "#" (YS, YM, YL, YXL)
Fill player numbers in columns with "#" (YS#, YM#, YL#, YXL#)
For additional teams, add "2) Team 2" header and repeat the same column structure
Save the file in Excel format (.xlsx)

Step 2: Select Excel File in AI Sublimation Software

When creating a new project in AI Sublimation Software
Browse and select your prepared Excel file
AI Sublimation Software will automatically read the team structure
Preview the imported data to ensure accuracy
Proceed with your project setup

💡 Pro Tip: AI Sublimation Software automatically recognizes the team header format and size column structure. Make sure to follow the exact naming convention for best results.

Data Validation

AI Sublimation Software performs automatic validation on imported data:

Team Header Recognition: Identifies team headers like "1) Team 1", "2) Team 2"
Size Column Mapping: Automatically maps size columns (YS, YM, YL, YXL) to player names
Number Column Mapping: Automatically maps number columns (YS#, YM#, YL#, YXL#) to player numbers
Data Consistency: Ensures player names and numbers align correctly within each size category

Understanding the Excel Format

Key Rules

Size Columns (without #): Contain player names only
Number Columns (with #): Contain jersey numbers only
Consistent Structure: Each team must use the same column layout
Row Alignment: Player names and numbers must be in the same row

Example Multi-Team Structure

1) Team 1
YS      | YS# | YM      | YM# | YL     | YL# | YXL   | YXL#
Townsend| 00  | Miranda | 76  | Hull   | 95  | Banks | 35
Coe     | 35  | LENDYAK | 54  | Ellis  | 68  | Patterson | 65

2) Team 2
YS      | YS# | YM      | YM# | YL     | YL# | YXL   | YXL#
Smith   | 12  | Johnson | 88  | Davis  | 22  | Wilson| 44
Brown   | 18  | Miller  | 33  | Taylor | 77  | Garcia| 99

Performance Tips

Close Excel application before importing
Use .xlsx format for best compatibility
Avoid complex formulas in source data
Remove unnecessary formatting and styling

⚠ Important: Always validate imported data before processing. AI Sublimation Software will highlight any issues that need attention before you can proceed with production.