Feature · Getting started

Leave Excel behind without typing it all again

You upload the Excel or CSV sheet you already have, with your own column headings, and confirm which column is which. Before saving, RendaOK shows what will happen, and everything the import changes is logged.

  • On the Essencial, Pro and Agency plans
  • Your sheet, with your own headings
  • Simulation before saving

The app's screens are still in Portuguese: next to each screen or button we show its Portuguese name.

The essentials

  1. 01

    The sheet you already have

    We match the columns in your file to RendaOK's fields by their headings (address, owner, tenant, amount, start date…) and you correct anything that is wrong. We open the sheet with the most rows (you can pick another) and skip any title rows above the data.

  2. 02

    Everything on one row

    One row per property, with the landlord, the tenant and the lease. With several co-owners, you repeat the row with the same reference and each owner's share.

  3. 03

    See it before saving

    The simulation shows the new properties and the ones that already exist, the new and updated leases, and the errors on each row. It changes nothing.

  4. 04

    You choose how to import

    Add and update, without archiving anything, or replace your whole portfolio. And you decide whether what is already in RendaOK wins or what comes from Excel.

  5. 05

    Nothing is lost

    Everything the import changes is logged with the previous values. Receipts already issued are never deleted.

How it works

In 6 steps

  1. Export your sheet

    Use the sheet where you already keep your properties, or export from your current software to Excel or CSV. If you are starting from scratch, there is a template to download in Import data (Importar dados).

  2. Check the essentials

    Address and town are required (with no town column, we use whatever comes after the postcode or the last comma of the address). To create the lease, add the tenant's name, the rent and the start date. Dates as dd/mm/yyyy.

  3. Confirm the columns

    Upload the .xlsx, .xls or .csv file and see which column of your file was matched to each field. Change anything that is wrong; your choice is remembered in this browser for the next import.

  4. Choose the options

    Choose how to import, what to do when something already exists, and how each property is recognised: by its reference or by address and town.

  5. Review the simulation

    The table shows each row and its errors. If there are errors, the button reads "Fix the errors to import" (Corrija os erros para importar). With no errors, you see a summary of what will happen.

  6. Import

    Click Import (Importar). To replace your portfolio, type SUBSTITUIR (Portuguese for "replace") to confirm.

In detail

Good to know

An empty cell never deletes

With Keep RendaOK's data (Manter os dados do RendaOK), the file only fills in empty fields. With Use the Excel data (Usar os dados do Excel), the file wins, but an empty cell does not delete what you already have.

Leases already running

You can also update the rent, the payment day, the end date and the deposit of leases already running. The start date and the tenant never change through an import.

Past rents

Rents before the date you enter are recorded as paid, with no receipt issued in RendaOK. If you untick this month's rents that are already due, confirm the paid ones today; otherwise, the next day, the first late-rent notice goes to the tenant.

Replacing the portfolio

Properties that are not in the file are archived, not deleted, and their active leases end today. You choose whether unpaid rents already due stay as debt or are cancelled.

No surprises

The law and the limits

What it does not do

  • It does not read data straight from another program: you export from there to Excel or CSV and upload the file.
  • One column maps to one field only: if the address and the town are in the same column, the town is taken from the end of the address.
  • It does not issue receipts for past rents: they are recorded as paid. Those from the month you created your account onwards can be issued in Receipts (Recibos) → To issue (Por emitir).
  • The same address with a different reference does not create a second property: the row is skipped, with a note.
  • Properties above your plan's limit are recorded without an active lease, with a note.

For information only; it does not replace professional advice.

Plans

Which plan includes it

FeatureFreeEssencialProAgency
Data import (CSV or Excel)—✓✓✓

Details and prices under Pricing.

Go further

Tools, templates and guides

Frequently asked questions

Can I try it without breaking anything?

Yes. The simulation appears before saving and changes nothing.

Does an empty cell delete data I already have?

No. An empty cell never deletes.

I imported past rents. Will receipts be sent?

No. Those before the date you entered are recorded as paid, with no receipt issued in RendaOK. Those from the month you created your account onwards appear in Receipts (Recibos) → To issue (Por emitir), if you have not already issued a receipt outside RendaOK.

If I choose Replace, do I lose properties?

Nothing is lost: those not in the file are archived and their active leases end today.

Try it

See it working with your own properties.

Try 60 days free →
60 days free, no card.

Reviewed on 3 November 2026.