Excel to IATI — with AidStream PRO

Use Excel files to import your IATI data on AidStream

The import function is one of the most used features on AidStream. Publishers who update large data at once find it convenient to initially record their IATI data in Excel files.

Uploading these files and subsequently publishing them to the IATI registry provides a straightforward method for reporting data.

Publishers can import their activities, transactions, and result data with the help of an XLS or CSV file (importing data using an XLS file is reserved for PRO users). The import feature eliminates the hassle of manual data entry for large number of activities.

Import Templates

AidStream provides a set of templates for publishers to import their data to AidStream. Publishers often express their grievances of having to strictly use these templates.

Why is it necessary to strictly use the provided templates?

1. The main reason is to maintain data quality. Publishers are required to follow a set of guidelines when using AidStream templates. For instance, publishers are required to use the codes in the IATI Codelists for various elements’ components instead of using their names. E.g.: to report an activity (that’s in implementation stage) using an XLS file, publisher will have to use the code for implementation from the IATI Codelists i.e., 2.

(Left) Codelist of Activity Status.

This dramatically removes the possibility of human error while typing the word ‘implementation’. If there is even a minor inconsistency, the output from (computerised) data analysis will bring a different result.

2. Data Validation: AidStream has integrated validations into the templates. After the import processing is complete, the system runs a set of validations to check if the imported data meets the minimum data quality requirement. If it does not, the system provides feedback for correction. The data can be imported only when the said corrections are made.

Fast-track your publishing process

Inculcate AidStream’s templates to your data recording process to remove the hassle of converting them later. When it is time to publish to IATI, publishers will have to arrange the data according to the provided templates before importing. This is repeated work for many publishers. This of course, might not be possible for all users.

Steps to import Excel files!

Visit the link to find detailed steps to add your Excel file on AidStream-

Import Activities from CSV

In case of queries or confusions, write to us at support@aidstream.org.