Importing it
1. Open Properties and choose Import.
2. Drop the Excel or CSV file on the page, or click to choose it. Or copy the rows in your spreadsheet and paste them in the box below.
3. If the workbook has several sheets, choose the one with your properties under Sheet. Hidden sheets are left out.
4. Check the preview: how many properties, tenants and rooms it found, any row with a problem and why, and any column it did not recognise.
5. Confirm to bring them in.
What it reads
Dates as Excel stores them, merged cells such as an address over an HMO’s room rows, and formulas as the value Excel last saved. Your column headings are matched by their words, not their order.
Sizes
- A workbook up to 5 MB, or a CSV up to 2 MB
- Up to 500 rows at a time. Split a bigger sheet and import it in parts
Files it cannot read as they are
- This looks like an older Excel file (.xls), or a workbook with a password on it. In Excel choose File, then Save As, then Excel Workbook (.xlsx), and upload that copy.
- This is a Numbers file. In Numbers choose File, then Export To, then Excel, and upload that copy.
- This is an OpenDocument spreadsheet. Save a copy as Excel Workbook (.xlsx) or as CSV, and upload that.