Spreadsheets2IATI

Data4Development > Services > IATI > Spreadsheets2IATI

The Spreadsheets2IATI Converter

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?

What IATI mean for you

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. 

How we can help 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.

How it works

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.

Our clients

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

Other related products

Related topic
Transformation in practice: how to make a transformation project successful

In May this year, Hivos and D4D closed the Hivos Project Change!, a multi-year transformation trajectory. For D4D, this was a major milestone and finalising the project brings us to reflect on the journey we made with Hivos and how we contributed to this important transformation process.  What initiated this transformation process and what were…

June 11, 2021
No Comments
Online IATI training with Scotland’s International Development Alliance

Last week, Data4Development gave a training on the use of IATI on data transparency, equipping 9 non-profits organisations from the UK with all the skills one’s need to start publishing on IATI. The training was organised by the Scotland’s International Development Alliance. We interviewed Laura Ffrench-Constant to get more insights about the perception of IATI within her organization.

April 15, 2021
No Comments