How to export data from Navica for Titan Analytics

This document explains how to export data from Navica and create a CSV file for use in Titan Analytics.

Document 3014  ¦  Last updated:  09/19/2017 RR2

MLS vendors integrate with MLS boards across the country to provide the interfaces you use to search for properties in your area.  While you may be familiar with MLS boards like Sandicor or Arizona Regional MLS (ARMLS), what you interact with on the screen is provided by the MLS vendor.  Major vendors include RapattoniMLS, Paragon®, Matrix™, Flexmls®, and Navica.

Determining the MLS vendor is simple.  Typically, these names are located on the home page or login screen of your local MLS board website, either near your MLS logo or at the bottom of the page.  If you have trouble locating your vendor, contact your MLS board for help determining which MLS vendor they use.

The following instructions are for Navica.  If this isn't the vendor your MLS board uses, click here for a complete list of vendors.

We provide these instructions as a courtesy to our customers, and are not in any way affiliated with the MLS boards or MLS vendors outlined in our instructions.  Steps contained in these documents are accurate to the best of our knowledge.

Follow the instructions below to create an export template in Navica, export and save your data as a Comma Separated Value (CSV) file, and then import the property data to Titan Analytics.

Part I — Create your template (first-time setup)

You only need to create an export template once.  After you save it, you can reuse the template each time you export data from your MLS.  If you already have a template for Titan Analytics, jump to Part II.

  1. Log in to your MLS.
  2. Click Resources in the menu on the left, then click the Custom Exports tab.  Click New Export to create a new export template.

  3. Enter a name for the export template in the Name field — such as Titan Analytics.  Select the property type(s) to include in the template, and in the Include Header Row option use the drop‑down to select Yes.
  4. In the Export As option use the drop‑down to select CSV, and leave the Select Column Delimiter option set to the COMMA default.

  5. From the fields listed in the Available Fields column on the left, select a field and click the arrow pointing to the right to add it to the Current Selected Fields column on the right.  Below is the list of required fields that must be included:

    It doesn't matter in which order these fields are added.  Once the required fields have been added, you can also include any additional fields that might be useful for identifying outliers.

    Additionally, the field names listed below won't always be an exact match to the field names listed by your MLS.  Titan Analytics knows the different ways an MLS will say Closing Price or Listing Date, for example, and can decipher the data.

    • Listing ID (MLS #)
    • Status (sold, pending, etc.)
    • Close Date
    • Expiration Date
    • Listing Contract Date
    • Withdrawn Date
    • Contract Date
    • Purchase Pending Date
    • List Price
    • Close Price
    • Distressed (bank owned, foreclosure, etc.)
    • Total Days on Market
    • Latitude (Optional)
    • Longitude (Optional)
    • Street Address
    • City
    • State or Province
    • Living Area (GLA)
    • Lot Size (Optional)
    • Year Built (Optional)
    • Garage (Optional)
    • Levels/Stories (Optional)
    • Bedrooms (Optional)
    • Bathrooms (Optional)
    • Pool (Optional)
    • Seller Concession Amount
  6. When you're finished, review and verify the Selected Fields column on the right.  Then, click Complete in the lower right.

Part II — Export to file

Once you've saved your export template, use it to export the property data from your MLS search for use in Titan Analytics.

  1. Log in to your MLS.
  2. Click Search in the menu on the left and enter your search criteria in a new search.  Be sure to mark all property statuses you want to include in your data, and include listing and sold properties from at least the last 365 days.
  3. Now, run the search as you normally would, and review and select the results to include in your export.  When you're finished, click Export on the upper right.

  4. From the custom exports displayed, leave the Include Photos option unchecked and click the Export button next to the Titan Analytics template you created in step 4 of Part I above.

  5. Right-click the button that reads "Right Click to Save File As" and, depending on your browser, choose Save link as… or Save target as… to begin downloading the export file to your computer.  Save the file to a convenient location such as your Windows desktop so that you can easily retrieve it in Titan Analytics.

Part III — Import data

That's it!  Your CSV export file is now ready for use.  Click here for step-by-step instructions on importing the data in your CSV file to Titan Analytics.  Or, click here to view some of the most frequently asked questions about Titan Analytics.

Related Links