Choice Valuation, PLLC

Your choice for residential appraisals and appraiser products

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

TrendSheet 4 - IL / MRED
139.00 150.00

Creating a Custom Export for use in the Chicago, IL area - 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 'Detached Single' (or 'Attached Single') and name the report 'TrendSheet'. You'll do this once for 'Detached Single' and once for 'Attached Single' if you use both types of searches.
  • 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 they must all be in the same order:
    • MLS#
    • Status
    • List Price
    • Sold Price
    • Status Date
    • List Date
    • Closed Date
    • Listing Market Time
    • Contract Date
    • Short Sale/Foreclosed/Court Approved
    • Approx Sq Ft
    • Type Detached (*should be Type Attached when creating this for 'Attached Single' searches)
    • Approx Year Built
  • Once the list is complete and in the above order click 'Save'.
  • This should be done once for 'Detached Single' properties and once for 'Attached Single' properties if you use both types of searches.


How to Export your Data

  • Verify that the search you are exporting includes every type of listing (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 1.5 years back if possible.
  • 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, then click 'Next'.
  • In the 'File format' line choose 'Excel' from the drop-down and 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. 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'.