Formatting data for upload

Using the Manage my datasets feature you can upload data by LGA, SA3, SA2, suburb or postcode. This data can then be viewed on the map as a heatmap.

In order to upload data into Community Insight Australia, you need a column of locations, and a column of data. The locations can be LGAs, SA3s, SA2s, suburbs or postcodes.

You can only base each dataset on one geography (e.g. postcodes). You cannot upload a mix of, say, postcodes and suburbs.

You do not need data for every area. For example, if you are uploading data by postcode, you can have data for 20, or 200 postcodes, but you don’t need to know the values for them all. Leave a blank space next to the areas you have no data for, or leave those areas (e.g. postcodes) out altogether.

If you are uploading SA2s or SA3s you will need to use their codes, not their names. We use the 2016 definitions and the 9 digit codes for SA2s. If your data is published according to 5 digit SA2 codes, download a spreadsheet that will help you convert 5 digit SA2 codes to 9 digit SA2 codes.

You can upload a CSV file or Excel workbook. If you upload from an Excel workbook, the sheet you were looking at when you last saved will be the one that uploads.

Example: NDIS average annualised budgets – data by LGA.  Note: The information is in the blue columns, but it’s ok to upload the whole sheet as we get a chance to nominate the columns to be used later.

format data 1

Here are some examples of datasets users have previously uploaded:

  • NDIS data
  • Number of clients per area
  • Survey feedback

Ready to upload? Step 1: Creating a new dataset – metadata

Or return to support menu