Upload constituent data to Constituent Manager in bulk

This article explains how to create new or updated Constituent Manager profiles using a data spreadsheet upload. Consider this process like you are uploading constituent data to Constituent Manager for the first time. 

In this Article

• Step 1: Download datasheet template
• Step 2: Complete the datasheet
• Step 3: Download your datasheet with the correct file name
• Step 4: Upload the datasheet

Step 1: Download datasheet template

If you do see this menu item, you’re ready to find and complete your datasheet before you will upload the data directly into Constituent Manager.

Go directly to these articles for the most current datasheet template for constituent group you are wanting to upload: 

• Faculty

• Students and parents

• Alumni

Step 2: Complete the datasheet

1. Open the template for the role you want to upload in your favorite spreadsheet software, such as Google Sheets or Microsoft Excel.
2. Populate your datasheet with constituent data. You may want to start by uploading only a few constituents at a time, until you are familiar with the process.
3. Populate one role at a time, so choose one file to start with. We recommend starting with faculty.

Refer to the instructions in each template for specific details about how to complete each datasheet.

Step 3: Download your datasheet with the correct file name

Download FIRST as .tsv format

If using Google Sheets, select Download As in the File menu and Download your datasheet as a Tab Separated Values file (.tsv) into a location where you can access the file. 

Rename SECOND as .txt format

Once you have the .tsv file, rename the file manually so that the new file extension is .txt. 

Step 4: Upload the datasheet

With your datasheet saved and ready, go to Constituent Manager > Settings > Import Data > Constituent Profile Data, and click “Continue” to open the upload utility.

Click Choose File to select the Unicode .txt version of your datasheet.

Click Import to begin the import of the datasheet.

Select the correct items from the dropdown menus:

• Constituent Role: For this example, we’ll use Faculty & Staff. When uploading, select the appropriate role for the datasheet you’re using. Choose Student as the role when uploading the relationships.
• Match Criteria: Use the importID option whenever possible. Using the FirstName LastName option isn’t always accurate, because you may have more than one John Smith at your school.
• Constituent Origin: Because we’re using Finalsite’s datasheet template, we’ll put Finalsite System Default as the source for this data upload. If this data was coming from an export from another student information system, we would indicate that here.
• Constituent Feed: Because Finalsite System Default is the constituent origin, the only option here is finalsite.

Make sure the Uploaded Columns and the Database Columns match. This will go a long way toward preventing errors in the upload.

Ensure that the checkboxes under New and Update are both checked for the columns you are uploading. You can determine which rows are imported on the following screen.

Once you have verified the columns, click Confirm Data to move to the next step.

On this screen, you can confirm that all the data appears the way you expect it to. If any of the column headers don’t match the data that’s below it, click Redefine import fields to go back to the previous step and select the correct field(s) from the dropdown menu. If everything appears correct, click Import Data Now.

The import may take a few minutes to process. Once the import has completed, you’ll see a table of your new and updated Constituent Manager profiles with OK next to each row.

After you have finished uploading, always check the profiles in Constituent Manager to make sure everything looks correct!