Choice Valuation, PLLC

Your choice for residential appraisals and appraiser products

Mesa, AZ

Performing single- and multi-family residential appraisals and creating simple, useful software for appraisers.

Creating a Custom Export for use in the SABOR system - ConnectMLS

  • First thing you'll need to do is get into ConnectMLS.

  • Hover over Reports and click on 'Custom Reports'.

  • Then you'll click 'Add New Report'.

  • Verify that for 'Property Type' you select 'Residential' and name the report 'TrendSheet 4'. Click HERE for instructions on the condominium setup.

  • Then you'll go through the list on the right and remove all of the fields except for 'MLS #' and 'Status' by clicking on each one and then clicking on the 'move left arrow' which looks like this: '<-'.

  • Then you'll add the following categories from the left window to the right window using the 'move right arrow' which looks like this: '->'.

  • The final list on the right should look like this and the fields must be in this order:

    • MLS #

    • Status

    • List Price

    • Sold Price

    • Status Date

    • List Date

    • Closing Date

    • Days on Market

    • Contract Date

    • Miscellaneous

    • Potential Short Sale

    • Square Feet

    • # of Stories

    • Year Built

    • Pool

    • Pool/Spa

    • Seller Concessions

    • Seller Concessions Description

    • Lot Size (Acres)

    • Bedrooms

    • Full Baths

    • Half Baths

    • Garage Parking (SKIP THIS FOR THE CONDO SETUP)

    • Additional/Other Parking (SKIP THIS FOR THE CONDO SETUP)

  • Once the list is complete and in the above order click 'Save'.

  • Be sure and do this process for condominiums as well using the condominium list (click here for the condominium instructions).

 

How to Export your Data

  • Verify that the search you are exporting includes every type of listing EXCEPT RENTALS (all active and all off-market excluding leased) for at least one year back from the effective date you're using. The further back you go the more likely you are to include pertinent data. I recommend going 2.5 years back since TrendSheet 4 analyzes two years of data at once.

  • Once you are in the results screen of your search click the 'Export' button which is a picture of a folder with a down arrow on it.

  • Verify that 'All listings' is selected and click 'Next'.

  • Click the drop-down box on the 'All fields in this report' line, choose 'TrendSheet 4', then click 'Next'.

  • In the 'File format' verify that 'Tab-delimited text' is chosen then click 'Continue'.

  • Save the file as whatever name and to whatever folder you prefer (depending on browser settings you may not be given the option to choose the name and location).

The last thing to do is copy and paste the data from the export into TrendSheet 4. If you need help with this please check out our video below on the topic. When you open your file that was downloaded from your MLS system it may say the file is in a different format and ask if you are sure you want to open it. Just choose 'Yes'. 

In this MLS if your computer gives an error when trying to open the downloaded file, it will given an option for you to choose which program to open the file with. Choose 'Notepad'. Your computer will save this setting and you will only have to choose that 'Notepad' once.