How to import your property portfolio from a spreadsheet
In the Import tab you upload a CSV, XLSX or ODS file, review the columns and see a preview before importing. Photo links are downloaded automatically.
Watch this step in the video · Import your portfolio
Open Real Estate → Import, upload your CSV, XLSX or ODS file, review the columns and check the preview before anything is written. If you import again, properties are updated by reference instead of duplicated.
Step by step
- Open the Import tab. If you don't know which columns to use, click Download sample template.
- Upload your CSV, XLSX or ODS file (up to 20 MB).
- In Review columns, the columns the system recognizes are already assigned. Assign the rest by hand.
- If your file has photo links, tick Download photos that come in as URLs.
- Click See preview: the Preview shows how many properties will be created, how many updated and which ones skipped.
- If everything looks right, click Import now and check the Result.
Columns worth including
| Column (header examples) | What it is for |
|---|---|
| code, reference | The key: if the reference already exists, the property is updated. |
| title | Required. |
| operation | Required: sale, rent, both (Spanish words also work). |
| property_type | Required: house, apartment, land, office, commercial, warehouse. |
| price, rent_price, expenses | Understands 185,000.00 and 185.000,00. |
| bedrooms, bathrooms, parking | Features. |
| city, sector, address | Location. |
| is_listed | yes / no |
| photos | Links separated by |, up to 10 per listing. |
Note: If your file has no reference column, a property is recognized by title, city, area, operation and type. That is less precise: if you change the title, it comes in as a new one. Always include the reference.
Tip: Photos are downloaded in the background. After importing, check the room tag of the photos on each listing so the AI can send "the kitchen".
Keep reading
Related articles
-
Complete guide to the Real Estate module
Turn on Real Estate, tailor it to your agency, add or import your portfolio with photos by room, quote properties and let an AI agent search, send photos and book viewings over chat.
-
How to turn on and set up the Real Estate module
Real Estate is enabled for free from Catalog → Add to catalog. Then, in Settings, you set currency, viewings, reservations, public price, watermark and CRM.
-
How to add a property with photos by room
In Properties → New property you fill in the details, upload several photos at once and tag the room of each one, so the AI sends exactly the kitchen or the living room.
-
How to mark a property as reserved, sold or rented
Edit the property's Status. Sold or rented properties are unpublished automatically, and a reservation expires after the hours set in Settings and goes back to Available.
-
How to quote a property
In Catalog → Quotes → New quote, Pick a product has a Properties tab: pick the property and the line fills in automatically. With the CRM option on, a deal is created.