SELF SERVICE BULK CLEANING GUIDE

Overview

This guide provides detailed step-by-step instructions for using the Addresser self-service bulk address cleansing feature. The service validates and standardises Australian address data against the GNAF (Geocoded National Address File) and Australia Post AMAS guidelines.

The pre-requisite is a subscription to the Business plan from the Addresser pricing page. Flexible pricing options are available starting from 500 lookups per month through to 150,000 lookups per month.

Please note the trial plan (Business 1000 lookups / 30 days) cannot be used for production data cleansing.

1

Sign Up for a Business Plan

Before using the bulk address validation service, you must be registered and subscribed to a Business plan. If you already have an account, skip to Step 2.

  1. Visit pricing.addresser.com.au/pricing and select a Business plan that matches your monthly volume requirements.
  2. Complete the registration process. You will be prompted to create a username and password during sign-up.
  3. Keep your credentials safe — you will use them each time you log in to the Addresser dashboard.
Addresser Business Plan pricing options

Addresser Business Plan pricing options — choose the tier that suits your monthly volume.

✅ Tip Flexible pricing is available from 500 to 150,000 lookups per month. The trial plan (Business 1000 / 30 days) is for evaluation only and cannot be used for production cleansing.
2

Login to the Dashboard

Once registered, use your credentials to log in to the Addresser dashboard where all bulk validation functions are managed.

  1. Go to app.addresser.com.au/signin.
  2. Enter your Username and Password.
  3. Click Login to access the dashboard.
  4. If you have forgotten your password, click Reset Password? on the login page.
Addresser login page

The Addresser secure sign-in page at app.addresser.com.au/signin.

3

Navigate to Bulk Validation

After logging in you will land on the Dashboard showing your usage reports. Navigate to the Bulk Validation feature from the left-hand sidebar.

  1. Locate the left-hand navigation bar.
  2. Click "Bulk Validation".
Dashboard navigation — Bulk Validation highlighted in the left sidebar

Click "Bulk Validation" in the left-hand navigation sidebar.

The Bulk Validation page will load, displaying two tabs at the top: File Upload and Recents.

4

Prepare Your CSV File

The bulk address validation service requires an address file in CSV (Comma Separated Values) format. Preparing your file correctly before uploading will avoid errors.

  • Each record must have the full address stored in a single column and a unique identifier in another column.
  • The file must use UTF-8 encoding.
  • Save the file in .csv format only — Addresser does not accept Excel (.xlsx) files directly.
  • A CSV can be exported from Microsoft Excel using File > Save As > CSV (Comma delimited).
Example CSV file with address data

Example CSV structure: a unique identifier in the first column and the full address in the second column.

⚠ Important — Avoid Commas in Address Fields Ensure your address field does not contain additional commas. This is the most common cause of data format mismatches, where the system cannot correctly align header columns with row data across different records.
5

Upload Your CSV File

From the File Upload tab on the Bulk Validation page, configure your upload settings and select your file.

  1. Click the "Select Plan" dropdown and choose the active Business plan you are subscribed to.
  2. Click the "Add CSV" button to browse and select your CSV file.
  3. Once selected, the system will display the file name, file size, row count, and number of columns. Review these to confirm the file was read correctly.
  4. If your CSV contains a header row, tick the "Has header" checkbox.
  5. Click the "Next" button to proceed to the column selection step.
Bulk Validation upload page showing plan selection and file upload

Select your plan, add the CSV file, confirm the header option, then click Next.

✅ Tip Always verify the row count displayed by the system matches the number of records in your file before clicking Next. This confirms your CSV was parsed correctly.
6

Select the Address Column

After clicking Next, the system advances to Step 2 of the upload wizard. A preview of the first data row from your CSV is shown, with each column listed individually.

  1. Review the sample row to identify which column contains your address data.
  2. Select the column header that corresponds to your address field (e.g. INPUT_ADDRESS). A tick mark will confirm the selection.
  3. Click "Upload" to submit the file for processing.
Column selection step showing sample data row

Step 2 of the upload wizard: select the column containing your address data, then click Upload.

✅ Tip The preview row shows actual data from your file. Use this to verify you are selecting the address column and not the identifier column before submitting.
7

Monitor Batch Status

Once uploaded, the system queues your file for processing. You can track its progress from the Recents tab.

  1. After clicking Upload, the system automatically switches to the Recents tab.
  2. Your file will appear in the list. At this stage its status will be "Submitted".
Recents tab showing newly submitted file

The Recents tab shows your submitted file at the top of the list. The file names have been redacted for privacy.

