Address Validation and Cleansing


Improve data quality by matching, validating and cleaning your NZ customer addresses

Why is address validation/cleansing important?

Accurate address data is critical to fulfil orders and to make valid business decisions based on reliable data.

Match, clean and recover incomplete, incorrect and improperly formatted addresses with the one-click Addy cleanse excel spreadsheet.

Advanced fuzzy address matching techniques are used for achieving high address classification accuracy even when spelling mistakes or incorrect postal codes, suburbs or incomplete data exist in your database.

Poor address data quality can be prevented by providing users with predictive search-as-you-type address suggestion software. Use our address autocomplete plugin on your website or app to validate addresses in real-time against official NZ Post address datasets.

1,500 FREE validated addresses per month. Need more? Just pay as you go for extras.

Four steps to improve your address data quality

Do you have an existing data set with a mix of partial, incomplete and complete addresses? Download the address cleaning spreadsheet template to perform bulk verification of your addresses.

The excel spreadsheet will call Addy's Address Verification API with the address record and provide the full address details in return.

Download Addy Cleanse for Excel

Step 1 - Enable Content

Enable the content (Enable Macros) in Excel as shown below.

Enable content for Excel address validation

Step 2 - Add Your Addy Key

Add your Addy Address API key in cell B2 as shown below.

Addy Address API Key

Get started with a free account to get your API key

Step 3 - Add Addresses To Verify / Cleanse

Enter or Copy & Paste your address records into Excel as shown below.

Address Entry in Excel

Note: You can type in the entire address in "Input Field 1" or split it up into several "Input Field" columns.

Step 4 - Match and Clean

Click the 'Match' button as shown below to match and clean all of the addresses.

Address Matching Results in Excel

The cleaned and matched address results are displayed in the columns on the right to include the Suburb, City and Postcode.

Output Address Fields


The table below describe each column in the excel spreadsheet. To find a complete description of all the fields, see the response properties for the Address Details API.

Cell B2 is where you can enter your Address API key.


Column Type Description Example
Unique ID input (Optional) An optional ID field to map the address with your internal database ID 1234
Input Field 1 input (Mandatory) Address Field or Column 1 in your database Floor 2
Input Field 2 input (Optional) Address Field or Column 2 in your database 1 Blair Street
Input Field 3 input (Optional) Address Field or Column 3 in your database Te Aro
Input Field 4 input (Optional) Address Field or Column 4 in your database Wellington 6011
Address Suggestions output Holds a drop-down list of alternative address matches List of Addresses
Matches output Holds the total number of alternative matches available 11
Display Line output Holds the single line address display name Floor 2, 1 Blair Street
Street output Holds the name and type of the street Blair Street
Suburb output Holds the name applied to a group of geographically associated streets Te Aro
City output Holds the name of the Town/City provided by Land Information New Zealand (LINZ) Wellington
Mailtown output Holds the name of the Town/City/Mailtown associated with this delivery point Wellington
Postcode output Holds the four digit code defined by New Zealand Post, which is used to describe the locations linked to sorting zones for mail sorting purposes 0622
X output Holds the longitude coordinates in WGS84 format 174.7835236
Y output Holds the latitude coordinates in WGS84 format -41.29302216
ID output Holds the unique Addy Identifier 2392921
DPID output Holds the unique reference number assigned by NZ Post to each delivery point address 1500136
LINZ ID output Holds the unique reference number assigned by Land Information New Zealand (LINZ) to each street address 25003
Parcel ID output Holds the unique spatial object number representing a land parcel where the postal address resides as assigned by Land Information New Zealand (LINZ) 3757439
Meshblock output Holds the foreign key value to link to census and statistical datasets as assigend by Statistics New Zealand (Stats NZ) 2135700
Number output Holds the base street number. For Rural addresses these are allocated by territorial authorities 1
RD Number output Holds the rural delivery route number
Alpha output Holds the alpha component of a street number B
Unit Type output Holds the category description of a sub-dwelling type within a building of building compiles. This is used in conjunction with the Unit Number address element
Unit Number output Holds the address elements that identifies a specific deliver sub dwelling delivery point within a building or building complex
Floor output Holds the Floor type and identifier in a multi level building Floor 2
Territory output Holds the territorial authority of the address. See districts of NZ< Wellington City
Region output Holds the regional authority of the address. See regions of NZ Wellington
Building output Holds the building property name for a recognised significant building
Type output Holds the type of delivery point (Urban, Rural, PostBox, NonPostal) Urban
Box Bag Number output Holds the PO Box/Private Bag number
Ouput Field 1 output Holds the correctly formatted address in line 1 Floor 2
Output Field 2 output Holds the correctly formatted address in line 2 1 Blair Street
Output Field 3 output Holds the correctly formatted address in line 3 Te Aro
Output Field 4 output Holds the correctly formatted address in line 4 Wellington 6011
Modified output Holds the last modified date of the address 22/01/2018
PAF Source output Holds a flag to state if the address was sourced from the New Zealand Postal Address File (TRUE) or Land Information New Zealand (FALSE) TRUE
Deleted output Holds a flag to state if the address was deleted FALSE
Suggestions reserved Holds the list of Address Suggestions List of Addresses

Address cleansing questions and answers

How can I change the matched address?

Click on the "Address Suggestions" column to see additional address matches. Select a different address in the drop-down to manually validate a different address and to automatically fill in all of the detailed address columns.

Why are there so many matched addresses?

A partial address such as "80 Queen" will match many address because are many possible matches for that partial address such as 80 Queen Charlotte Drive, 80 Queen Road and 80 Queen Street in Auckland Central, Masterton, North Dunedin, Richmond and more.

A partial address with more information such as "80 Queen Charlotte Dr Havelock" will only return a single match, properly formatted and complete with postcode, suburb, city, territory, region and more.

Does the Input Field order matter?

No the order does not matter. The input fields can contain any address segment such as city, street, number or postcode.