AI Column Mapping
Our AI automatically detects and standardizes columns from any rent roll format. No more manual mapping or reformatting—just upload and get clean, consistent data.
From Messy to Standardized
See how our AI transforms inconsistent headers into a standard schema.
Our AI recognizes hundreds of common column name variations and maps them to a consistent 12-field standard schema.
Standard Output Schema
Every rent roll is standardized to these 12 fields, ensuring consistent data across your portfolio.
| Field | Type | Description | Example |
|---|---|---|---|
| unit_id | string | Unique identifier for the unit or suite | 101, Suite 200, Unit A |
| tenant_name | string | Legal name of the tenant or "Vacant" | ABC Corp, Smith LLC |
| sqft | number | Rentable square footage | 2,500 |
| lease_start | date | Lease commencement date | 2024-01-01 |
| lease_end | date | Lease expiration date | 2028-12-31 |
| monthly_rent | number | Current monthly base rent | $5,208 |
| annual_rent | number | Monthly rent × 12 (calculated) | $62,500 |
| rent_per_sqft | number | Annual rent ÷ SF (calculated) | $25.00 |
| status | enum | Occupancy status | Occupied, Vacant, MTM |
| security_deposit | number | Deposit amount held | $5,000 |
| lease_type | string | Type of lease structure | NNN, Gross, Modified |
| notes | string | Special terms, options, escalations | 3% annual bump |
Why AI Column Mapping?
95%+ First-Pass Accuracy
Our AI has been trained on thousands of rent roll formats and correctly maps columns on the first try.
Review Before Export
Always preview the mapping before processing. Adjust any fields that need manual correction.
Save Templates
Save column mappings for sources you upload frequently. Future uploads are mapped instantly.
Auto-calculated Fields
Annual rent and rent PSF are calculated automatically from the mapped data. No formulas needed.
See AI Mapping in Action
Upload your messiest rent roll and watch our AI standardize it in seconds. 3 free documents, no credit card required.