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 HARMLS - FusionMLS

  • First thing you'll need to do is get into the results of a residential search.
  • Once you're in the results of a search the 'Grid Manager' icon will appear (it's on the same row as the 'Map' icon. Click on 'Grid Manager'.
  • Select 'Create New Grid'.
  • Name the grid 'TrendSheet 4'.
  • Click on each of the following categories individually and click the Right Arrow each one to get them to appear in the right window. Once you are done, the categories will appear on the right side of the window and they must be in the same order as below:
    • ML Number (ML #)
    • Status (Status)
    • List Price (LP)
    • Sales Price (SP)
    • Expiration Date (Exp Dt)
    • Listing Date (Lst Date)
    • Closing Date (Cls Date)
    • Days On Market (DOM)
    • Pending Date (Pnd Date)
    • Off Market Date (Off Market Date)
    • Termination Date (Term Date)
    • Withdrawn Date (Wth Date)
    • Disclosures (Discl)
    • Building Square Feet (Bldg SF)
    • Stories (Stories)
    • Year Built (Yr Blt)
    • Private Pool Description (Private Pool Description)
    • Seller Contribution to Buyer Costs
    • Lot Size
    • Bedrooms - Number
    • Bathrooms - Full
    • Bathrooms - Half
    • Garage - Number of Spaces
    • # of Carport spaces
  • Once the list is complete and in the above order click 'Save' and you are done.

 

How to Export your Data

  • Verify that the search you are exporting includes every type of listing (active, contingent, pending, closed, expired, canceled, etc) for at least one year back from the effective date you're using. It is better to go further back than one year to verify that all relevant listings are included so I recommend going 2.5 years back (since TrendSheet 4 analyzes two years of data at once).
  • On the results page of your search, click 'Tools' (There are two 'Tools' buttons so make sure you click the lower one that is on the same row as the 'Map' and 'Grid Manager' icon).
  • Select 'Export Data'.
  • Verify that 'All Records' is selected.
  • For 'Data Export Format:' you should select 'Tab Delimited'.
  • Do not select 'Compress File'.
  • For 'Select Export Grid Format:' choose the custom export you made which should be called 'TrendSheet 4'.
  • Check the box for 'Include Column Headers' and click 'OK'.
  • Save the file by whichever file name and to whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/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 on the topic: