- Register with LINZ https://data.linz.govt.nz/
- Obtain an API key http://www.linz.govt.nz/data/linz-data-service/guides-and-documentation/creating-an-api-key
- Apply for restricted owner information datasets
- Download LINZExcel.bas from https://raw.githubusercontent.com/localgovernment/LINZExcel/master/LINZExcel.bas
- Create a new Excel spreadsheet
- Press ALT+F11
- Press CTRL+M and import the LINZExcel.bas file
- Open the LINZExcel module
- Near the top of the code, find 'Public Const key as String = "my LINZ API key"' and replace key string with your LINZ api key
- Close VBA for applications
- Creat a button in a worksheet and assign it to the GetTitleInformation macro. See here.
- Save as an 'Excel Macro-Enabled Workbook' (.xlsm)
- Enter valid titles into a column within the same worksheet as the button created during setup
- Select the titles you want to process
- Click the button
- After a few seconds the following worksheets will be created and populated with data: PropertyTitlesList, PropertyTitleEstatesList, PropertyTitleOwnersList, TitleMemorialsList, TitleParcelAssociationList
- The data received from LINZ is not ordered. You'll need to use the Filter/Sort features of Excel to make sense of the results.