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.

Below are the instructions you need for the one-time setup of your export file in SWFLAMLS.

If, for any reason, you have trouble with the file setup below or with the data going into Spark, contact us here for assistance.

Creating a Custom Export for use in the SWFLAMLS Matrix system

MLS export files that are uploaded to Spark must be in a specific format in order to provide both accurate data and all possible fields.

Follow the instructions below to complete the one-time setup for Spark in the SWFLAMLS Matrix system.  Contact us here if you have problems with the file setup and we will be glad to help.

  • Hover your mouse over 'My Matrix' and select 'Settings'.

  • Click on 'Custom Exports' then click on 'Add Export'. NOTE: Be sure that before you click 'Add Export' that the property type in the drop-down is noted as the appropriate type for the export you're creating. For example, if you're creating an export for Rentals that you switch to Rental/Lease type and if you're creating an export for Multi-Family properties (Residential Income) you switch to that type.

  • Name the export 'Spark'.

  • IMPORTANT: Verify toward the bottom that 'Label' and 'Comma' are chosen. The 'Label' button is TO THE RIGHT of the word 'Label'.
    Looks like this:      None ( )     Label (●)     Name ( )
    No need to enter a description.
  • Click on each of the following categories individually and click 'Add' after each one. Once you are done, the categories will appear on the right side of the window. I realize the list is long but once this is set up in your MLS you'll never have to do it again although if you plan on using Spark for importing rentals you will have to repeat this process for the Rental export setup. IMPORTANT: FOR MULTI-FAMILY, IF FIELDS IN THE BELOW LIST DO NOT EXIST SIMPLY SKIP THEM AND IT WILL WORK.

    • Acres - NOT FOR RENTALS

    • Additional Rooms

    • Amenities

    • Approx Living Area

    • Auction YN

    • Baths Full

    • Baths Half

    • Beds Total - NOT FOR RENTALS

    • RENTAL ONLY - Bedrooms

    • Building Desc

    • Building Design

    • Carport Spaces

    • Community Type

    • Cooling

    • County

    • RENTAL ONLY - Date Rented

    • DOM (you can use CDOM if you prefer but do not include both)

    • Exterior Features

    • Foreclosed REOYN

    • Full Address

    • Garage Desc

    • Garage Spaces

    • Heat

    • Interior Features

    • Land Lease Fee - NOT FOR RENTALS

    • List Price - NOT FOR RENTALS

    • Listing Date

    • MLS Number

    • RENTAL ONLY - Monthly Rate

    • Original List Price - NOT FOR RENTALS

    • Parking

    • Pending Date - NOT FOR RENTALS

    • Pendingwith Contingencies Date - NOT FOR RENTALS

    • PID

    • Potential Short Sale YN

    • RENTAL ONLY - Price Rented

    • Private Pool Desc

    • Private Spa Desc

    • Property Type

    • Room Count - NOT FOR RENTALS

    • Seller Concession Amount

    • Sold Date

    • Sold Financing Type - NOT FOR RENTALS

    • Sold Price (CLOSE PRICE FOR MULTIFAMILY) - NOT FOR RENTALS

    • Status

    • Status Change Timestamp

    • Sub Condo Name

    • Total Floors

    • Unit Floor

    • Unit Number

    • View

    • Windows - NOT FOR RENTALS

    • Year Built

    • Zip Code - NOT FOR RENTALS

  • Once the list is complete, click 'Save' and you are done

  • The custom export just created applies to residential properties but not rentals. Add another export but this time click on the drop-down that says 'Residential' and change it to 'Residential Rental'. Use the above list making sure to include the items that are for rentals.

How to Export your Data

  • Verify that the search you are exporting includes the sales/listings/rentals you want to put into the grid(s) of your appraisal report.

  • On the results page of your search choose the listings/sales/rentals you want included (using the check box to the left) or click 'All' if you want all of them.

  • Click 'Export' which is on the bottom row of buttons.

  • Verify the custom export you made is selected in the drop-down which should be 'Spark' then click 'Export'.

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

  • Now load Spark by going to app.sparkforappraisers.com and follow the steps.

  • *Keep in mind that, since this MLS system has a limitation of only allowing 50 fields to be exported, we were not able to export all fields. At this time, the only field that is missing is HOA fee on a condo report (which required 6 fields to ascertain accurately).

Note: Spark can input a maximum of 30 properties for each grid (sales grid/listing grid/rental grid) and a maximum of 10,000 for your 1004MC files (Competing and/or Neighborhood File).

IMPORTANT FOR MULTI-FAMILY: Spark will work with multi-family forms, however, your MLS does not allow exporting of all of the necessary multi-family data so Spark will load in as much as it can, but you will have some fields with no information. If and when your MLS provides data for the rest of the fields, we will update accordingly. To use Spark with multi-family properties, do the following:

Export the information like normal (you will have to create a custom export for multi-family but this uses the exact same instructions as that for the SFR export setup - when creating the export simply skip the fields that are not available for multi-family). Next, be sure that, when you’re in Spark, you choose the 1025 form before you load in your data so that the data loads in correctly. Keep in mind that some data, including individual unit information, will not be available and some property feature information (e.g. pools, fireplaces, etc) that works fine for SFR and Condos may not be exported from the MLS the same when it comes to multi-family. Be sure to verify all of the information.