WAIT!! Before you read the instructions below, MLSPIN changed the way their custom export setups are “built”. What used to take 30 seconds now takes between 5 and 15 minutes. It can be a huge pain so please give us a call and we’re happy to do it for you. If you’d still like to do it on your own then go ahead and follow the instructions below.
If, for any reason, you have trouble with the file setup below or with the data going into Spark, contact us here for assistance.
One-Time Custom Export Setup for use in the MLSPIN system
Watch this video or follow the instructions below:
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 MLSPIN system. Contact us here if you have problems with the file setup and we will be glad to help.
Get into the search screen by clicking 'Search' at the top of MLSPIN.
Choose 'Single Family'.
Choose the Status type of 'Back On Market' (choose only that status type). I realize that sounds odd but it's just for this setup and not how you'll use it normally.
Click the orange 'Results' button at the top right.
Left-click the top left checkbox to select all of the listings.
Left-click the 'Download' button (on the same row as the checkbox you just checked).
At the top, under ‘Save As’ be sure that ‘CSV’ is chosen.
Make sure that the checkboxes for ‘Use Feature Codes’ and ‘Include Header Row’ are checked.
Double-click on every single field on the left list to move it over to the right (order does not matter). NOTE: MLSPIN changed this so you can no longer select every field all at the same time so you do have to select them individually. We realize this is a pain so call us and we’ll gladly do it for you.
Where it says 'Save’ (toward the bottom right), just to the left of that, type in “SPARK” to name this export type.
Click the ‘Save’ button.
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. If the search has many listings, simply put a check box next to the properties you want Spark to put into your sales grid or if you're doing the search for Competing or Neighborhood properties you can use the top check box to select all of the properties.
Click the blue 'Download' button.
On the next screen click the ‘Spark’ button at the bottom to use the Spark export method.
Save the file by whichever file name and into whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/location and the file will automatically be saved to your 'Downloads' folder).
Now load Spark by going to app.sparkforappraisers.com and follow the steps.
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).