SmartSize AI Fit Recommender’s copy-paste functionality enables efficient bulk data management, allowing you to work with size tables in external applications and import data seamlessly into your quizzes.

Copy-Paste Overview

Supported Operations

SmartSize AI Fit Recommender supports comprehensive copy-paste operations:

  • From Spreadsheets - Excel, Google Sheets, Numbers
  • To External Apps - Export size data for analysis or backup
  • Between Quizzes - Copy size tables from one quiz to another
  • Partial Data - Copy specific rows, columns, or cell ranges
  • Format Preservation - Maintains data structure and formatting

Data Format Support

The system recognizes and handles multiple data formats:

  • Tab-separated values - Standard spreadsheet copy format
  • Comma-separated values - CSV format compatibility
  • Plain text - Simple text data with various delimiters
  • Mixed formats - Flexible parsing for various input styles

Working with Spreadsheets

Preparing Data in External Applications

Excel/Google Sheets Setup

Organize your size data using this recommended column structure:

  Size Name | Min Chest | Max Chest | Min Waist | Max Waist | Min Hip | Max Hip
XS        | 32.0      | 34.0      | 26.0      | 28.0     | 34.0    | 36.0
S         | 34.0      | 36.0      | 28.0      | 30.0     | 36.0    | 38.0
M         | 36.0      | 38.0      | 30.0      | 32.0     | 38.0    | 40.0
L         | 38.0      | 40.0      | 32.0      | 34.0     | 40.0    | 42.0
XL        | 40.0      | 42.0      | 34.0      | 36.0     | 42.0    | 44.0

Column Order Flexibility

SmartSize AI Fit Recommender’s intelligent parsing handles various column orders:

Standard Order (Size, Min/Max pairs)

  Size | Min Chest | Max Chest | Min Waist | Max Waist | Min Hip | Max Hip

Grouped by Measurement (All chest, then waist, then hip)

  Size | Min Chest | Max Chest | Min Waist | Max Waist | Min Hip | Max Hip

Measurement-First Order (Measurements before size names)

  Min Chest | Max Chest | Min Waist | Max Waist | Min Hip | Max Hip | Size

Import Process

Basic Copy-Paste Workflow

  1. Select Data in Spreadsheet - Include headers if present
  2. Copy - Use Ctrl+C (Cmd+C on Mac)
  3. Navigate to SmartSize AI Fit Recommender - Open your quiz size table
  4. Click Target Cell - Usually the first size name cell
  5. Paste - Use Ctrl+V (Cmd+V on Mac)
  6. Review Results - Check for parsing accuracy

Advanced Paste Options

  • Replace Existing Data - Paste over current size table content
  • Append to Existing - Add new sizes below existing data
  • Insert at Position - Paste starting from specific row
  • Selective Columns - Paste only specific measurement types

Automatic Data Parsing

Intelligent Recognition

SmartSize AI Fit Recommender automatically recognizes common data patterns:

Size Name Detection

  • Standard Sizes - XS, S, M, L, XL, XXL, XXXL
  • Numeric Sizes - 2, 4, 6, 8, 10, 12, 14, 16, 18, 20
  • Custom Names - Any text identifier you use
  • Mixed Formats - Combination of letters, numbers, and symbols

