ABR bulk data can be downloaded from the Data Transfer Facility and incorporated into your own internal systems or accessed and utilised via a database solution used by your agency. Consultation with your internal IT area is recommended as support may be required to assist with importing, querying and managing the bulk data.
Within each of the bulk data files available for downloading, there are ten tab delimited text files. Additional information regarding the structure and meaning of each of the data file fields is available in the ABR Data Dictionary.
Data File Name
ABR Data Dictionary Reference
Start dates file
Returned mail file
Australian Charities and Not-for-profits Commission (ACNC) file
Other trading names file
sttyymmdd _ABR Entity Mapping File.txt *
sttyymmdd _Summary.txt #
#sttyymmdd provides details regarding which state the extract is for and the date the bulk data file was generated eg. QLD141027. Allyymmdd refers to a national data file.
To assist you with loading the ABR bulk data files, we have provided SQL (structured query language) code to generate the data tables with the correct data structure and field headings.
To view the code click hereExternal Link
Each file contains a primary identifier also known as the PID (with the exceptions of the ABR Entity Mapping File.txt and the ABR Division Mapping File.txt) for linking the files as shown in the following relationship diagram below.
# The sttyymmdd_Summary.txt files is not shown in the relationship diagram above as this file in an information file only, it provides details regarding the date and time each of the .txt files were generated including the size of each of the files.