Throughout the school year, counselors receive many test reports for students from different testing organisations (College Board, ACT, etc.) With Bulk Upload, counselors will be able to bulk Import Test Scores into Cialfo easily.
Where can I find the Upload feature?
Click your profile picture in the top-right corner of the page to open the drop-down menu. Under the Account section, select Bulk Upload.
Upon landing on the Upload & Integrate page, select Import test scores.
Step 1 - Uploading your data file (.csv, .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
Select ACT scores
Make sure to determine the date format used in your file so that the uploader reads the data accurately.
Our system accepts the following date formats:
Day-Month-Year (DD-MM-YYYY)
Month-Day-Year (MM-DD-YYYY)
Year-Month-Day (YYYY-MM-DD)
Month/Day/Year (MM/DD/YY)
Date Month Year (DD MMM YYYY)
Step 3 - Matching data columns to Cialfo fields
First, determine which row in your file contains the column headers. Next, match the columns in your file to the corresponding data fields available on Cialfo. To make future uploads easier, your column mapping will be saved and automatically applied the next time you upload a file. :)
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.
Mandatory Fields for uploading ACT Score-
1.Student Identifier* (Recommended to use student email address, if not available you may use student first name and last name)
2.Test Date*
3.Math section score* (Range-1 to 36)
4.Science section score* (Range-1 to 36)
5.English section score* (Range-1 to 36)
6.Reading section score* (Range-1 to 36)
7.Composite Score* (Range-1 to 36)
Optional fields-
1.Date of Birth
2.Registration ID
3.Writing Score (Range-2 to 12)
Step 4 - Preview & Confirm
Reviewing errors found
After processing your data, the magical wizard will identify any rows in your file that contain errors and specify exactly what those errors are. You can then make the necessary corrections and upload the file again. Alternatively, you can download an error report for easier reference.
Confirming test scores to be imported
On the New tab, you'll be able to preview the data that will be imported, confirm the number of accounts that will be created, and review the test scores and test dates before proceeding with the import.
Turning on the "Update" function (Optional)
Upload 2.0 can intelligently detect whether user accounts already exist in Cialfo by checking the Email Address column. If matching accounts are found, you can choose whether to update the existing records.
Note: Enabling the Update data for existing entries toggle will overwrite the existing test score data for the matching test date.
Step 5 - Confirming your upload
Last but not least, click Finish Import and voilà—your import is complete!
Once the import is finished, you'll see the upload status turn green and you can download a report.
If you ever need to review the import details, you can find them on the Upload History page by navigating to Upload & Integration History.
That's the end of ACT Score Upload (Tests)! Happy uploading!
Need Help?
Our Client Support team is available via Live Chat 24 hours a day, Monday through Friday, so you can get help anytime during the work week through Chat with Cialfo.
If you're unable to find a solution in our help articles or need further assistance, you can contact the Cialfo Support team via Live Chat or email us at [email protected].