Measurement Value Parsing

  • Decimal Numbers - 34.5, 36.25, 38.75
  • Imperial Fractions - 34 1/2, 36 1/4, 38 3/4 (auto-converts to decimal)
  • Unit Indicators - Ignores unit symbols (", cm, in, inches)
  • Range Separators - Handles various formats (-, to, ~, |)

Header Recognition

SmartSize AI Fit Recommender recognizes common header variations:

Chest Measurements:

  • Chest, Bust, Chest Circumference, Bust Circumference
  • Min Chest, Max Chest, Chest Min, Chest Max
  • Chest Range, Bust Size, Upper Body

Waist Measurements:

  • Waist, Waist Circumference, Middle, Midsection
  • Min Waist, Max Waist, Waist Min, Waist Max
  • Waist Range, Waist Size, Belly

Hip Measurements:

  • Hip, Hips, Hip Circumference, Lower Body
  • Min Hip, Max Hip, Hip Min, Hip Max
  • Hip Range, Hip Size, Seat

Data Validation During Paste

Automatic Checks

  • Measurement Logic - Ensures minimum values are less than maximum values
  • Consistency Validation - Checks for logical size progression
  • Format Validation - Verifies numeric data in measurement columns
  • Duplicate Detection - Identifies potential duplicate size names

Error Handling

When parsing issues occur:

  • Highlight Problems - Visual indicators show problematic cells
  • Error Messages - Specific feedback about parsing issues
  • Partial Import - Imports valid data, flags problematic rows
  • Manual Correction - Easy editing of flagged issues

Copy-Paste Strategies

Creating New Size Tables

From Scratch in Spreadsheet

  1. Design Complete Table - Plan all sizes and measurements
  2. Include All Measurements - Even if some columns will be disabled
  3. Verify Progression - Ensure sizes progress logically
  4. Copy Entire Table - Select all data including headers
  5. Paste into Empty Quiz - Start with blank size table

Template-Based Approach

  1. Create Master Template - Standard size ranges for your products
  2. Customize per Product - Adjust measurements for specific items
  3. Version Control - Maintain template versions for different categories
  4. Batch Creation - Use template to create multiple quizzes quickly

Modifying Existing Tables

Selective Updates

  • Single Column Updates - Copy just one measurement type from spreadsheet
  • Row Additions - Paste new sizes below existing data
  • Range Modifications - Update specific size ranges without affecting others
  • Bulk Adjustments - Apply systematic changes across all sizes

Incremental Improvements

  • Data Analysis - Export current table, analyze in spreadsheet
  • Optimization - Adjust ranges based on customer feedback or returns
  • A/B Testing - Create variations for testing different size ranges
  • Version Tracking - Keep history of size table changes

Cross-Quiz Operations

Duplicating Size Tables

  1. Export from Source Quiz - Copy entire size table
  2. Navigate to Target Quiz - Open destination quiz
  3. Clear Existing Data - Remove current size table if replacing
  4. Paste Complete Table - Import all size data
  5. Adjust if Needed - Modify for specific product differences

Partial Data Sharing

  • Common Size Ranges - Share size structures across similar products
  • Measurement Subsets - Copy only relevant measurements between quizzes
  • Size Extensions - Add larger or smaller sizes from other quizzes
  • Category Adaptations - Modify size data for different garment categories

Advanced Copy-Paste Features

Unit Conversion During Paste

SmartSize AI Fit Recommender handles unit conversions automatically:

Imperial to Metric Quiz

  • Input: Spreadsheet with inches (34.5, 36.0, 37.5)
  • Automatic Conversion: Converts to centimeters (87.6, 91.4, 95.3)
  • Quiz Setting: Respects quiz’s measurement unit preference
  • Precision Maintained: Preserves measurement accuracy through conversion

Metric to Imperial Quiz

  • Input: Spreadsheet with centimeters (87, 91, 95)
  • Automatic Conversion: Converts to inches (34.25, 35.75, 37.25)
  • Fraction Display: Shows as imperial fractions (34¼", 35¾", 37¼")
  • Consistent Formatting: Matches quiz’s imperial display preferences

Bulk Operations Support

Multiple Size Ranges

Paste data for products with extensive size ranges:

  • Extended Sizes - Handle 15+ sizes efficiently
  • Petite/Tall Variations - Manage size variations in single operation
  • International Sizes - Import size conversions from comprehensive charts
  • Custom Size Systems - Handle non-standard sizing schemes

Complex Measurement Sets

Work with detailed measurement data:

  • Professional Fit Data - Import from fitting studies or customer research
  • Grading Data - Use fashion industry grading increments
  • Technical Specifications - Import from product development spreadsheets
  • Customer Feedback Integration - Incorporate fit feedback into size adjustments

Error Prevention and Quality Control

Pre-Paste Validation

Spreadsheet Review Checklist

Before copying from external applications:

✅ Size Name Column - Unique, descriptive size identifiers
✅ Measurement Logic - Min values < Max values for each size
✅ Size Progression - Logical increase from smallest to largest
✅ Data Completeness - No empty cells in required measurements
✅ Format Consistency - Consistent decimal formatting
✅ Unit Consistency - All measurements in same unit system

Common Issues to Avoid

  • Mixed Units - Don’t mix inches and centimeters in same table
  • Text in Number Columns - Remove non-numeric characters from measurements
  • Reversed Min/Max - Ensure minimum < maximum for all measurements
  • Size Order - Arrange sizes from smallest to largest
  • Header Confusion - Use clear, recognizable column headers

Post-Paste Review

Validation Steps

After pasting data into SmartSize AI Fit Recommender:

  1. Visual Scan - Quick review of all pasted values
  2. Logic Check - Verify min/max relationships
  3. Progression Verification - Confirm size ranges increase appropriately
  4. Unit Display - Check that units match your quiz settings
  5. Completeness - Ensure all required measurements are present

Error Correction Workflow

When issues are found:

  1. Identify Problem Areas - Note specific cells or rows with issues
  2. Fix in Place - Use keyboard shortcuts for quick corrections
  3. Re-paste if Needed - Return to spreadsheet for major corrections
  4. Test Sample Recommendations - Verify corrected data works properly

Integration with Quiz Workflow

Size Table Development Process

Development Phase

  1. Research Phase - Gather measurement data from various sources
  2. Spreadsheet Development - Create and refine size ranges
  3. Import to SmartSize AI Fit Recommender - Use copy-paste for initial table creation
  4. Test and Validate - Verify recommendations work as expected
  5. Iteration - Refine based on testing, re-import as needed

Production Phase

  1. Monitor Performance - Track recommendation accuracy and customer feedback
  2. Analyze in Spreadsheet - Export data for detailed analysis
  3. Optimize Ranges - Adjust measurements based on analysis
  4. Update via Copy-Paste - Import optimized data back to SmartSize AI Fit Recommender
  5. Deploy Updates - Activate updated size tables

Team Collaboration

Multi-User Workflows

  • Shared Spreadsheets - Team collaboration on size development
  • Version Control - Track changes and maintain data history
  • Review Process - Quality control before importing to production
  • Documentation - Maintain records of size table rationale and changes

Role-Based Access

  • Data Analysts - Develop and optimize size ranges in spreadsheets
  • Product Managers - Review and approve size changes
  • Quiz Operators - Import approved data using copy-paste
  • Quality Assurance - Validate imported data and test recommendations

The copy-paste functionality bridges the gap between powerful spreadsheet analysis capabilities and SmartSize AI Fit Recommender’s sophisticated recommendation engine, enabling efficient, accurate, and scalable size table management.