How To

Working with open aid information and data sometimes needs developers to build tools, but often you will find there are freely accessible tools already available to help you achieve what you want. In this section you will find step by step how to guides for working with aid information.

If you’ve got a step-by-step guide to share, or want to suggest a How To that you need, you can add a comment on this post or get in touch.

Many of the step-by-step recipes are also available in the Open Data Cook Book, which includes other ideas and instructions for making use of open data.

CSV + Google Refine: the data you want in spreadsheet form

CSV + Google Refine: the data you want in spreadsheet form

See below for details of how to get the data you need. Summary The IATI XML standard is hard to represent in a simple ‘flat’ spreadsheet structure. Aid activities can …Continue reading »

Transforming IATI Data with XSLT

Transforming IATI Data with XSLT

Screenshot and link View shared XSLT Transformations and add your own on GitHub. Summary XML Style Sheet Transformations (XSLT) provide a way to reformat XML data for use in different …Continue reading »

Yahoo pipes for mixing, filtering and converting data

Yahoo pipes for mixing, filtering and converting data

Screenshot and link View a step by step recipe for creating your own yahoo pipes here, an example pipe to filter DFID files here, and an example for merging two …Continue reading »

API Access to the IATI Registry

API Access to the IATI Registry

Automated access to the IATI registry for developers… Continue reading »