Import, export and bulk-update your rentals (JSON, Excel)

• the rental: name, residence, address, country, currency, GPS coordinates, ownership share, dates;
• the buildings (type, floor height) and the lessor's details;
• the units: title, floor, unit type, rental type (unfurnished, furnished, flatshare, seasonal), rent and charges, places, deposit, due day, description, energy diagnostics, accountant, platforms (Airbnb, Booking…) and seasonal terms (nightly price, minimum stay, times…);
• for each unit, its rooms (type, area, description, flatshare place);
• for each room, its equipment (type, quantity, description).

Not imported: tenants, payments, contracts and supporting documents (personal data: create them in the console), photos and floor plans.

{
  "format": "smartlife-location",
  "version": 1,
  "location": { "name": "…", "country": "FR", "currency": "EUR", … },
  "buildings": [
    { "name": "Building A",
      "lots": [
        { "title": "1BR first floor", "reference": "A-T2-1A", "flat_type": 4, "rental_type": 10, "rent_amount": 650,
          "rooms": [
            { "name": "Living room", "type": 1,
              "equipments": [ { "type": 5, "quantity": 1 } ] }
          ] }
      ] }
  ]
}

format and version are mandatory. A seasonal rental (rental_type 100) uses the seasonal block instead of the rent. For a flatshare, places is the number of flatmates and flatshare_place ties a room to a place (0 = shared room).

A unit that has already been imported is never imported twice. If a reference in the file matches a unit that was already imported and still exists, the file is rejected with the list of units concerned: remove them, or give a new reference if it is a different property. A unit you have deleted since can be imported again. Two imports started at the same time (double click, two tabs) are also blocked.

The import window shows a Your plan box listing what is and is not included: JSON import, Excel import (from Standard), units per rental, rentals still available, along with the plan that lifts each limit. Options that are not included are marked Not included.

• The project_id, archi_id, lot_id and room_id columns identify what exists: do not change them.
• A unit row without lot_id is a new unit; if its reference already matches a unit of the rental, that unit is updated. A new room with the same name and type as an existing room updates it instead of duplicating it. Re-importing the same file twice therefore creates nothing more.
• The import never deletes anything: tenants, payments, photos, plans and contracts are kept. It does not change the rental type of an existing unit either, nor the fields of the Location sheet (informational). To delete or clear a field, use the console.
• A row of the Location sheet without project_id creates a new rental.
• Only your own rentals are exported and updated; exports are limited to 20 per hour.

Error workbook: if an Excel workbook contains errors, nothing is imported and you can download your workbook with an “Erreurs” column on each affected row, plus an Rapport d'erreurs sheet. Fix it and re-import it (the file stays available for an hour).

Protection and checks: in the provided workbooks, headers are frozen and protected (no password: Review > Unprotect Sheet if needed), the Aide and Références sheets are locked, and numbers are checked as you type (positive rent, due day from 1 to 28, deposit from 1 to 12 months, etc.).

To protect the platform, the number of actions is limited per account and per hour: 10 imports, 60 checks and 20 exports.

• Invalid JSON: extra or missing comma, straight quotes are required (not “ ” or « »).
• Unknown type: use the numbers from the references section (JSON) or the Références sheet (Excel).
• Unknown field or column: a misspelled name is rejected rather than ignored.
• Missing or duplicate reference: each unit has a unique reference.
• Unit already imported: remove it from the file (see the import history).
• seasonal required: a rental_type 100 unit needs day_price and max_adults (columns seasonal_day_price and seasonal_max_adults in Excel).
• Excel: dates as YYYY-MM-DD, yes/no for true/false cells, a room reference (room) filled in as soon as the room has equipment.
• Plan: JSON is locked on the Free plan, Excel on the Free and Starter plans: change your plan.