> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cassidyai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Census-to-Quote Template Converter

> This tool transforms messy employee census files into accurate, quote-ready submissions in minutes, eliminating manual cleanup and accelerating turnaround times across all benefit lines.

<Frame>
  <img src="https://mintcdn.com/cassidy/sYy-vNuqpU0xqerK/images/use-cases/census-to-quote-template-converter-img-0.png?fit=max&auto=format&n=sYy-vNuqpU0xqerK&q=85&s=55b69b81d249721c36a9aa3309cd242e" alt="Census-to-Quote Template Converter" width="1920" height="1080" data-path="images/use-cases/census-to-quote-template-converter-img-0.png" />
</Frame>

## What does this mean?

Benefits and sales teams convert messy intake files into accurate, quote-ready submissions in minutes, cutting manual cleanup, reducing avoidable back-and-forth, and speeding quote turnaround across health, dental, vision, life, disability, and ancillary lines.

Accepts employee census files—spreadsheets listing employees, dependents, locations, and current benefits—from brokers, HR teams, and carriers in any format, merges employee and dependent records, deduplicates people across files, standardizes columns and status codes, applies carrier- and vendor-specific rules, and outputs clean data into the exact quote templates required by benefits carriers, TPAs, and marketplaces, while logging every step with role-based access controls.

## Workflow steps

<Steps>
  <Step title="Upload census files">
    The Workflow begins when a team member uploads employee census files—spreadsheets containing employees, dependents, locations, and current benefits—in any format from brokers, HR teams, or carriers.
  </Step>

  <Step title="Parse and merge records">
    Cassidy processes the uploaded files, extracting employee and dependent data and merging related records into a unified dataset.
  </Step>

  <Step title="Deduplicate entries">
    The Workflow identifies and removes duplicate people across files, ensuring each employee and dependent appears only once in the final output.
  </Step>

  <Step title="Standardize data formats">
    Cassidy normalizes columns, status codes, and field values to match consistent formatting standards across all records.
  </Step>

  <Step title="Apply carrier-specific rules">
    The Workflow routes data through different formatting rules based on the target carrier, TPA, or marketplace—applying the exact specifications each vendor requires.
  </Step>

  <Step title="Generate quote-ready templates">
    Cassidy outputs the clean, standardized data into the precise quote template format required by each benefits carrier, ready for immediate submission.
  </Step>

  <Step title="Log activity and deliver output">
    Every transformation step is logged with role-based access controls for auditability. The completed templates are delivered to the team member for review and submission.
  </Step>
</Steps>

## Related

<CardGroup cols={2}>
  <Card title="Build and configure an Agent" icon="robot" href="/agents/build-and-configure">
    Create a custom Agent with tailored instructions and Knowledge Base access.
  </Card>

  <Card title="Set up your Knowledge Base" icon="book" href="/knowledge-base/setup">
    Add your company documents so Agents can reference them.
  </Card>
</CardGroup>
