Spreadsheets2IATI

Data 4 Development > 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
CNV Internationaal & D4D – The voice of workers in a dashboard

When D4D joined forces with CNV Internationaal, a cooperation emerged that puts data in position to support labour rights on remote sugar plantations in Central America.

April 1, 2021
No Comments
The rise of IATI: how the initiative is expanding throughout the world

From 10 years ago when it started in the Netherlands to where we stand today, 1,059,495 activities were published by over 1250 organisations around the world. More and more countries commit to publishing in #IATI and the number of open #aid #data portals are on the rise. Many aid data events where IATI plays a role happened lately as the Day of Transparency of the Italian Agency for Development Cooperation (AICS) and the KfW virtual conference on Remote Management and Monitoring.

February 11, 2021
No Comments