First Steps
Prepare Your Data for AI Sublimation Software
Success with AI Sublimation Software starts with properly structured data. This guide shows you exactly how to prepare your Excel spreadsheet and CorelDRAW template for seamless import.
📋 Quick Start: Two files needed - Excel spreadsheet with player data and CorelDRAW template with proper grouping.
Data Preparation Overview
📊 Excel Data Structure
Organize your player data with the correct column format:
- Team Headers: "1) Team 1", "2) Team 2"
- Size Columns: YS, YM, YL, YXL (player names)
- Number Columns: YS#, YM#, YL#, YXL# (jersey numbers)
🎨 CorelDRAW File Structure
Set up your template with proper grouping workflow:
- Text Labels: Size grading labels (YS, YM, YL)
- Size Groups: Organize elements by size
- Master Groups: Combine all sizes together
Quick Excel Setup
🎯 Key Rule: Column names WITHOUT "#" = Player Names | Column names WITH "#" = Jersey Numbers
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 |
Quick CorelDRAW Setup
4-Step Grouping Process
1
Text Labels: Create size text objects (YS, YM, YL, YXL)
2
Size Groups: Group each size with its design elements
3
Stack Groups: Organize multiple sizes together
4
Master Group: Combine all into final print-ready group
Visual Workflow
📝 Text Labels
↓
🗂 Size Groups
↓
📍 Stack Groups
↓
🎯 Master Group
Import Your Data into AI Sublimation Software
Step 1: Start AI Sublimation Software
Open CorelDRAW → AI Sublimation Software menu → "New Project"
Step 2: Load Files
Select your .cdr template and .xlsx data file
Step 3: Map & Generate
Map text elements to Excel columns, then create output
Variable Mapping Quick Guide
🎯 Mapping Rule: Connect each text element in CorelDRAW to the correct Excel column
For Jersey Numbers:
- Text showing "89" → Map to YS#
- Text showing "76" → Map to YM#
- Text showing "95" → Map to YL#
For Player Names:
- Text showing "Player Name" → Map to YS
- Text showing "Player Name" → Map to YM
- Text showing "Player Name" → Map to YL
Next Steps
Once you've successfully completed your first project:
- Explore the Excel Integration guide for advanced data handling
- Learn about Corel Draw Integration for material optimization
- Check out Template Setup for creating better templates
- Review Troubleshooting for common issues and solutions
💡 Need Help? If you encounter any issues with your first project, don't hesitate to contact our support team at info@aisublimation.com. We're here to help you succeed!