A CSV file is a kind of table or spreadsheet that can be used to import or export data between different software programs.
CSV files can be opened and edited in a number of different spreadsheet programs, such as Google Sheets (Google Docs), OpenOffice, Numbers and Microsoft Excel.
You can use CSV files to import data to the Richmond Learning Platform, for example if you need to create a large number of Student accounts at once. For more information, see this article.
The Richmond Learning Platform can also automatically create a CSV file which includes information about students at your institution who are already registered. This is called 'exporting information'.
CSV export guidance
If you are a Training Manager and you want to create a CSV file about the students at your institution, select the Users tab, then select 'More'.
You can choose from two options: 'Export users CSV' or 'Export users class membership'.
- If you need detailed information about the students at your institution, including all the Richmond Learning Platform classes each student is linked to, please choose 'Export users class membership'.
- If you need information about the students at your institution so that you can update a large number of Student accounts in one go, please choose 'Export users CSV'.
Please note that both types of CSV file will include information about existing Student accounts only. The CSV file will not include information about other Training Manager or Teacher accounts.
'Export users CSV'
This allows you to create a CSV file (spreadsheet) about the students at your institution who are registered on the Richmond Learning Platform. It includes your students' first and last names and their email addresses.
This CSV file will not include information about the classes your students belong to. If you need to see class details, you must use the 'Export users class membership' function (see below).
Once you have exported the CSV file, you can edit the information in the spreadsheet and then reimport it to the Richmond Learning Platform. This is useful if you need to update several Student accounts at once, for example if you want to add a large number of students to a class.
Remember, if you reimport a CSV file, students will only be linked to the classes included in the Class field of the CSV file. You must include the names of all the classes you want students to be linked to (including any classes they are already linked to on the Richmond Learning Platform). For example, if Student A is already linked to 'Class 1' and 'Class 2', but you also want to link her to 'Class 3', the Class field for Student A in the CSV file must include "Class 1,Class 2,Class 3". If you only enter 'Class 3' and then you reimport the CSV file to the Richmond Learning Platform, Student A would be added to Class 3 and removed from Classes 1 and 2.
For more guidance on importing CSV files to the Richmond Learning Platform, please see this article.
'Export users class membership'
This function allows you to create a more detailed CSV file about the students at your institution. This CSV file lists all the classes each student is associated with.
This means the 'Export users class membership' CSV file cannot be reimported to the Richmond Learning Platform – it is for information only.