Data import
OntarioLandlord supports bulk data import from CSV and XLSX files. Import properties, leases, tenants, and transactions to get your portfolio set up quickly.
Supported formats
- CSV — Comma-separated values
- XLSX — Excel spreadsheet
What you can import
| Data type | Fields |
|---|---|
| Properties | Address, unit numbers, property type |
| Leases | Tenant info, rent amount, dates, terms |
| Tenants | Name, email, phone, contact details |
| Transactions | Payment dates, amounts, categories |
Import workflow
- Navigate to Import in the sidebar
- Select the data type to import
- Upload your CSV or XLSX file
- Map columns — Match your file's columns to OntarioLandlord fields
- Validate — The system checks for errors and shows a preview
- Confirm — Review the validation results and confirm the import
Pre-import validation
Before importing, the system validates:
- Required fields are present
- Data formats are correct (dates, numbers, emails)
- No duplicate records detected
- Referenced records exist (e.g., property exists for a lease import)
Errors are shown with row numbers and specific issues so you can fix your file before retrying.
Rollback
If you discover issues after import, the rollback feature lets you revert the entire import. All records created during the import are removed.
DoorLoop import
For DoorLoop users, a dedicated integration syncs data via API instead of file upload. See DoorLoop integration.
Start with properties
Import properties first, then leases, then transactions. This ensures the parent records exist when importing child records.