How to export data from TheMLS.com / CLAW for Titan Analytics

This document explains how to export data from TheMLS.com / CLAW and create a CSV file for use in the Titan Analytics 1004MC and analytics charts.

Document 3118  ¦  Last updated:  08/15/2017 RR2

Video instructions directly from TheMLS.com / CLAW are available on YouTube.  Click here to watch their video.

To get data from your MLS into Titan Analytics, you first need to set up an export template on your MLS website.  This is a one‑time process — once it's set up, you can simply choose your custom template from a list.  Follow the instructions below to get started.


  1. First, run a search for the properties you want to include in your 1004MC analysis.  Be sure to include Active, Sold, Pending, Withdrawn, and Expired listings going back at least a year.  The 1004MC form uses just one year, but the graphs in Titan Analytics use your whole data set.
  2. Next, click Settings and choose One Line Report.

  3. Then, click Create New.

  4. Select each field you need from the list on the left and click Add.

    At a minimum, add the following fields:

    • MLS #
    • Status
    • Close Date
    • Address
    • City
    • State
    • Zip
    • Living Area Square Feet
    • List Price
    • Sale Price
    • DOM
    • Close Date
    • List Date
    • Sold Date
    • Concessions Amount
    • Sale Type (for foreclosures)

    Some fields are included in the list on the right by default.  If a field isn't pertinent to the 1004MC, and you don't want to include it with your export, select the field and click Remove.  Feel free to select additional fields from the left and add them as needed to determine outliers.

  5. Enter a report name, such as TitanAnalytics, and click Save.

  6. Back at your main search screen, check the box near the top left to select all the properties in the search results.  Then click Export near the top right.
  7. Select the export template you created in step 5 (A).  Then, select the .csv option (B), adjust the file name as needed (C), and click Export again (D).

  8. Depending on your web browser, you may receive a prompt to choose the destination folder, or the file may go straight to your Downloads folder.  Just make note of where it's saved.

That’s all there is to it.  Your data is ready for Titan Analytics.  Next time, you can skip steps 1 - 5 and go straight to the Export button in Step 6 after searching.

Related Links