One Time Data Import - Listings CSV File Specifications, with Separate Buildings File

The listing CSV file should contain a list of your rental listings data. The CSV file should be comma(,) delimited. A listing record needs to indicate which building and landlord it belongs to. This schema should be used when you are submitting a separate buildings CSV file, as each listing record must have a corresponding building ID.

CSV Columns

The listings csv file should contain the following columns in the order specified. If certain columns do not apply to you or if there is no data, please leave it blank. PLEASE NOTE: A header row is required! Rows containing invalid data will be rejected.
Column Index Name Description
1 ID Unique listing ID number.
2 Unit Number
3 Available Date In the format of mm/dd/YYYY.
4 Fee Paid By Landlord Our system supports "None", "Full Fee", "Half Fee", "Quarter Fee", "75% Fee", "Negotiable", "Co-Broke" and "Other". Fee values must be spelled exactly as stated above. If your fee structure is different, contact us to see if we can work out a solution.
5 Price Listing monthly rent.
6 Beds Number of beds the listing has.
7 Baths Number of baths the listing has.
8 Rent Includes List of utilities included with rent separated by "|". Supported values are: "Electricity", "Gas", "Heat", "Hot Water", "All" (all utilities are included)
9 Heat Source Supported values are: "Gas", "Electricity", "Oil", "Other"
10 Unit Level Listing floor level. Supported values are: Integer (1 - 199), "B" (Basement), "P" (Penthouse), "G" (Garden Level)
11 Parking Listing parking options. Supported values are: "Available", "Included", "Garage", "Street"
12 Square Footage Should be an integer
13 Tenant Contact The current tenant contact info.
14 Pet Policy Supported values are: "Cat Ok", "Dog Ok", "Pet Friendly", "Negotiable", "No Pet", "Unknown"
15 Student Policy Supported values are: "No Undergrad", "No Student", "Student Ok", "Graduate Ok"
16 Market Status Supported values are: "ONMARKET", "OFFMARKET", "APP" - Application Pending/Hold
17 Ad/Public Title Listing public title used for marketing. Max. 70 characters
18 Ad/Public Description Listing public description used for marketing.
19 Private Description Listing private notes.
20 Features List of listing features / amenities separated by "|".
21 Photos List of listing photo URL separated by "|".
22 Building Id The building this listing belongs to. Should correspond to the buildings CSV file.
23 Landlord Id The landlord this listing belongs to. Should correspond to the landlords CSV file.
24 key The unit key tag/info.
Are we missing anything?

Every system is different. We don't want you to lose important data. Please let us know if you have fields that you would like us to include in the import.

Feedback and Knowledge Base