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

The listing CSV file should contain a list of your rental listings data with address information. The CSV file should be comma(,) delimited. A listing record needs to indicate which landlord it belongs to. This schema should be used when your listings do not have separate building associations, hence you do not have separate building IDs.

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 Street Number Max. length 25 characters.
3 Street Name Max. length 150 characters.
4 City Max. length 100 characters.
5 State Max. length 2 characters. E.g. MA, CA, NY
6 Zip Code Max. length 5 characters.
7 Neighborhood Supported neighborhood list: [[YGL_City_Neighborhoods|YGL Valid City/Neighborhood List]]
8 Latitude Used for geocoding. Valid decimal number required.
9 Longitude Used for geocoding. Valid decimal number required.
10 Unit Number Max. length 25 characters.
11 Available Date In the format of mm/dd/YYYY. If empty, it indicates this listing is always available.
12 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.
13 Price Listing monthly rent.
14 Beds Number of beds the listing has.
15 Split Indicates if the apartment is a split. Supported values are: 1 or 0.
16 Baths Number of baths the listing has.
17 Rent Includes List of utilities included with rent separated by "|". Supported values are: "Electricity", "Gas", "Heat", "Hot Water" or "All" (all utilities are included)
18 Heat Source Supported values are: "Gas", "Electricity", "Oil", "Other"
19 Unit Level Listing floor level. Supported values are: Integer (1 - 199), "B" (Basement), "P" (Penthouse), "G" (Garden Level), "T" (Top Level)
20 Parking Listing parking options. Supported values are: "Available", "Included", "Garage", "Street"
21 Square Footage Should be an integer
22 Tenant Contact The current tenant contact info. Max. length 250 characters.
23 Pet Policy Supported values are: "Cat Ok", "Dog Ok", "Pet Friendly", "Negotiable", "No Pet", "Unknown"
24 Student Policy Supported values are: "No Undergrad", "No Student", "Student Ok", "Graduate Ok"
25 Market Status Supported values are: "ONMARKET", "OFFMARKET", "APP" - Application Pending/Hold
26 Ad/Public Title Listing public title used for marketing. Max. 70 characters
27 Ad/Public Description Listing public description used for marketing. Max. length 5000 characters.
28 Private Description Listing private notes. Max. length 5000 characters.
29 Features List of listing features / amenities separated by "|".
30 Photos List of listing photo URL separated by "|".
31 Landlord Id The landlord this listing belongs to. Should correspond to the landlords CSV file.
32 key The unit key tag/info. Max. length 200 characters.
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