How to export data from Paragon® for Titan Analytics

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

Document 3011  ¦  Last updated:  08/29/2017 RR2

Paragon® is an MLS solution used by many boards across the United States.  The easiest way to tell if your board is on Paragon is to log in to your MLS.  Once logged in, the Paragon logo is visible at the top left.

Follow the instructions below to create a template in Paragon, export and save your data as a Comma Separated Value (CSV) file, and import the property data to Titan Analytics.  Or, if this isn't the vendor your MLS board uses, click here for a complete list of vendors.

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 Preferences in the menu area on the upper right, and use the drop‑down menu to select Reports.

  3. Expand the Report Views (A) folder on the left, click Spreadsheet (B), and then choose an unused spreadsheet listed on the right to edit.
    Because Paragon does not allow you to create a new spreadsheet, you will need to select an existing spreadsheet and modify it to use as your Titan Analytics spreadsheet.

  4. Enter a name for the export template in the Name field — such as Titan Analytics.

  5. From the fields listed in the Available column on the left, check the items to be included and click Add to move them to the Selected 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
    • IsForeclosure (bank owned, 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 list of fields in the Selected column on the right.  Then, click Save in the upper 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 main menu on the upper left and enter your property search criteria as you normally would.  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. Allow your search to run.  Review and select the results to include in your export, click Export, and then use the drop‑down to select Export to CSV.

  4. Use the Spreadsheet drop‑down to select the Titan Analytics template you created in step 4 of Part I above.  Then, click Export on the upper right.

  5. Save the export file to a convenient location such as your Windows desktop so that you can easily retrieve it in Titan Analytics.
    In some cases, data from Paragon exports won't match the template.  Fields are sometimes duplicated or missing, or the header row is shifted over so it doesn't match the columns underneath.  If you have a problem with your export from Paragon, clear your browser cache, close your browser completely, and try again.  Click here for instructions on clearing your cache.

Part III — Import data

That's it!  Your 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