Skip to main content

Creating an Apprenticeship Service cohort export

Gav Willis avatar
Written by Gav Willis
Updated over 3 years ago

The Apprenticeship Service allows providers to upload a CSV file containing details of a cohort of Learners so that they can confirm that they are engaging with the Training Provider.

To create the export file in PICSWeb:

Go to the Learner List and select both More > AS Cohort and More > AS Agreement ID from the filters at the top of the list. This will add a new filter where you can enter the AS Cohort and AS Agreement ID you want to use to filter the list. You will need to have both these filters added to the learner list and with either a value, Is Blank or Is Not Blank entered into each before you can create the export file. You will then need to run the search with both these filters.

Use the tickboxes to select each learner you want to include in the export. The tickbox at the top of the list can be used to select or deselect all learners in the list.

The bulk processing actions will then appear above the list. Select Update All > AS Cohort Export from these actions to begin the export.

Once the file has been generated, a window will open with the file able to Download. You will be informed if any learners were excluded from the export and the reason for their exclusion.

Once a learner has been included in an export, the AS Status field in their ILR Learner tab will be set to Sent to Apprenticeship Service.


For more information, take a look at the full help page for Creating an AS Export.

Keywords: AS cohort CSV, Apprenticeship service spreadsheet, generate AS cohort file

Did this answer your question?