> Appraise.com
CSV Creation and Export Instruction for MetroList Based MLS Systems

REQUIRED FIELDS IN CORRECT ORDER
The following fields must be in your final CSV file and in the order indicated.

  1. Status Desc
  2. Address - Street Number
  3. Address - Street Name
  4. Address - City
  5. Address - State
  6. Address - ZIP
  7. Year Built
  8. Square Footage
  9. Lot Size - Sq Ft
  10. Listing Date
  11. Listing Price
  12. Pending Date
  13. Selling Date
  14. Selling Price
  15. Status Date
  16. DOM
  17. Short Sale
  18. REO


STEP 1.

Login into your MLS account and navigate to the "Admin" button and then to "Custom Export Setup" as indicated below.


STEP 2.

Click on the "Create Export" button.


STEP 3.

Name your Export Rule, and then select "Custom" from the only pull down box available. Match the settings below and make sure that the
"Field Separator" is only a comma. (Setting should match the setup below.)


STEP 4.

Click on the "Save" button.


STEP 5.

Locate the required fields in the "Available Residential Fields" window, highlight them one at at time and "Add" them so that they appear in the "Selected Fields" window in the correct order. Make sure to include only the 18 fields that match the list above.


STEP 6.

Click on the "Save" button.


Your Export is ready to use!

The following is a demonstration of running a map search for a market area.

STEP 1.

Select your area. Any search is possible, but it must be for a period of 1 year.


STEP 2.

As stated above, research for all records for a period of one year from the effective date of the report.
The effective date of this demo is "4/23/11"


STEP 3.

Click on the "Exports" button.


STEP 4.

Select the Export that you created from the pull down box and then click on the "Submit" button.


STEP 5.

Click on the file created by the MLS system.

Save the .CSV file to your computer
The file in the image "128944_RESI_58BF.csv".


STEP 6.

Login and Navigate to the MetroList MLS Analytics Page.
Launch a new browser to login and locateMetroList MLS Analytics Page
Browse for the .CSV file and click upload. Make sure that the effective date of the data matches your research parameters.