Nominations CSV Upload
This article offers guidance for the Erasmus+ digital nominations upload template via the EWP Dashboard. It structures the values to be injected and offers guidance how to fill it in.
To make sure you format the CSV correctly, please check the Nominations upload template file below:
How to upload Nominations
The CSV files for creating students’ Nominations have to follow a specific format that is illustrated in the Excel spreadsheet template. This file can be used with most of the spreadsheet software, including Excel, LibreOffice, Numbers and OpenOffice. The template can be used both by entering new values by hand or by pasting them from other files in bulk, but in the latter case make sure you are only pasting values, to avoid carrying over special formatting.
Keep the headers from the template file in the uploaded CSV to ensure the data is read correctly!
In the guide file, the headers clarify the validation rules the various fields have to follow in order to be correctly read. By clicking on the columns’ headers, you will see a text explaining the formatting rules that your data should follow. Conditional formatting across columns will help you navigate large files and fix errors, highlighting in red those cells that need adjustments.
Common errors and how to fix them
Date
The date in the CSV file must be formatted like this: yyyy-mm-dd. This may cause issues when typing the date in Excel or while editing the CSV, because the software might recognize the input as a date and could format it using your national standard. In countries where this standard uses a different separator, for example, a period, the date may be formatted incorrectly.
To avoid this issue, change the format of the cell from Date to Text when importing the data.
Please make sure there are no empty spaces in the email address’ cell checking whether there are no extra blank spaces before, in the middle or at the end of the address itself.
Receiving institution
Please, make sure that the Erasmus Code is correct and is not missing some parts (for example the digits at the end or the country letters at the beginning, the space or spaces after the country code are necessary). It is also possible that some extra spaces are making the code impossible to read. As a general rule, when the country code consists of only one letter, it is followed by two spaces, if the country code consists of two letters they are followed by one space only and if the country code consists of three letters, there are no spaces at all.
Please, check if your CSV file upload works using the Erasmus code appearing in our template file before contacting us.