Guide for landlords

How to move your rental spreadsheets out of Excel

You can move without retyping: the AI import reads your Excel, CSV, PDF, a photo or a pasted table and proposes where everything belongs, and you review it all before it is saved. This guide goes through it in order: how to prepare, what to import first and what to check.

· Written by the AxiRent team

What can be moved?

Properties, tenants, tenancies, meter readings, invoices, expenses, bookings, contractors, inventory and handover instructions. Each kind of record lands in its own place.

How do you prepare?

You do not need to restructure your sheets, only to know where they are:

  1. Gather the files in one place: Excel, CSV, PDF leases or phone photos.
  2. Leave the columns as they are: the system recognises them itself.
  3. If the files are in Google Drive, share the folder or file as “Anyone with the link”, and set it back to “Restricted” once the import is done, since it holds your tenants' details.
  4. If you would rather fill in a clean form, there is a template for every kind of data.

In what order do you import?

Properties first, then tenants, tenancies, readings and invoices. That way every later record finds the property and tenant it belongs to, and the import recognises records that already exist instead of duplicating them.

What do you check before saving?

The recognised rows appear in a preview you can edit, and nothing is saved until you confirm. The preview shows which records will be new and which will update existing ones. Three things are worth a look:

  1. Addresses and flat numbers: the same flat has not appeared twice.
  2. Amounts and dates: the rent and the tenancy start match your file.
  3. Readings: the last reading really is the latest one.

How long does it take?

It depends on the size and state of your files. A large archive is easier in batches: start with one flat, check the result and carry on.

What comes next?

Once the data is in place, switch on what you used to do by hand: tenants send meter readings as a photo, and invoices and reminders go out on their own. Whether switching is worth it at all is covered in Excel or rental management software.

Sources

AxiRent's AI import is described as it is on the day of the check. The Google Drive sharing options are named as they appear in Google Drive's English interface.

Common questions

Do I need to change my spreadsheet's columns?

No. The system recognises the columns itself, and you review the result before saving.

Which files can I upload?

Excel (.xlsx), CSV, PDF, a pasted table or a phone photo. A whole Google Drive folder can be read too.

What if the import gets something wrong?

Correct it in the preview: nothing is saved until you confirm.

Do I pay for the import?

The import is part of every plan, including the free one with a single property.

Rent day without the spreadsheet

One property free, with no card and no time limit.

UAB “Terra IT”, Kaunas, Lithuaniainfo@axirent.com+370 600 06 265Mon–Fri 9:00–18:00 (Vilnius time)