Home | Connectors | Excel | Excel - Prodigy Integration and Automation

Excel - Prodigy Integration and Automation

Integrate Excel Office Productivity and Prodigy Artificial intelligence (AI) apps with any of the apps from the library with just a few clicks. Create automated workflows by integrating your apps.

Common Integration Use Cases Between Excel and Prodigy

1. Excel to Prodigy: Convert spreadsheet-based labeling instructions into structured annotation tasks

Business teams often maintain labeling guidelines, class definitions, and edge-case examples in Excel because it is easy to review and update. These spreadsheets can be imported into Prodigy to create consistent annotation tasks for image, text, or custom ML projects. This reduces manual setup for data science teams and ensures domain experts can maintain labeling rules in a familiar format.

  • Use case: Product teams maintain defect categories, sentiment labels, or entity definitions in Excel and push them into Prodigy for annotators.
  • Business value: Faster project kickoff, fewer labeling errors, and better alignment between business and AI teams.

2. Prodigy to Excel: Export labeled datasets for review, audit, and stakeholder sign-off

After annotation is completed in Prodigy, labeled records can be exported to Excel for quality review by business users, compliance teams, or subject matter experts. Excel is useful for sampling, filtering, comparing label distributions, and documenting approval decisions before the dataset is used for model training.

  • Use case: A compliance team reviews labeled customer messages in Excel before they are approved for NLP model training.
  • Business value: Stronger governance, easier auditability, and simpler collaboration with non-technical reviewers.

3. Excel to Prodigy: Bulk import source records and metadata for annotation campaigns

Organizations frequently manage candidate records in Excel, such as product images, support tickets, claims, or catalog entries. These files can be used to feed Prodigy with the exact items that need labeling, along with metadata such as source system, priority, region, or business unit. This helps teams target annotation efforts to the most valuable data first.

  • Use case: An e-commerce team exports product images and SKU metadata from Excel into Prodigy for visual classification.
  • Business value: Better prioritization of labeling work and improved dataset relevance for model training.

4. Prodigy to Excel: Track annotation progress, label quality, and reviewer exceptions

Annotation operations often require reporting on throughput, agreement rates, unresolved items, and quality issues. Prodigy outputs can be summarized in Excel dashboards for project managers and operations leaders to monitor progress and identify bottlenecks. Excel also supports manual exception tracking for disputed labels or items requiring escalation.

  • Use case: A data operations team tracks daily labeling volume, disagreement rates, and backlog by annotator in Excel.
  • Business value: Better operational visibility, faster issue resolution, and improved workforce planning.

5. Excel to Prodigy: Maintain label taxonomies and controlled vocabularies in a business-owned spreadsheet

Many enterprises manage label hierarchies, entity lists, and business rules in Excel because these structures change over time and require input from multiple stakeholders. Integrating Excel with Prodigy allows these taxonomies to be imported directly into annotation workflows so annotators use approved categories and consistent terminology.

  • Use case: A retail analytics team maintains product attribute values, category mappings, and synonym lists in Excel and loads them into Prodigy for entity tagging.
  • Business value: Consistent labeling standards, reduced ambiguity, and easier governance of changing business definitions.

6. Prodigy to Excel: Create training data review packs for model validation and business acceptance

Before deploying a model, teams often need a human-readable review pack that shows sample inputs, predicted labels, gold labels, and disagreement cases. Exporting Prodigy annotations to Excel makes it easy for business stakeholders to validate whether the training data reflects real-world scenarios and whether the model scope is acceptable.

  • Use case: A fraud operations team reviews labeled transaction examples in Excel before approving a fraud detection model release.
  • Business value: Better model acceptance decisions and reduced risk of training on poorly defined data.

7. Bi-directional workflow: Use Excel for data preparation and Prodigy for iterative correction cycles

Excel can serve as the preparation and reconciliation layer, while Prodigy handles active labeling and correction. Teams can export raw or partially cleaned records from Excel into Prodigy, label them, then return the results to Excel for reconciliation against master data, exception handling, or business rule validation. This creates a practical loop for continuous dataset improvement.

  • Use case: A customer support analytics team cleans ticket data in Excel, labels intent categories in Prodigy, then reconciles edge cases back in Excel with operations managers.
  • Business value: Faster iteration, better data quality, and smoother collaboration across business and AI teams.

8. Excel to Prodigy: Prepare active learning seed sets and sampling lists for high-value annotation

Because Prodigy supports active learning, teams can use Excel to define initial seed sets, sampling criteria, or priority lists based on business rules such as region, product line, or risk score. These curated inputs help Prodigy focus annotation effort on the most informative records and accelerate model improvement.

  • Use case: A manufacturing team uses Excel to select defect images from high-risk production lines and loads them into Prodigy for targeted labeling.
  • Business value: More efficient annotation spend, faster model gains, and better coverage of critical business scenarios.

How to integrate and automate Excel with Prodigy using OneTeg?