Copy pasting data from an external source

If you’re wondering if it's possible to copy and paste the data from an external source, it definitely is possible. However, the templates have certain data validations that need to be cleared before copy-pasting the data. 

Following are a few things to remember while copy-pasting data from external source:

1. You will need to manually enter the activity identifier for the activities whose result you’re uploading. 
2. Assign a Result code (in the format Rxxx) to each result. Match the Result Identifier to the Indicator in the Indicator, Baseline, Period tab.
3. For the fields where the IATI has defined a codelist, you can either use the codes or their respective names. For example: When reporting the Result type as ‘output’, either ‘1’, ‘output’,’1 - Output’  can be entered.                  

Note: 

• • If you’re entering the name, please make sure the spelling is correct 
  • If you’re entering the code, make sure that the code you’re entering is the correct one

While using Google Sheets templates 

For Result tab:

1. Select the range D2:S1000 and right click. 
2. Select ‘View more cell actions’ and ‘Data Validation’. A menu will appear on the right hand side of the screen.     
3. Depending on your preference, select the relevant column whose validation you want to clear or click on ‘Remove all’ to remove all the validations from column D to S.

For Indicator, Baseline, Period tab:

1. Select the range B2:AA1000 and right click.
2. Select ‘View more cell actions’ and ‘Data Validation’. A menu will appear on the right hand side of the screen. 

   

3. Depending on your preference, select the relevant column whose validation you want to clear or click on ‘Remove all’ to remove all the validations from column B to AA.

While using system downloaded templates

1. Select the range D2:S1000 and go to ‘Data’ and select ‘Data Validation’.

   

2. A data validation pop-up will appear. Set the validation criteria to ‘Any value’, click on ‘Clear All’ and save the validation.

   

3. Copy and paste the values, save the file and upload it on AidStream.