Shortly after upload you will receive a notification email from Addresser confirming the file was received and is being processed.

Email notification confirming file upload was received

First email notification: confirms your file was uploaded and queued for processing.

When processing is complete, you will receive a second email notification advising the results file is ready to download.

Email notification confirming bulk cleansing is complete

Second email notification: confirms bulk cleansing is complete and the results file is ready.

ℹ Note Processing time depends on the size of your file. Smaller files may complete within minutes, while larger files may take longer. You do not need to stay on the page — the email notification will alert you when the results are ready.
8

Download Your Results File

Once you receive the completion email, return to the Recents tab to download your cleansed address file.

  1. Navigate to Bulk Validation in the left sidebar.
  2. Click the Recents tab at the top of the page.
  3. Locate your file — its status will now show as "Completed".
  4. Click the "Download" button in the Action column next to your file.
Recents tab showing completed file ready for download

The Recents tab showing the processed file with "Completed" status and the Download button available.

✅ Tip If your file status remains "Submitted" for an extended period, refresh the Recents tab. If you have not received an email after a reasonable time, contact Addresser support at info@addresser.com.au.
9

Understanding the Cleansed File Format

The downloaded CSV file contains your original columns plus a comprehensive set of standardised address fields appended by the system. Open it in Microsoft Excel or any CSV viewer to review your results.

Each output column is described in the reference table below.

Column NameDescription
INPUT COLUMNS (from your uploaded file — data unchanged)
CUST_IDYour original record identifier, carried through unchanged.
INPUT_ADDRESSThe original address string from your uploaded file, carried through unchanged.
PARSED & STANDARDISED ADDRESS COMPONENTS
DELIVERY_POINT_IDThe DPID (Delivery Point Identifier) of the validated and matched address. A value of "0" means the address cannot be matched per Australia Post AMAS Guidelines.
FLAT_UNIT_TYPEStandardised flat or unit type (e.g. UNIT, APT, SUITE).
FLAT_UNIT_NBRStandardised flat or unit number.
FLOOR_LEVEL_TYPEStandardised floor level type (e.g. LEVEL, FLOOR).
FLOOR_LEVEL_NBRStandardised floor level number.
LOT_NBRLOT number of the address, if available from GNAF data.
POSTAL_DELIVERY_TYPEStandardised postal delivery type (e.g. PO BOX, LOCKED BAG, GPO BOX).
POSTAL_DELIVERY_NBRPostal delivery number (e.g. the number of the PO Box).
POSTAL_DELIVERY_NBR_PFXStandardised postal delivery number prefix.
POSTAL_DELIVERY_NBR_SFXStandardised postal delivery number suffix.
HOUSE_NBR_1Address house or property number.
HOUSE_NBR_SFX_1Address house or property number suffix (e.g. "A" in 205A).
HOUSE_NBR_2Second house number for ranged addresses (e.g. "12" in 10–12 George St Sydney NSW 2000).
HOUSE_NBR_SFX_2Second house number suffix for ranged addresses.
STREET_NAMEStandardised street name.
STREET_TYPEStandardised street type (e.g. ST, RD, AVE, BLVD).
STREET_SFXStandardised street suffix (e.g. NORTH, EAST).
LOCALITY_NAMEStandardised suburb or locality name.
POSTCODEStandardised postcode.
STATEStandardised state name (e.g. NSW, VIC, QLD).
LONGITUDEAddress longitude coordinate, if available from GNAF data.
LATITUDEAddress latitude coordinate, if available from GNAF data.
FORMATTED OUTPUT FIELDS
FULL_ADDRESSStandardised single-line full address output.
BARCODE_4STATE_NUMBERAustralia Post standard DPID represented in 4-state barcode number format, for mail production use.
ADDRESSLINE_1First line of the formatted multi-line address (typically the unit/flat and street number and street name).
ADDRESSLINE_2Second line of the formatted multi-line address (typically the suburb/locality).
ADDRESSLINE_3Third line of the formatted multi-line address (typically the state and postcode).
ADDRESSLINE_4Fourth line of the formatted multi-line address, populated where an additional line is required.
MATCH & QUALITY FIELDS
CORRECTIONS_APPLIEDDescription of any corrections applied to the supplied address during standardisation.
MATCH_TYPEIndicates whether the match is to a Primary address point (street-level, no specific unit) or a Secondary address point (specific unit, lot, or street number suffix). Match scores and quality thresholds differ between the two types — see the reference tables below.
MATCH_SCORENumeric score reflecting the matching rule applied. Higher scores indicate closer matches. The score range and meaning differs depending on whether the match is Primary or Secondary — see the reference tables below.
MATCH_QUALITYConfidence level derived from the match score and rule applied: High, Medium, or Low. See the reference tables below for the quality assigned to each matching rule.
PRESORT & PRINTSORT FIELDS
PRESORT_PLAN_NUMBERAustralia Post presort plan number assigned to this address, used for bulk mail lodgement and discounted postage rates.
PRESORT_EXPIRY_DATEExpiry date of the presort plan number. Records should be re-validated before this date to maintain presort eligibility.
PRESORT_INDICATORFlag indicating whether this address qualifies for Australia Post presort rates (Y = eligible, N = not eligible).
PRINTSORT_SUB_DIVISION_INDICATORIndicates the PrintSort sub-division classification for this address, used in sequencing mail for print and sort workflows.
PRINTSORT_EXPIRY_DATEExpiry date of the PrintSort sub-division indicator. Addresses should be re-validated before this date for continued PrintSort accuracy.

MATCH_TYPE, MATCH_SCORE & MATCH_QUALITY Reference

The MATCH_TYPE column indicates whether the address was matched to a Primary address point (a street-level address without a specific unit) or a Secondary address point (a specific unit, flat, lot, or sub-address). The match score and quality thresholds vary between these two types — Secondary matches generally achieve higher scores because more address components are available for comparison.

PRIMARY Primary Address Point — MATCH_SCORE & MATCH_QUALITY
Matching Rule Applied MATCH_SCORE MATCH_QUALITY
Exact Match — no corrections applied100High
Misspelt Street Name Rule93High
Misspelt Locality / Synonym Rule95High
Street Alternate Matching (SAM) Rules87High
Street Alternate Matching (SAM) — Misspelt Locality applied70Medium
Street Alternate Matching (SAM) — Locality Synonym applied70Medium
Bordering Locality Matching (BLM)83Medium
Bordering Locality Matching (BLM) — various sub-rules (TB Rule, PPM Rules, Misspelt Locality, Street Type Suffix)70Medium
Combination of Street Alternates & Bordering Localities78Medium
Combination of Street Alternates & Bordering Localities — Misspelt Locality applied70Medium
Combination of Misspelt Street Name and Locality Rule66Medium
All Address Matching Rule70Medium
All Address Matching Rule — Misspelt Locality/Synonym applied70Medium
All Address Matching Rule — TB Rule / Primary Point over Street Type Suffix70Medium
PPM Rule 1 applied75Medium
TB Rule — Locality Synonym over Postcode65Medium
TB Rule — Street Name versus Locality65Medium
Below DPID Matching Rule 130Low
Below DPID Matching Rule 230Low
SECONDARY Secondary Address Point — MATCH_SCORE & MATCH_QUALITY
Matching Rule Applied MATCH_SCORE MATCH_QUALITY
Exact Match — no corrections applied100High
Misspelt Street Name Rule95High
Misspelt Locality / Synonym Rule98High
Street Alternate Matching (SAM) Rules90High
Street Alternate Matching (SAM) — Misspelt Locality applied90High
Street Alternate Matching (SAM) — Locality Synonym applied90High
Bordering Locality Matching (BLM)85–90High
Bordering Locality Matching (BLM) — various sub-rules (TB Rule, PPM Rules, Misspelt Locality, Street Type Suffix, Exact Match)90High
Combination of Street Alternates & Bordering Localities80Medium
Combination of Street Alternates & Bordering Localities — Misspelt Locality applied90High
Combination of Misspelt Street Name and Locality Rule66Medium
All Address Matching Rule90High
All Address Matching Rule — Misspelt Locality/Synonym applied90High
All Address Matching Rule — TB Rule / Primary Point over Street Type Suffix90High
TB Rule — Locality Synonym over Postcode70Medium
TB Rule — Street Name versus Locality70Medium
Misspelt Street Name Rule — PPM Rule 1 applied90High
ℹ Key difference between Primary and Secondary scores Secondary address matching consistently produces higher scores than equivalent Primary rules. For example, a Street Alternate Match on a Primary address scores 87 (High), while the same rule on a Secondary address scores 90 (High). Most BLM and SAM sub-rule combinations score 70 (Medium) for Primary but 90 (High) for Secondary. Always read MATCH_TYPE alongside MATCH_SCORE to correctly interpret confidence.
⚠ Low confidence records Primary addresses matching via Below DPID Matching Rules receive a score of 30 (Low). These records could not be matched to a valid DPID and should be reviewed or cleansed manually before use in mail production or geocoding workflows.

Ready to start cleansing your address data?

Contact the Addresser team to begin your journey to data excellence today.

Contact Us