Skip to content
Nabeeh Nabeeh Help Center Open the app

Import properties

Add many properties — buildings, floors and units under them — or update the ones you have, from an Excel file in the Import & Export Center: the template, the parent row, updates from an export, branches and rows with errors.

Use this import to add many properties at once, with the floors and units inside them, or to change the properties you already have from an exported file.

Where to start

  • On Properties, open Property Settings and select Bulk Import Properties, or
  • open the Import & Export Center and select Import on the Properties row.

Import shows to whoever may import properties. The import then follows the steps in Import your data: file, review, import and result.

Note: Bulk Import Properties now opens this import screen instead of the bulk import page you already know; a batch you had already started on that page stays open for 30 days so you can finish it: reach it from Property Settings › Continue the open import batch, or, while your account has no property yet, from the Continue the open import batch button on the properties page itself. After 30 days the batch page takes you to the new import screen with a message explaining why; the batch's rows are not carried over.

Fill in the template

Select Download template. The Properties sheet has the columns you know: Property Name, Follows Row Number, Access Code, City, Address, Property Type, Unit Type, Map URL, Longitude, Latitude, Supervisor, Customer, the three temporary contact columns and Branch. Columns marked with * are needed on every new property, and the drop-down lists hold your account's values. Files made from the old template, with or without the Branch column, are read the same way. Save the file as .xlsx.

  • Follows Row Number: leave it empty for a top-level property. For a property inside another one, enter the row number of the parent property in this file; row 2 is the first property under the headers. The parent row can come before or after it: parents are always imported first. The parent's type must accept the child — a unit cannot hold a floor, for example.
  • Unit Type is needed only when the Property Type is Unit. A unit already saved without a unit type keeps it empty when you leave the cell empty.
  • Longitude and Latitude win over the Map URL. Use a full Google Maps link: a short link such as maps.app.goo.gl cannot be read, so the row imports without a map point and shows a warning. A new property inside another one, without coordinates, takes its parent's address and map point.
  • Supervisor: one or more supervisor names, separated by commas. Customer: pick the customer from the list. If two supervisors or two customers in your account share a name, a name alone does not tell them apart and the row stops: pick the customer with its mobile number, and for supervisors leave the cell as exported (or empty) to keep the current ones.
  • Country Code is needed with a temporary contact number, for example +966 and 512345678.
  • Branch (accounts with branches): leave it empty to add a top-level property to the branch you choose when you upload the file; a property inside another one goes to its parent's branch. A branch name adds it to that branch; an unknown name, or a branch you are not assigned to, stops that row only.

If a row cannot be imported, the rows that follow it cannot either: they show “The parent property was not imported”. Fix the parent row, then import its rows again.

Change properties you already have

  1. On Properties, open Property Settings, select Export Properties and download the file (see Export your data). Its first column, Property ID (do not edit), ties each row to its property.
  2. Edit the cells you want to change. An empty cell keeps the current value; type [CLEAR] to empty a field. The name, the type and the city cannot be emptied.
  3. Import the file. Rows you did not change are shown as No change and nothing is written for them.

In Follows Row Number, an empty cell keeps the property where it is and [CLEAR] moves it to the top level. To put a property under one that is not in the file, enter that property's ID instead of a row number. Updating properties needs the permission to edit them; without it the import only adds new properties and leaves the exported rows out.

Tip: A new row without an ID whose name matches a property under the same parent is still added as a new property, with a warning that names the property it matches. To update that property instead, select Switch to update under the message, or Switch all matching rows to update.

After the import

The result lists the properties created and updated. Select Show them in Properties to open the list on this import's properties only, at every level; Show all brings the whole list back. Download the error file to fix the remaining rows and import them again: in it, Follows Row Number points to the parent's new row, or holds the parent's ID when the parent was already imported, so the file imports back as it is. When the parent row is in neither place, for example you deleted it from the draft, the cell reads "Row 5 of the original file": that row is not imported until you enter its parent's row number or ID.

What's next