prepare your contribution file for import by firstly ‘mapping fields’. Your file must be either a .txt or .csv file type. Note: Make sure you keep this file because you’re going to need it again after you’ve mapped the file.
map your imported file by selecting how the data in rows and columns are arranged so that the file preview matches your file. Hint: for columns use ‘comma’ for a .csv file and ‘tab’ for a .txt file, for rows use ‘tab’ or ‘new line’. File Import User Guide
define your file structure by indicating whether you’ve labelled your columns with a header row so that it knows at which row your data begins. If you haven’t got a header row, leave it blank.
define date and money formats by indicating what date and money formats you’ve used in your file to ensure that our numbering format matches yours.
match data fields to ensure that your data has been understood correctly, you need to match up the fields in the drop-down menu so that it corresponds to the correct column.