Upload Data Files
Upload CSV Files
Expected CSV Format
Required columns: address,postcode,landlord_name
Optional columns: landlord_email,landlord_phone,property_type,bedrooms,bathrooms,has_gas,is_furnished,notes
Example:
address,postcode,landlord_name,landlord_email,landlord_phone,property_type,bedrooms,bathrooms,has_gas,is_furnished,notes 123 Main Street,W1A 1AA,John Smith,john.smith@example.com,07700 900123,house,3,2,true,false,Nice garden with shed 45 High Street,E1 6BT,ABC Properties Ltd,info@abcproperties.com,020 1234 5678,flat,2,1,true,true,Modern apartment
Required columns: address,postcode,landlord_id
Optional columns: has_gas,is_furnished,property_type,bedrooms,bathrooms,notes
Example:
address,postcode,landlord_id,has_gas,is_furnished,property_type,bedrooms,bathrooms,notes 123 Main St,AB12 3CD,1,true,false,house,3,1,Nice garden 45 High Street,EF67 8GH,2,true,true,flat,2,1,City center
Required columns: name
Optional columns: email,phone
Example:
name,email,phone John Smith,john@example.com,07700 900123 Jane Doe,jane@example.com,07700 900456
Required columns: property_address,inspection_date
Optional columns: expiry_date,certificate_number,engineer_name,notes
Example:
property_address,inspection_date,expiry_date,certificate_number,engineer_name,notes 123 Main Street,01/01/2025,01/01/2026,GS12345,John Engineer,Annual check complete 45 High Street,15/02/2025,15/02/2026,GS67890,Sarah Engineer,All appliances tested
Required columns: property_address,date_issued,amount
Optional columns: due_date,description,status
Example:
property_address,date_issued,due_date,amount,description,status 123 Main Street,01/01/2025,01/02/2025,150.00,Gas safety certificate renewal,unpaid 45 High Street,15/02/2025,15/03/2025,200.00,Property management fee Q1,paid
Required columns: property_address,date_issued,amount
Optional columns: valid_until,description,status
Example:
property_address,date_issued,valid_until,amount,description,status 123 Main Street,01/01/2025,01/04/2025,500.00,Boiler replacement,pending 45 High Street,15/02/2025,15/05/2025,350.00,Kitchen repairs,accepted