---
title: "Import Real Estate Listings into WordPress from a CSV File"
url: "https://wpimportexport.com/import-real-estate-listings-wordpress-csv/"
description: "Import property listings from a CSV into a custom post type with ACF price and room fields, photos from URLs, a gallery and a status, then update prices."
type: post
published: 2026-11-19T17:00:00+00:00
modified: 2026-11-14T10:46:00+00:00
categories: ["Import Guides", "Tutorials"]
tags: ["CSV import", "Import Export by RockStarLab"]
docs_topics: ["Import guides"]
---

# Import Real Estate Listings into WordPress from a CSV File

Estate agents usually keep their listings in a spreadsheet or get them from a CRM as a CSV file: address, price, bedrooms, a status like For Sale or Sold, and links to the photos. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) PRO you can import that file into a Properties post type, with the details in ACF fields, a featured image and a photo gallery downloaded from the links, and update prices and statuses later from a smaller file. The example has four listings.

**PRO:** import into a custom post type. **Free:** the same import into posts or pages, with ACF fields, featured images and categories.

## Short Answer

- Set up a **Properties** post type, a **Listing Status** taxonomy and ACF fields (price, bedrooms, bathrooms, floor area, address, gallery).
- Name the CSV columns after the fields (`price`, `bedrooms`, `featured_image`, `gallery`…) and **Auto Map** maps them; put image URLs in `featured_image` and comma-separated URLs in `gallery`.
- For price and status changes, import a file with just the title, price and status, matched by Title.

## The listings file

We used ACF to create the post type `property`, a taxonomy `property_status` and a field group with Price, Bedrooms, Bathrooms and Floor area (number fields), Address (text) and Gallery (ACF gallery). The CSV had one row per property; the photos were on the agency’s website and linked by URL:

![Listings CSV with title, status, price, bedrooms, bathrooms, floor area, address, featured_image and gallery URLs for four properties](https://wpimportexport.com/wp-content/uploads/2026/11/01-listings-csv-scaled.webp)

_One row per property, photos linked by URL._

## 1. Map the columns

In **Import**, choose **Custom Post Types**, upload the CSV and choose **Properties** on the mapping step. **Auto Map** mapped 10 of the 11 columns by name: title, content, status, `featured_image`, and price, bedrooms, bathrooms, floor area, address and gallery to the ACF fields. For the listing status, add the taxonomy `property_status` with **Taxonomy + Add**, match terms by name and drag `listing_status` onto it:

![Mapping step for the Properties post type: 11 of 11 fields mapped, listing_status to the property_status taxonomy](https://wpimportexport.com/wp-content/uploads/2026/11/02-mapping-2-scaled.webp)

_Auto Map maps the columns named after the fields; add the status taxonomy._

Name the status column something other than `status` or `post_status`, so it isn’t mapped to the WordPress post status.

## 2. Import

The import created 4 properties in 5 seconds:

![Import Completed Successfully: 4 created, 0 failed, 5 seconds](https://wpimportexport.com/wp-content/uploads/2026/11/03-result-3.webp)

_Four properties created with photos and details._

Each property had its price and room counts in the ACF fields, the address, the status term (For Sale or Under Offer), a featured image and a gallery with two photos. The plugin downloaded the photos into the Media Library; the first photo of each listing was used both as the featured image and in the gallery, without a second copy. On the site, the Properties archive showed the listings with their photos and status:

![Properties archive on the site: Townhouse on Park Road For Sale and Stone Cottage on Mill Lane Sold, with their photos](https://wpimportexport.com/wp-content/uploads/2026/11/05-archive.webp)

_The listings on the site with their status and photos._

## 3. Update prices and statuses

A week later the cottage was sold for £305,000 and the townhouse price dropped to £439,000. We imported a file with three columns, `post_title`, `listing_status` and `price`, with **Check for Existing Items by Field** set to Title and Update for matches:

![Import Completed Successfully: 2 updated, 0 created](https://wpimportexport.com/wp-content/uploads/2026/11/04-update-result.webp)

_A small file updates prices and statuses._

2 properties were updated. The cottage’s status changed from Under Offer to Sold (the old term was replaced, not added to), and both prices changed. Bedrooms, photos and the gallery stayed as they were, because they weren’t in the file.

## Before you import

Try the file on a staging site first, and [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before importing many listings. The photo links must be reachable from your site during the import. Matching by title works when every listing has a unique title; if two listings can share a title, add a reference number field and match by that.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can check the imported listings:

```
List the properties with price, bedrooms and featured image.
```

In our run, the agent called `rsl-ie-pro/export-preview` for the post type `property` with the fields title, `acf_price`, `acf_bedrooms` and `featured_image_url`. It returned the four listings, including the cottage at 305000 and the townhouse at 439000, each with a featured image in the site’s Media Library.

## FAQ

### How do I import several photos per property?

Put the photo URLs in one cell, separated by commas, and map the column to an ACF gallery field. In our test each gallery got both photos.

### Are photos downloaded twice when they are both featured image and in the gallery?

No. In our test the same photo was used for both, with one copy in the Media Library.

### Can I mark properties as sold with an import?

Yes. Import the title and the new status; the status term is replaced.

### Do I need PRO?

For a custom post type like Properties, yes. Into posts or pages the same import works in the free plugin.

## Related Guides

- [Build a Directory in WordPress from a CSV File](https://wpimportexport.com/build-wordpress-directory-from-csv/)
- [Import an XML Feed into a Custom Post Type with ACF Fields](https://wpimportexport.com/import-xml-feed-custom-post-type-wordpress/)
- [Set Featured Images in Bulk from a CSV File](https://wpimportexport.com/set-featured-images-bulk-csv-wordpress/)
- [Bulk Import Images from URLs into the WordPress Media Library](https://wpimportexport.com/bulk-import-images-from-urls-wordpress-media-library/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
