Rightmove to Spreadsheet: The Complete Guide

Rightmove is where most UK property searches start — but it's designed for browsing, not analysis. You can't sort 50 listings by price-per-sqft, you can't filter by council tax band, and you can't share a clean comparison table with your partner or mortgage broker. For all of that, you need the data in a spreadsheet.

This guide covers everything you need to know about getting Rightmove listings into a spreadsheet — whether you use Microsoft Excel, Google Sheets, Apple Numbers, or any other tool. We'll cover which format to choose, what data you can extract, and how to make the most of it once it's in your spreadsheet.

The quick version

Which format should you use?

The extension supports four export formats. Here's when to use each:

If you're not sure, start with CSV — it works everywhere and is the easiest to import into Google Sheets.

Opening the CSV in Google Sheets

Google Sheets doesn't open CSV files directly from your downloads — you need to import it. Open Google Sheets, create a new blank spreadsheet, go to File → Import → Upload, drag in the CSV file, and choose "Replace spreadsheet" with comma as the separator. The data will populate with all columns and rows, ready to work with.

The extension uses UTF-8 encoding with proper CSV escaping (quoted fields, escaped commas), so special characters like £ signs and accented letters display correctly.

Opening the XLSX in Excel

If you chose the XLSX format, just double-click the downloaded file and it opens directly in Excel. No import steps, no encoding issues, no fiddling with delimiters. The columns are pre-sized and the data is formatted as a proper Excel table.

All available data fields

Here's everything you can include in your export. Basic scan fields come from the search results page. Deep Scrape fields require visiting each individual listing page (takes a few extra seconds).

What to do with the data once it's in your spreadsheet

Sort by price per sqft to find value

If you've used Deep Scrape, the price-per-sqft column is your best friend. Sort ascending to find the properties offering the most space for the money. This is one of the most effective ways to spot undervalued listings that don't stand out on Rightmove's default sorting.

Filter by postcode or area

Use the postcode column to filter by specific areas. In Excel or Google Sheets, apply a filter and type "SW11" to see only Battersea properties, or "N1" for Islington. This is much faster than re-running searches on Rightmove.

Create a shortlist with conditional formatting

Highlight the price column in green for anything under your budget, and red for over. Add a column for your own notes — "loved the kitchen", "too far from station", "needs work" — and you have a proper decision-making tool.

Build a rental yield calculator

For investors: export a for-sale search, then export a for-rent search in the same area. Match properties by type and bedrooms, and calculate gross yield as (annual rent / purchase price) × 100. The numeric price column makes this calculation straightforward.

Track changes over time

Export the same search weekly. Use VLOOKUP or INDEX/MATCH on the listing URL column to compare prices across weeks. You'll quickly see which properties are sitting, which are being reduced, and which have gone (sold or withdrawn).

Free tier vs Pro

The free tier gives you 3 exports per day with up to 20 saved properties and 1 watched search alert. This is enough for most individual buyers and renters. The Pro tier removes all limits, adds multi-page export (export hundreds of listings across all pages in one go), and unlimited saved properties and watched searches.