Overview
This article walks you through creating an Import Task from scratch. This article will focus on importing a data file. To import documents, visit Creating Document Imports.
Things to know before importing:
Make sure that you have either a .csv or a .txt file.
Excel files can't be imported and must be saved as .csv or .txt first.
Data files should always have an identifier, like email or an ID, to prevent duplicate accounts.
Video Guide
Creating a New Import
To create a new import:
Navigate to Data + Automations > Import + Export > Imports.
Click on the + button along the right-hand side.
Select Data, and click Confirm.
Selecting an Import Source
After creating the new import task, a sidesheet will appear for your new import. The first tab to display will be the Source tab. You can import files from a variety of sources.
In this example, we'll use the Computer source to upload a file from your device. Again, make sure you have either a .csv or a .txt file. Excel files can't be imported and must be saved as .csv or .txt first. Data files should at least have an email address, first name, and last name for each contact.
After selecting Computer, click the Upload File to select the .csv or .txt file from your desktop.
When using SFTP, Dropbox, and Google Drive to import from a folder, you can use * as a wildcard for multiple characters, or you can use [date:now,format=m-d-Y,timezone=local] to pick up only a file for the current day. For example, if you have a filename "nursing_data_5-18-23.csv", you could use the pattern "*_data_[date:now,format=m-d-Y,timezone=local].csv" to import all data files from the current date.
Mapping
After selecting your file, you can move to the Mapping tab. This is where the bulk of your import work will take place. You'll see each of your file columns displayed vertically on the left. The right will be blank, but that is where you will select the Element451 field to which each file column corresponds.
Templates
Rather than manually mapping the incoming data by hand, you can apply a pre-built template that automatically maps the incoming data to the Element451 fields. A list of system templates is available by default, or you can build your own. The template must match the incoming data file precisely to prevent errors in the import.
In this article, we'll assume you are not using a template.
Simple Mapping
For some fields, the mapping will be simple. For example, when importing the first name, you can click Map to Field, search "First name," and select the first name field.
Advanced Mapping
Text fields, like First Name, require no additional setup. When you come across fields with dates, dropdown fields, and application fields, there will be additional setup in the field's column settings—open column settings by clicking the 
at the right of each row. Read our Column Setting Options on Imports article for more information on the column settings.
Column Setting tabs include:
Scope: Defining what the column is related to, such as an application or milestone. Read more about Scopes.
Transformations: Telling Imports how to understand and transform the data as needed. This is a crucial setup component to ensure that data comes in clean.
Validations: Ensuring data meets specific criteria before being imported.
Empty Values: Telling the system what to do with blank cells.
Configuration
Once you have completed the mapping, you will set up additional settings for your import.
Matching Settings
Matching will prevent duplicate records from being created and assist with the settings selected for Importing Only New People and Updating Existing People. It's common to match on email address, but all imported identity fields can be matched.
🔎 Hint: Not seeing fields in the Matching Settings? Make sure you have an identity field mapped in your import.
Destination and Source Settings
Here, you can decide what to do with the records coming in from the import and define the type of file that is coming in.
Import Only New People: Using a unique identifier, like email address, as Element451 imports the data, if it finds a pre-existing record in the system, the record will get skipped. Only new records will be imported and created.
Update Existing People: Using a unique identifier, like email address, as Element451 imports the data, if it finds a pre-existing record in the system, it will update it with the new information coming in from the file. No new records will be created.
Update Existing and Import Only New People: Using a unique identifier, like email address, as Element451 imports the data, it will try to find a pre-existing record to update. It will create a brand-new record if it cannot find a pre-existing one.
Delimiter Character: Clarify how the data is separated in the file. The default is Comma.
Skip First Row: Clarify if the first row in your file should be imported, meaning it contains column header names and not actual record data.
Groups and User Type
This set of settings will allow you to do the following:
Create New Segment: Create a segment for records affected by your import (This can be helpful when debugging imports).
Segments created by an import will not have a value for "created by."- Each segment created is tied to that specific import when running an import. Changing the ‘New Segment Name’ field will not create a new segment or rename the existing one. To create a new segment, you must duplicate the import template and run a new import, as only one segment can be created per import.
Default User Type: By default, all imported records are assumed to be students. This can be changed to Family or Influencer.
Preview
The Preview tab will allow you to preview records in your import to confirm that everything looks good. If there are any errors in the formatting of those records, you'll see a yellow yield sign on the right side of the screen. Read our article on Data Quality for a guide and reference on how the preview screen should look.
Run Import
After mapping and previewing the incoming data, you are ready to move on to running the import task.
Test Import
At this time, you cannot use the test import function if you are importing relationships, such as parent information.
Before you run, test your import with the Test Import button at the top of the import task. This will simulate how many records will be created or updated and how many rows will be skipped without affecting the records. The database will not get updated when testing tasks. To view the results from the Test Import, click the Run History tab.
Run Import
Once you've tested and are ready to execute your task, click Run Import (if running immediately) or Schedule (if running on schedule). Schedules can mean a one-time run in the future or a repeated run. Read more about Scheduling Imports.
Run History
The Run History tab shows the results of all runs and tests executed by the import. Each run result will show the number of records added or updated by the run and the number of skipped rows in the data file. If a row is skipped, the results will show a warning. Read these warnings to understand why rows were skipped.