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.

Creating a Custom Export for use in the Burlington Alamance MLS in North Carolina - InnoViaMLS

  • Click 'Search' then 'Custom Displays'.
  • For 'Property Format' select SFR and then click 'New'.
  • Name the export TrendSheet.
  • Select 'Oneliner'.
  • Select the following fields from the 'Available Fields' list and add them to the 'Selected Fields' list. Be sure to include all fields and they must be in the order shown:
    • MLS Number
    • Status Code
    • List Price
    • Closing $
    • Status Date
    • List Date
    • Closing Date
    • Days on Market
    • Date Contract
    • Type of Sale
    • Apx Above Grade Total SQFT
    • Stories
    • Year Built
    • Exterior Features (CF)
  • Uncheck the 'Include Select Checkbox' and 'Use Embedded Links' boxes.
  • In the 'Share Display With' drop-down, select a group who may access the custom report (no one, the office, or the firm).
  • For 'Title Font' select 'Title'
  • For Label Font select 'Head'
  • For 'Data Font' select 'Shared'
  • Click 'Save'

 

How to Export your Data

  • Verify that the search you are exporting includes every type of listing (active, contingent, pending, closed, expired, canceled, etc 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 1.5 years. 
  • Once you complete a search and you're on the search results page choose 'Select All'.
  • Select the custom report TrendSheet from the 'Oneliner Display' drop-down list.
  • Now click the 'Excel File' link.
  • Click 'Save' on the File Download window NOTE: If the report opens in a browser window or in a spreadsheet program automatically, just choose 'File' then 'Save As'.
  • Save the file by whichever file name and into whichever folder you prefer.

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 on the topic: