Spreadsheets2IATI

Increasingly, donors require you to publish your data to IATI. At the same time, your organisations can utilize IATI data for internal learning and planning purposes. But how do you produce and publish IATI files if you have more than a handful of projects? And if the information is spread over multiple systems?

The Dutch, Belgian and British government have already made it a requirement to publish to IATI to receive funding. More governments are following suit. 

IATI can also have value for your internal organisational processes. IATI data is, for example, increasingly used for 

• visualizations of aid and development initiatives through dashboarding internally and on websites or 
• it can be input for your own effective communication, project management, learning and planning. 

Therefore, it is time to think about how you can approach your publishing process in a structured way. The goal is that IATI data serves as a quality resource instead of creating a burden for you. 

Publishing to IATI can be a tedious task that requires quite the time investment. If you also face challenges when publishing, we have the solution for you. 

Data4Development has developed the Spreadsheets2IATI Converter 2021. This tool makes publishing to IATI hassle-free. You work in and update spreadsheets with your data. The Converter reads the data and turns the data into the format needed for IATI. Your files are then ready and we publish them for you. No new software required and 100% compatible with existing systems.

By offering different packages (from standard to system integration), the S2I Converter Service is applicable to different types of organizations, ranging from small-scale to multi-level organizations. D4D currently supports over 20 IATI publishers from around the world. The publication process is facilitated by the D4D IATI Expertise Team, who offers strategic and technical advice and quality-related feedback to create a fully validated and verified IATI publication. Next to consultancy support, D4D has implemented various long-term System Integration Trajectories, incorporating IATI into organization’s current reporting systems. D4D has experience in working with multiple systems for the publication of IATI data, ranging from exclusive for IATI (Aidstream, AKVO RSR, Activityinfo) to IATI inclusive ERP systems used in organizations.

Our Spreadsheets2IATI Converter service streamlines your IATI publishing process and makes producing valid IATI data easy and accessible. With the help of our tool, it only takes a few steps to get published:

• You create or update spreadsheets with the information that needs to go into your IATI data, using our standard spreadsheet templates.
• You put the spreadsheets in a designated folder: the converter reads all spreadsheets and produces the IATI files, checking if they are valid.
• Using the Data Quality Validator you can check your data and make easy corrections.
• Data4Development publishes the files for you.

We have serviced over 30 clients with our Spreadsheet2IATI tool. A few of the organizations we’ve worked with: