We're making updates to improve your experience. Some products and checkout may be unavailable on Saturday, November 21 and Sunday, November 22. Thanks for your patience. Check our status page for updates.
Connect - How do I add or import data into my custom roster columns?
Learn how instructors add or import data into custom roster columns in Connect.
Tags
Higher Ed Student
Higher Education
Customer Support
Connect
Instructor
Share:
Once you have created your custom roster column(s), the next step is preparing the file used to import data into your new custom column.
Preparing Your File to Import
CONNECT accepts a data file format called “comma-delimited”. This is a common, universal format for exchanging database information. Don’t let the name intimidate you. It’s just a basic text file that contains comma characters between each piece of information you are importing. We’ll show you how to organize your information in Microsoft Excel and then export it as a “comma-delimited” file CONNECT can understand.
Let’s begin with a simple example to show you how the Excel spreadsheet file should be organized. We’ll assume you want to import Blackboard IDs into your roster. CONNECT uses the student email address to match up the Blackboard ID with the proper student in your CONNECT roster.
In the first column of your Excel spreadsheet, column A, enter the email address of each student you want to import a Blackboard ID for.
In the second column, column B, enter the corresponding Blackboard ID.
Once you have all the email addresses and Blackboard IDs entered, select Save As… from the File menu. The Save As dialogue box opens.
From the Save as type: option menu, select CSV (comma delimited)(*.csv)
Name your file, for example blackboardIDs.csv and click Save.
Save the file on your computer’s hard drive in a place you can easily find, such as your “My Documents” folder.
You may be able to save some time by exporting a data file from your course management system. This file could be opened in Excel and resaved as a comma delimited file. However, keep in mind that the email addresses used in CONNECT may be different. If they are, you’ll have to edit the file manually before importing it.
Now that you have your comma delimited file saved you can import it into your CONNECT roster
Importing Your Data File
To import a data file:
From the my courses page, click the Roster icon.
Click import student info. --If the column already contains data, CONNECT will display a message indicating data already exists in this column along with a button to delete the existing data. If you want to replace the data, then click the Delete Data in this Column button to remove the existing data and continue on to the next step to import your new data file.
Click the “Browse…” button.
Locate the comma delimited excel file (csv) you saved earlier and click Open.
Next, click the Preview button.
CONNECT will provide a preview of your roster before your data is imported and how it will look after your data is imported.
CONNECT will also notify you if there is a problem with any of the data you are importing. For example, if the file you’re importing has no matches for students in your roster, a yellow box will appear above the roster listing the mismatch of data. If there is a problem, you can click Edit to go back to the Roster: Import Column Data page. You will need to edit your data file and upload it again.
If the Import Column Data Preview is correct, click Accept Import to finalize the import process.
You are returned to the Roster page with the new custom column data in your course section roster. A message appears at the top of the page confirming the column data was imported successfully. This new column data can now be included in your CONNECT reports and exported for use with other applications.
Help us improve!
Let us know how we can improve our support information by providing feedback in this short survey.
Top
Regional Page Available
It looks like you're outside the United States. Do you want to see your regional version of this page?
connect
student
instructor
Personas
Personas/Higher Ed Educator
Personas/Higher Ed Educator/Instructor
Asset Format Type
Asset Format Type/Customer Support
Business Unit
Business Unit/Higher Education
Personas/Higher Ed Student
Programs & Solutions
Programs & Solutions/Connect
highered
2026-03-24T18:27:57.941-03:00
<p>Once you have created your custom roster column(s), the next step is preparing the file used to import data into your new custom column.</p> <p><strong>Preparing Your File to Import</strong></p> <p>CONNECT accepts a data file format called “comma-delimited”. This is a common, universal format for exchanging database information. Don’t let the name intimidate you. It’s just a basic text file that contains comma characters between each piece of information you are importing. We’ll show you how to organize your information in Microsoft Excel and then export it as a “comma-delimited” file CONNECT can understand. </p> <p>Let’s begin with a simple example to show you how the Excel spreadsheet file should be organized. We’ll assume you want to import Blackboard IDs into your roster. CONNECT uses the student email address to match up the Blackboard ID with the proper student in your CONNECT roster.</p> <ol> <li>In the first column of your Excel spreadsheet, column A, enter the email address of each student you want to import a Blackboard ID for.</li> <li>In the second column, column B, enter the corresponding Blackboard ID.</li> <li>Once you have all the email addresses and Blackboard IDs entered, select <strong>Save As…</strong> from the <strong>File</strong> menu. The <strong>Save As</strong> dialogue box opens.</li> <li>From the <strong>Save as type:</strong> option menu, select <strong>CSV (comma delimited)(*.csv)</strong></li> <li>Name your file, for example blackboardIDs.csv and click <strong>Save</strong>.</li> <li>Save the file on your computer’s hard drive in a place you can easily find, such as your “<strong>My Documents</strong>” folder.</li> </ol> <p>You may be able to save some time by exporting a data file from your course management system. This file could be opened in Excel and resaved as a comma delimited file. However, keep in mind that the email addresses used in CONNECT may be different. If they are, you’ll have to edit the file manually before importing it.</p> <p>Now that you have your comma delimited file saved you can import it into your CONNECT roster</p> <p><strong>Importing Your Data File</strong></p> <p>To import a data file:</p> <ol> <li>From the my courses page, click the Roster icon. </li> <li>Click <strong>import student info</strong>.<br /> --If the column already contains data, CONNECT will display a message indicating data already exists in this column along with a button to delete the existing data. If you want to replace the data, then click the <strong>Delete Data in this Column</strong> button to remove the existing data and continue on to the next step to import your new data file.</li> <li>Click the “<strong>Browse…</strong>” button.</li> <li>Locate the comma delimited excel file (csv) you saved earlier and click <strong>Open</strong>.</li> <li>Next, click the <strong>Preview</strong> button.</li> </ol> <p>CONNECT will provide a preview of your roster before your data is imported and how it will look after your data is imported. <br /><br />CONNECT will also notify you if there is a problem with any of the data you are importing. For example, if the file you’re importing has no matches for students in your roster, a yellow box will appear above the roster listing the mismatch of data. If there is a problem, you can click <strong>Edit </strong>to go back to the Roster: Import Column Data page. You will need to edit your data file and upload it again. </p> <p>If the Import Column Data Preview is correct, click <strong>Accept Import</strong> to finalize the import process.<br /><br />You are returned to the Roster page with the new custom column data in your course section roster. A message appears at the top of the page confirming the column data was imported successfully. This new column data can now be included in your CONNECT reports and exported for use with other applications.</p> CXG Learn how instructors add or import data into custom roster columns in Connect. 2025-11-19 Connect - How do I add or import data into my custom roster columns? Learn how instructors add or import data into custom roster columns in Connect. Learn how instructors add or import data into custom roster columns in Connect.
Learn how instructors add or import data into custom roster columns in Connect.
Once you have created your custom roster column(s), the next step is preparing the file used to import data into your new custom column. Preparing Your File to Import CONNECT accepts a data file format called “comma-delimited”. This is a common, universal format for exchanging database information. Don’t let the name intimidate you. It’s just a basic text file that contains comma characters between each piece of information you are importing. We’ll show you how to organize your information in Microsoft Excel and then export it as a “comma-delimited” file CONNECT can understand. Let’s begin with a simple example to show you how the Excel spreadsheet file should be organized. We’ll assume you want to import Blackboard IDs into your roster. CONNECT uses the student email address to match up the Blackboard ID with the proper student in your CONNECT roster. In the first column of your Excel spreadsheet, column A, enter the email address of each student you want to import a Blackboard ID for. In the second column, column B, enter the corresponding Blackboard ID. Once you have all the email addresses and Blackboard IDs entered, select Save As… from the File menu. The Save As dialogue box opens. From the Save as type: option menu, select CSV (comma delimited)(*.csv) Name your file, for example blackboardIDs.csv and click Save. Save the file on your computer’s hard drive in a place you can easily find, such as your “My Documents” folder. You may be able to save some time by exporting a data file from your course management system. This file could be opened in Excel and resaved as a comma delimited file. However, keep in mind that the email addresses used in CONNECT may be different. If they are, you’ll have to edit the file manually before importing it. Now that you have your comma delimited file saved you can import it into your CONNECT roster Importing Your Data File To import a data file: From the my courses page, click the Roster icon. Click import student info. --If the column already contains data, CONNECT will display a message indicating data already exists in this column along with a button to delete the existing data. If you want to replace the data, then click the Delete Data in this Column button to remove the existing data and continue on to the next step to import your new data file. Click the “Browse…” button. Locate the comma delimited excel file (csv) you saved earlier and click Open. Next, click the Preview button. CONNECT will provide a preview of your roster before your data is imported and how it will look after your data is imported. CONNECT will also notify you if there is a problem with any of the data you are importing. For example, if the file you’re importing has no matches for students in your roster, a yellow box will appear above the roster listing the mismatch of data. If there is a problem, you can click Edit to go back to the Roster: Import Column Data page. You will need to edit your data file and upload it again. If the Import Column Data Preview is correct, click Accept Import to finalize the import process. You are returned to the Roster page with the new custom column data in your course section roster. A message appears at the top of the page confirming the column data was imported successfully. This new column data can now be included in your CONNECT reports and exported for use with other applications.
CXG
Higher Ed Student, Higher Education, Customer Support, Connect, Instructor