Upload stands from a spreadsheet

When you need this

When you start on EstateKeeper and have the stand register in a spreadsheet. One upload adds every stand, its premise, and, where you fill in a buyer, the owner linked to the stand. Up to 1,000 stands per file.

Steps

1. Open Stands in the menu and press Upload. The page is headed Upload Stands.

2. Press Download template. It downloads stands-upload-template.xlsx, with the column headings and one sample row.

3. Fill in one row per stand. Keep the headings exactly as they are, and delete the sample row.

   Column	What to type
   STAND_NUMBER	Needed. The stand's number. No two rows can have the same number
   STAND_SIZE	The area in square metres, for example 510.50
   USE	One of RESIDENTIAL, FLATS, CLINIC, SCHOOL, CRECHE, COMMERCIAL, SHOPPING_MALL, FILLING_STATION, PARKING, FUNCTION_VENUE, SERVICE_INDUSTRIAL, OPEN_SPACE, ROAD_RESERVE, OTHER
   STATUS	AVAILABLE, SOLD or RESERVED. Empty, or -, means AVAILABLE
   LEVEL_OF_DEVELOPMENT	VACANT, UNDER_CONSTRUCTION or COMPLETED
   DATE_OF_PURCHASE	The day the owner bought the stand, as 2026-05-23. Only with a buyer
   BUYER	The owner's name, or the company's. Leave it empty for an unsold stand or a road reserve
   BUYER_TYPE	INDIVIDUAL or COMPANY. Needed when there is a buyer
   NATIONAL_ID	A person's ID or passport number
   COMPANY_REG_NUMBER	A company's registration number
   TELEPHONE_NUMBER	The owner's phone, for example +263772278164
   PHONE_COUNTRY_CODE	The phone's country, for example ZW. Empty means the estate's own country
   EMAIL_ADDRESS	The owner's email

   An owner with several stands: type the same NATIONAL_ID (or COMPANY_REG_NUMBER) on each of their rows. They are added once and linked to every one of those stands.

4. Save the file as Excel (.xlsx).

5. Under Upload File, choose the file, then press Upload. It says Processing... while it works.

What you should see

• A green Success! message.
• Every stand in the Stands list, and its premise under Premises.
• Where you filled in a buyer, the owner on the stand's page (the star beside their name) and on its Residents tab, as Owner, from the DATE_OF_PURCHASE.

If something goes wrong

The upload is all or nothing: if any row has a problem, nothing is added. Fix the file and upload it again.

• "Please fix the following and re-upload:", with a table of Row, Column and Problem: each line says what is wrong. For example:
  • is required: STAND_NUMBER is empty, or a row has a buyer but no BUYER_TYPE.
  • must be a number: STAND_SIZE has letters or units in it. Type only the number.
  • must be one of …: a USE, STATUS, LEVEL_OF_DEVELOPMENT or BUYER_TYPE isn't spelled as in the table above.
  • must be yyyy-MM-dd: type the date as 2026-05-23.
  • duplicates an earlier row in this file: the same stand number is on two rows.
  • is required when NATIONAL_ID / COMPANY_REG_NUMBER / TELEPHONE_NUMBER / …: a row has an owner's details but no BUYER name.
• A red message naming a row, for example a stand number already on the register or a phone number already used by someone else: correct or remove that row and upload again.
• "Could not download template. Please try again.": check your connection and press Download template again.
• Upload is missing on Stands: your role can't add stands. Ask the estate's owner.