Data Import - Listings CSV File Specifications, with Separate Buildings File
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 "No Fee Paid", "25% Month", "50% Month", "75% Month", "1 Month", "1.5 Months", "2 Months", "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", "Cable", "Internet" |
| 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: "For Rent", "Street", "Available", "None" |
| 12 | Square Footage | Should be an integer |
| 13 | Tenant Contact | The current tenant contact info. |
| 14 | Pet Policy | Supported values are: "Cats Allowed", "Cat Negotiable", "No Cat", "Dogs Allowed", "Small Dogs Only", "Dog Negotiable", "No Dog" |
| 15 | Market Status | Supported values are: "ONMARKET", "OFFMARKET", "APP" - Application Pending/Hold |
| 16 | Ad/Public Title | Listing public title used for marketing. Max. 70 characters |
| 17 | Ad/Public Description | Listing public description used for marketing. |
| 18 | Private Description | Listing private notes. |
| 19 | Features | List of listing features / amenities separated by "|". |
| 20 | Photos | List of listing photo URL separated by "|". |
| 21 | Building Id | The building this listing belongs to. Should correspond to the buildings CSV file. |
| 22 | Landlord Id | The landlord this listing belongs to. Should correspond to the landlords CSV file. |
| 23 | Showing & Tenant Info | How to show the property and tenant name and contact info. |
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.