ETL Workflow Manager for P&C Insurance Agency

Rev-Box ingests Excel files from multiple insurance carriers and normalizes them into a unified, queryable policy dataset. It supports per-carrier field mapping, status and category translation, and AI-assisted mapping suggestions that run entirely in the browser.

Rev-Box is a carrier data ETL platform for insurance agencies. It accepts Excel workbooks from multiple carriers — each with their own column structures, status codes, and category taxonomies — and transforms them into a single normalized database. The system supports per-carrier field mapping, status and category code translation, and AI-assisted mapping suggestions that run entirely in the browser with no external API calls. Uploads are idempotent, raw rows are preserved for traceability, and failed rows are quarantined without stopping the pipeline. A policy table with search, filtering, and CSV export sits on top of the unified dataset.