Contents

This article covers importing majors to Majors. I recommend you use this functionality when you initially set up your application, then manually add majors moving forward.

• Introduction
• Setting up/creating the .CSV Import File
• Importing CSV file in Majors
• Related articles

Introduction

Application | Majors

You can import a list of majors using Microsoft Excel to create a .csv file. The majors in the list will import in alphabetical order, regardless of the order they are typed in the .csv file

Setting up/Creating the .CSV Import File

1. Open Excel - Open Microsoft Excel
2. Create Name Column - In column A1 type the heading Name. The file will not import without this heading in the correct column.
3. Create Code Column - In column B1 type the heading Code. The file will not import without this heading in the correct column.
4. Add Major Names - In column A, under the Name heading, type the major names. Major names are external labels and are what the applicant sees on the application. There are no character limits on the length of the major name and html friendly special characters are allowed.

5. Add Major Codes - In column B, under the Code heading, type the major codes. Codes are internal labels which populate to your download fields when you download application data. There are no character limits on the major code and html friendly special characters are allowed.

   

6. Save the File - Once all your majors appear (both major names and codes), click File
   1. Click Save as
   2. Type a Name for the file name
   3. Under Save as type, select CSV
   4. Click Save

Note: Only .csv files can be imported. The default excel file (.xls) cannot be imported

Importing CSV File into Majors

Now that your .csv major file is created,

1. Navigate to Majors - Go to the Majors area of CrossConnect (Application | Majors)
2. Start the Import - Click the Import button at the top of the screen
3. Find Your File - Navigate to the location of your saved .csv majors file and select it
4. Choose the File - Click Open

If you correctly set up your .csv file, the majors will import in alphabetical order. Any duplicate majors (exact same name and code) will not import

Related articles

• Majors vs. Major Lists
• Majors: Adding Majors
• Majors: Renaming or Editing
• Majors: Deleting Majors
• Major Lists
• Common Major & Major List Actions