Skip to content

Adding datasets to data.govt.nz

Learn how to prepare a machine readable CSV file and publish to the data.govt.nz data catalogue.

Learning outcomes

  • Removing formatting from spreadsheets to ensure machine readability
  • Working with open standard file formats eg. CSV (Comma Separated Values)

Video transcript

"Data.govt.nz - Making government data easy to find and use.

Our new website - now powered by the CKAN platform - promises a much better user experience.

So how can agencies add data? I'll walk you through this... and show you some of the cool things the people who want to use your data, can do.

The first thing is to find the file with the data you want to release.

If it's a spreadsheet like this one - the format will need to be changed so it's machine readable.

The format you're aiming for is CSV. This means you've got to remove any presentational elements such as headers, footers, logos etc. Then make sure each row and column has a heading… Remove any empty rows too… and remove the text at the bottom of the spreadsheet. This explanatory text can be placed into an accompanying file.

Finally, remove the colour shading and borders using clear formatting. Then save this file as a CSV.

So you don't forget, here's the main things to remember: Remove all white space and explanatory text. Make sure each row and column has a heading. Make sure each cell has a value. Clear all formatting.

Once the data is machine readable... upload it to your agency website.

Then get in touch to tell us you'd like to add your data to data.govt.nz

We'll have a look at your data and talk you through next steps...If you need to update your data on a regular basis, it may be that you need a scheduled harvest. We can help you with that too.

We'll let you know when your data is live on data.govt.nz

Once live - users will be able to preview and download your data easily.

So why not add your data?

Get in touch with our team... and we'll talk you through the best way to add your data to data.govt.nz."


Top