Skip to contentSkip to Content
Property Import Guide

Property Import Guide

Migrate your properties into Rentalot from any property management tool in minutes. No manual data entry required.

Quick Start

  1. Export your properties from your current tool (see platform guides below)
  2. Go to Properties > Import in your Rentalot dashboard
  3. Drop in the file — Rentalot auto-detects the format and maps columns
  4. Review, validate, and import

Rentalot accepts CSV, TSV, Excel (.xlsx/.xls), and JSON files. Up to 500 properties per import, 10 MB max.

Platform Guides

Zillow Rental Manager

  1. Log in to Zillow Rental Manager 
  2. Go to Properties or Listings
  3. Click Export (top-right) and choose CSV
  4. Save the file — it will contain columns like Address Street, Address City, Bedrooms, Price, etc.
  5. Drop the file into Rentalot’s import wizard

Rentalot auto-detects Zillow exports and maps all columns. You’ll see a “Detected: Zillow Export” badge.

Mapped fields: Address, City, State, ZIP, Monthly Rent (from Price), Bedrooms, Bathrooms, Square Footage (from Footage), Description (from Type).

AppFolio

  1. Log in to AppFolio
  2. Go to Reports > Unit Directory
  3. Select the properties/units you want to export
  4. Click Export to CSV
  5. Drop the file into Rentalot

Rentalot auto-detects AppFolio’s Unit Directory format and merges split address columns (Unit Street Address 1 + Unit Street Address 2) automatically. You’ll see a “Detected: AppFolio Unit Directory” badge.

Mapped fields: Address (merged), City, State, ZIP, Monthly Rent (from Market Rent), Bedrooms, Bathrooms, Square Footage (from Sq Ft), Description (from Unit Type).

Buildium

  1. Log in to Buildium
  2. Go to Rentals > Units
  3. Click Export to download the unit list as CSV
  4. Drop the file into Rentalot

Rentalot auto-detects Buildium exports and merges multi-line address fields (Unit address line 1, line 2, line 3, Unit number) into a single address. You’ll see a “Detected: Buildium Unit List” badge.

Mapped fields: Address (merged from address lines + unit number), City (from City/Locality), State (from State/Province/Territory), ZIP (from Postal code), Monthly Rent (from Market rent), Bedrooms, Bathrooms, Internal Notes (from Unit number), Description (from Sub type).

Rent Manager

  1. Log in to Rent Manager
  2. Go to Reports > Units (or generate a Unit Report)
  3. Export the report as CSV
  4. Drop the file into Rentalot

Auto-detected when columns include Property Name, Unit Name, Street, and Market Rent. Badge: “Detected: Rent Manager”.

Mapped fields: Address (from Street), City, State, ZIP, Monthly Rent (from Market Rent), Bedrooms (from Beds), Bathrooms (from Baths), Square Footage (from SqFt), Neighborhood (from Property Name), Internal Notes (from Unit Name).

Propertyware

  1. Log in to Propertyware
  2. Go to Properties > Units
  3. Click Export to download as CSV or Excel
  4. Drop the file into Rentalot

Auto-detected when columns include Property Address, Unit, City, Rent Amount, and # Beds. Badge: “Detected: Propertyware”.

Mapped fields: Address (from Property Address), City, State, ZIP, Monthly Rent (from Rent Amount), Bedrooms (from # Beds), Bathrooms (from # Baths), Square Footage (from SqFt), Year Built, Pet Policy, Deposit.

Any Other Tool

Export your properties as CSV or Excel from any tool. As long as you include recognizable column headers, Rentalot will auto-map them.

Recognized column names:

Property FieldColumn Names That Work
Addressaddress, street, street_address, location
Monthly Rentrent, monthly_rent, price, rent_amount
Bedroomsbedrooms, beds, br
Bathroomsbathrooms, baths, ba
Square Footagesqft, square_footage, sq_ft, area
Pet Policypets, pet_policy, pet_friendly
Depositdeposit, security_deposit
Descriptiondescription, desc, notes, details
Citycity, town
Statestate, province
ZIPzip, zipcode, postal_code
Availabilityavailable, availability_date
Featuresfeatures (comma-separated)
Amenitiesamenities (comma-separated)
Image URLsimages, photos, image_urls (comma-separated)

If a column isn’t recognized, you can manually map it in the import wizard.

CSV Template

Starting from scratch? Use this template:

address,rent,bedrooms,bathrooms,sqft,description,pet_policy,deposit,available
"123 Main St, Apt 4B, Austin TX 78701",1500,2,1,850,"Renovated 2BR with hardwood floors",allowed,1500,2026-04-01
"456 Oak Ave, Unit 2, Austin TX 78702",2200,3,2,1200,"Spacious 3BR near downtown",negotiable,2200,2026-05-01

Required columns

Every row needs at least: Address, Rent, Bedrooms, Bathrooms.

Value formats

Values are automatically cleaned and converted:

InputConverted To
$1,5001500
3 BR3
Yes / trueallowed (for pets)
03/15/20262026-03-15
2k2000
pool, gym, parking["pool", "gym", "parking"]

Image Import

Include image URLs in your CSV to import property photos alongside your listings. Use a column named images, photos, or image_urls with comma-separated URLs:

address,rent,bedrooms,bathrooms,images
"123 Main St, Austin TX",1500,2,1,"https://example.com/photo1.jpg, https://example.com/photo2.jpg"

Images are downloaded and stored in Rentalot automatically. Supported formats: JPEG, PNG, WebP.

API Import

For programmatic imports, use the Properties API. The API supports single-property creation and bulk import with the same field mapping and validation.

Tips

  • More fields = better AI responses. The more detail you include (amenities, pet policy, parking, lease terms), the better your agent answers prospect questions.
  • Review before importing. The validation step catches missing required fields and formatting issues. Fix or skip problem rows before importing.
  • Duplicates aren’t merged. If you import the same property twice, you’ll get two entries. Delete duplicates from the Properties page.
  • Status defaults to active. Imported properties are set to active by default. Change status from the dashboard after import.
PropertiesProperty Photos