Cialfo - Access

Throughout the school year, counselors receive many test reports for students from different testing organisations (College Board, ACT, etc.)  With Upload, counselors will be able to bulk Import Test Scores into Cialfo easily.

What test scores can I upload in bulk?

  • ACT
  • SAT
  • PSAT 10 or PSAT NMSQT
  • IELTS
  • TOEFL

More coming to you soon...  (AP, IB, SAT2 or SAT Subject)

Where do I navigate to find Upload (Tests)?

On the left-hand menu, select Upload, then click Import Test Scores.

Step 1 - Uploading your data file - (.csv) or (.xls) or (.xlsx) only

a. Click the upload box, then browse and select the file you want to upload OR
b. Drag the file that you want to upload from its folder and drop it into the upload box

Step 2 - Configuring the settings of your upload

  1. Select whether you would like to import ACT, SAT, PSAT, IELTS or TOEFL scores
  2. Make sure to determine which format the dates in your file are in so that the data is read accurately by the uploader - our system current accepts Day-Month-Year, Month-Day-Year, and Year-Month-Day date formats

Step 3 - Matching data columns to Cialfo fields

First, determine which row of data in your file contains the column headers. Next, looking at the data fields that are available on Cialfo, match the columns of data you have in your file to them. For ease of future uploads, your method of matching will also be saved and automatically applied on the next upload :)

Note: All required fields are marked with an asterisk (*). For optional fields, there is an option to Ignore this column and no data will be imported under that data field.

Step 4 - Preview & Confirm

Reviewing errors found

After processing your data, the magical wizard will then tell you exactly which row of data in your file contains errors and also what the errors are specifically. With this information, you can then do the necessary corrections. Alternatively, you may also download an error report.

Confirming test scores to be imported

On the next tab New, you will be able to see exactly what data will be imported by the uploader and also confirm the test scores and test dates you are about to import.

Turning on the "Update" function (Optional)

Intelligently enough, Upload 2.0 is also able to detect whether test scores already exist within Cialfo, based on the test dates that are entered. When this is the case, you have the option of deciding whether to update the scores for the test that has been taken on the same date.

Note: Turning on update will override/replace any existing data

Step 5 - Confirming your upload

Last but not least, click Finish Import and voila - all done! 

Watch your upload status turn green, and just in case you ever need to refer back to it, you can always check the details of it on the Upload Log page.

That's the end of Uploading Tests, happy uploading!

  • To view how to Upload Users - click here
  • To view how to Upload Student Data - click here

For any questions - feel free to use our Chat with Cialfo to speak to our team :)

Did this answer your question?