Home > Clients > Client How To's > Importing Clients
Watch the video or follow the steps below for step-by-step instructions on importing a client list into Stratus.
From the Stratus Utilities menu, choose Import Clients.
The Client Import Wizard will launch.
If you will be importing from a new data source (one that you haven't imported from before),
choose the type of file you'll be importing from the following options:
Comma-Delimited Text File (.txt or .csv)
Excel Spreadsheet (.xls)
To use an existing import template, select the third option and then choose the template from the drop-down list.
Browse to the import file and click Open.
Find each appropriate Stratus field in the right panel and drag and drop each one onto the corresponding column in the left panel.
When you're done assigning the fields, click Next.
Stratus can check for duplicates during the client import. Note: Stratus evaluates whether a record is a duplicate by using the settings on the Client page in Studio Preferences (see Checking for Duplicates). Each time you import clients, you can choose from the following options:
Do not check for duplicates
Do not import possible duplicates
Import possible duplicates but add to a client group
Choose any of the following options:
Automatically Assign Client Number - Use this option if you're not importing a pre-assigned client number for each client. See also: Setting up the Client Numbering System
Assign Imported Clients to a Group - This option is strongly recommended! Use the suggested group name or replace it with your own.
Assign Lead Source to Imported Clients - Use this option if all the clients have the same lead source. See also: Using Lead Sources
Assign Client Status to Imported Clients - Choose this option if you want all the imported clients set to a certain status. Then choose a due date for follow up. See also: Using Client Statuses
Save Import Template - If you think you might use the same import settings again in the future, check this option and give the template a name. This will save you from having to assign the fields again.
Click Finish on the final page to complete the import.