The spreadsheet requires all mandatory fields to be completed for the Apprentice and Employer details. Both of these have drop down menus for selections to be made such as ethnicity and gender. Where there is a drop down menu, a numerical code is required on the spreadsheet so that it can be converted by the system so and displays correctly within ACW.
The table on this page details those fields that require a code and what the code is for each possible selection. (Click image to enlarge)