How do I import data for local context analysis?


    • High Schools


    NOTE: The structure of CSV files exported from the systems of supported vendors may change over time. College Kickstart makes a best effort to support the latest version of each file. If your vendor modified their export process recently and cannot upload your file, please contact


    All actions related to local context analysis are available through the Admin menu in your counselor dashboard. 


    NOTE: Access to the admin menu is limited to those authorized by the head of the counseling team.


    To import data for local context analysis, click on the Admin menu and select Local Context.  This will bring you to the local context workbench page:



    Click 1. Run Analysis to bring up the local context import wizard:




    To use the local context analysis wizard, you’ll need a standard “Applications by Colleges” export from Naviance, Cialfo, Maia Learning, or SCOIR for the most recent 3-5 years.  The report should be in CSV format.

    NOTE: When editing the file in Microsoft Excel, please use the "Comma Separated Value (.csv)" option to save the file.


    • If your typical high school class is less than 125 students, we recommend at least 5 years of historical admissions data.
    • If your typical high school class is between 125-175 students, we recommend at least 4 years of historical admissions data.
    • If your typical high school class is over 175 students, we recommend at least 3 years of historical admissions data.

     Click Get Started to begin the process.

    Click Choose File to select your import file and click Validate to begin the import and validation process.  The wizard will then perform a series of checks to ensure all of the required fields are present and exclude duplicate records and records with invalid/missing entries.

    If records have been excluded from the import, you can click on the Details link to bring up a validation log that provides details on which entries were problematic:

    Assuming you have relatively few excluded records, click Next to proceed to the GPA section. 


    This section lets College Kickstart know if you are using a non-standard GPA.  By default, a standard 4.0 unweighted GPA or 5.0 weighted GPA is assumed, so if you are using one of these, click Next to proceed to the next section.  

    Click on Next to proceed to the next section, Apps and Admittances.

    This section defines how you want College Kickstart to count applications and admittances.  For example, whether you want to include incomplete applications in the application total or whether you want to treat guaranteed transfers as admittances.

    Click Next to proceed to the Define Hooks section.

    This section allows you to specify if you want to exclude hooked applicants from the historical admission rates and profiles generated in the local context analysis.    

    If the flags field isn’t included in your import file or you don’t wish to track hooked applicants, click Next to continue. 

    If you use custom flags in Naviance and wish to exclude hooked applicants, use this section to map your flags to the categories provided in College Kickstart. 

    Click Next to proceed to the Summary section.

    This section summarizes all of your settings.  If they are to your satisfaction, click Finish to complete the import process and initiate the local context analysis.  Once complete, you will be returned back to the Local Context Workbench page, where you will be able to review the results and configure your settings.


    Was this article helpful?
    0 out of 0 found this helpful