Skip to main content

Free comparative market analysis template for Google Docs

A priced comparison of a subject property against recent comparable sales, generated per property from your sales data.

Free to copy Google Docs PDF export No watermark

Free to copy, no sign-up: the file opens in your own Google Drive. Updated November 13, 2026.

The actual template Free comparative market analysis template for Google Docs: preview of the first page

What’s in the comparative market analysis template

Every block has a placeholder showing where your details go. Type over them by hand, or bind each one to a field in your data and let it fill itself.

  • Subject property summary and prepared-for line {{subject.address}} · {{client.name}}
  • Comparable sales table, one row per property loop: {{comparables}}
  • Adjustments made to each comparable loop: {{comparables.adjustments}}
  • Price per square foot and range {{analysis.psf}} · {{analysis.range}}
  • Market conditions and time on market {{market.days_on_market}}
  • Recommended asking price and reasoning {{recommendation.price}}
  • Preparer, date and sources {{agent.name}} · {{prepared_on}}

How to use this comparative market analysis template in Google Docs

  1. 01

    Copy the template to your Google Drive

    Press "Copy to my Google Docs". Google asks to make a copy, and the copy is yours to edit; the original is never changed. All you need is a free Google account.

  2. 02

    Replace the placeholders with your details

    Text in double braces, like {{subject.address}}, marks where your own values go. Work down the page: subject property summary and prepared-for line; comparable sales table, one row per property; adjustments made to each comparable, and so on.

  3. 03

    Make it match your brand

    Swap the logo, colours and fonts in Google Docs as you would in any document. The layout is built to hold when the text changes.

  4. 04

    Download it as a PDF, or share the link

    File, then Download, then PDF Document gives you a file to send or print. Download as Word (.docx) works too if someone needs it.

  5. 05

    Making these regularly? Fill it from your data

    Connect Airtable, Google Sheets or a CSV to SourceToDocs and it fills a copy of this template for every row, so you stop retyping.

A comparative market analysis argues a price. It puts a subject property next to recent sales that are genuinely like it, shows the adjustments made for size, condition and date, and lands on a recommended figure a seller can follow. The evidence is the document, so its length depends on how many comparables the market gives you, which is what Docs handles and a fixed slide layout does not.

Choosing the comparables in the data

The selection rules belong in the query, not in the writing. Set the radius, the property type, the size band and how far back a sale still counts, then let the run pull whatever matches and repeat a row for each. When a property has too few comparables the document shows that rather than hiding it behind three cherry-picked sales. Keep the adjustment for each comparable in a field beside it, so the reasoning travels with the number and the same house priced twice gives the same answer.

Fill this comparative market analysis template from Airtable, Google Sheets or a CSV

Connect an Airtable base, a Google Sheets spreadsheet or a CSV file, map each field to a placeholder, and generate. One run can produce a single document or one per matching row, delivered to your Google Drive.

Real estate: A priced comparison of a subject property against recent comparable sales, generated per property from your sales data.

Comparable sales · Google Sheets

AddressSoldPrice
19 Kestrel RowJul 2026£528,000
4 Priory CloseJun 2026£511,500
27 Bramble WayMay 2026£549,000

Template: Google Slides or Docs

{{subject.address}}

Comparative market analysis · {{prepared_on}}

loop: {{comparables}} → row

{{analysis.range}} range

{{recommendation.price}} recommended

one analysis per subject property; the table repeats a row per comparable

Generated output

DocsPDF

22 Kestrel Row

Comparative market analysis · 4 Sep 2026

6 comparables listed

£505,000–£555,000 range

£540,000 recommended

Who uses this comparative market analysis template

Listing agents

Back a suggested asking price with the sales that support it, prepared before the valuation appointment.

Read the guide

Brokerage and valuation teams

Keep every analysis in the same structure so two agents pricing similar homes show their working the same way.

Read the guide

Investors and buying agents

Produce a written comparison per property under consideration from the sales data you already pull.

Read the guide

Common questions, answered

Why is a CMA a Google Doc rather than a deck? +
Because the number of comparables varies. A rural property might have three defensible sales to point at and a city block twelve, and the adjustments written against each one are not the same length either. In Docs the table repeats a row per comparable and the pages break themselves; on a slide you would be cutting evidence to fit.
Where do the comparable sales come from? +
From wherever you hold them: Airtable, Google Sheets or a CSV export from your data provider. The document places the sold prices, dates and adjustments you supply. It reports your analysis rather than producing a valuation of its own.
Can I use our own CMA format? +
Yes. Build the master in Google Docs with your column order, adjustment grid and disclaimers, mark the comparables as a repeating row and the subject details as placeholders, and generate against that. Firms with a required format keep it exactly.
Can I prepare an analysis for several properties in one run? +
Yes. Filter to the subject properties you are pricing this week and one run produces an analysis per property, each pulling only the comparables matched to it. Nested loops handle the adjustments listed beneath each comparable, so a property with twelve sales and one with three both come out correctly laid out.
Is this comparative market analysis template free? +
Yes. Copy it to your own Google Drive at no cost and with no sign-up, then edit it like any Google Docs file. You only need SourceToDocs if you want it filled from your data automatically, and that has a free plan too.
Can I download this comparative market analysis template as a PDF or Word file? +
Yes. Open your copy in Google Docs and choose File, Download. PDF Document gives a print-ready file; Microsoft Word (.docx) gives an editable one for people who do not use Google Docs.

Generate this document from your data

Start on the free plan, connect Airtable, Google Sheets or a CSV, and export a real Google Docs file. No watermark, no credit card.