HOW TO EXPORT DATA FROM YOUR MLS
STEPS TO EXPORT DATA FROM YOUR MLS
1. Create your MLS search
In selecting data, make sure that ALL status options are selected.
Selecting all status activity will ensure that all the data needed to create the graphs is collected.
Additionally, you will need to select the "Closed", "Withdrawn", and "Expired" dates to be two years
back.
When searching for all status activity for the last two years,
your search results should be in the 50 to 100 comparable properties range (this is a rough guideline).
If you have slightly less than 50 that works, or a little above 100 is fine as well.
You should also make your normal selection choice by selecting other options that you would normally select
in doing a CMA.
For example, options you would normally use when doing a CMA,
could include a map search (using a polygon), subdivision or neighborhood,
city, zip code, lot size (<.5 acre, 1-5 acres, etc. ), on water. Looking at activity in specific
subdivisions is also good starting point. For your initial search you want to focus on location
(location, location) and add in unique features (only if necesssary). To view a short tutorial on how to
do an effective search to use in your Focus 1st Pricing, select
this link.
Once you've selected the search criteria, press the SEARCH button
to see the results as shown below.
When searching for all status activity for the last two years, your search results should be in the 50 to 100 comparable properties range (this is a rough guideline). If you have slightly less than 50 that works, or a little above 100 is fine as well.
2. Create the Column Layout by adding the required columns.
Before you can export data, you must first customize the Column Layout by adding additional columns to
the search results.
This is a one-time action that you will need to do.
Once you have added the additional columns to your layout you will not need to do this again and you
can skip this section.
You must first make sure the format showing the results are in the Grid format. If it isn't you can change the format using the View as option located at the top of the results on the right side. Once you've done that your screen should look similar to the search results shown above.
Now you are ready to add columns. The columns you will add are shown in a table below. To add the columns you need to select the Actions drop-down button (located at the left of the screen just above the search results) and then select the Add/Remove Columns option.
When you add columns, you should add the columns as shown in this section for the Focus 1st
application to understand the format.
To add columns scroll down past the Standard Columns area located
at the bottom of the dialog box.
Once you are past that area you will see a screen with the field names and checkboxes to the left of
them.
Select each of the columns shown below to add the respective column to the search results screen. You can select each column be checking the box to the left of that column name. Do this for each of the column names shown below.
Once you have added all the columns, save the Column Layout by selecting the Apply button. You will need to use have this Column Layout format displayed when you are ready to export your results. To save the Column Layout you need to select the Actions drop-down button (located at the left of the screen just above the search results) and then select the Save Current Column Layout option. Once you've selected this option you will see the Save Column Layout dialog box, as shown below
Enter the name of Focus 1st as the Column Layout and check the
box next to the Make this my default layout option and then select
the Save button.
You are now ready to export your results.
3. Export your results
To export results, first CHECK all the properties.
To check all the properties at the top of the search screen,
select the box option (just above the search results on the left of the
screen).
You will see all the properties check boxes checked (located on the left side of the results screen)
and all the properties highlighted.
Also be sure that the View as is set to the Grid format and that you are showing the
Focus 1st column layout.
You can change to the Focus 1st column layout by
selecting the Actions drop-down button
(located at the left of the screen just above the search results)
and then select the Load/Manage Column Layout option.
Once you've selected this option you will be able to select the
Focus 1st as your column layout.
You are now ready to export your results. To export the results, while on your search results screen, select the Actions drop-down button (located at the left of the screen just above the search results) and then select the Export to Excel option.
