TOPSpro (CASAS) Export Student Demographics

Updated 4/2/25

This article describes how to use SiD student demographic data to create a new student record in TOPSpro Enterprise (TE).

Run the TOPSPro Export Student Demographics report

1. Go to the SiD Reports tab, Assessments section. Select the TOPSpro (CASAS) Export Student Demographics report.
2. Change the date range and other filters as desired
3. In the CASAS Vendor Code and CASAS Agency filters, type your ABE program’s assigned numbers. (If you don't know these numbers, see Obtain TOPSpro Vendor Code below.)
4. Click View Report

Export the report results from SiD as an Excel spreadsheet

Click the Export button on the report and choose Excel as the file type.

Open and confirm data in the Excel file

1. Open the Excel file you saved. If you get a message about being in Protected View, click the Enable Editing button. 
   
2. Look at Sheet 1 of downloaded file and confirm the report date range and other filters. If you need to make changes, rerun the report from SiD.
3. Delete Sheet 1. You will now only have Sheet 2, which has no headers.

Save the Excel file as a CSV file

1. Under the File menu, click Save As…
2. Choose where you want the CSV file to be created.
3. Use a file name that makes sense to you, using the word “Demog.”
4. Save as type: CSV (Comma delimited) (*.csv).
5. Click Save.
6. Close the Excel file. Do not open the CSV file.

Upload CSV data into TOPSpro

Follow these instructions for using the TOPSpro 3rd Party Import Wizard: https://drive.google.com/file/d/1lhrtq3ubqY8Jk-BiTQW6ssd_Jqj2Itcu/view

...

Obtain TOPSpro Vendor Code – One-time procedure

The first time you run the TOPSpro Export CASAS Test Data report, you might not know your TOPSpro Agency ID or Vendor ID. Ask your program manager for the name of the person who has  TOPSpro and CASAS eTest permissions. They will have the Agency ID number, and likely the Vendor ID number.

If your program staff doesn’t have a Vendor ID code, someone from your program must contact CASAS to request it. This one-time process is usually completed by the data manager or a staff person who has taken the coordinator training.

How to request a Vendor ID code

1. From SiD, run the Export CASAS Test Data report. Temporarily use the number 1 in the Vendor ID filter.
2. Export the report results as an Excel file.
3. In the Excel file, go to Sheet 2. Clear the contents of the Vendor Code column.
4. Delete Sheet 1. Then save the file as a CSV.
5. Send the unopened Student Demographics CSV file to [e-mail].

CASAS will return your file with the Vendor Code populated. Remember your Vendor Code for future SiD imports into TOPSpro.