Import accounts from a CSV

Import accounts from a CSV when you want to bring a list of companies into the workspace in one pass instead of adding them one at a time. You map your file’s columns to the workspace’s fields, choose how to handle accounts that already exist, and optionally start a workflow on every account that lands. This page covers a fresh import (creating new accounts). To change accounts that are already in the workspace, see Update accounts from a CSV.

Before you start

• You need edit access to Accounts. In a read-only session the Add New menu does not appear.
• Have your CSV ready with a header row. The only required column is Account Name.
• A domain is helpful but not required - if you leave it out, you can run the Domain Finder afterward to fill it in.

Steps

The Create Accounts with import dialog walks you through three steps, shown as a stepper at the top: Upload file, Map columns, and Settings.

1. Upload file

1. Open Accounts from the left navigation.
2. Click Add New in the top right, then choose Create with CSV. The Create Accounts with import dialog opens.
3. Drop your file onto Drag your CSV file here, or click Upload to pick it. The dialog lists the columns it reads:
   • Required column: Account Name.
   • Optional columns: Domain, Company Linkedin URL, Account Owner Email, Parent Domain, Parent Account Name, Child Domain, Child Account Name.
   • Any other column can be brought in as a custom field on the next step.
4. Click Continue.

2. Map columns

The workspace reads your file’s header row and tries to match each header to the right field automatically (for example a column literally called “Account Name” matches on its own). Review the result before continuing:

1. For each field (Account Name, Domain, Company Linkedin URL, Account Owner Email, Parent Domain, Parent Account Name, Child Domain, Child Account Name), the dropdown next to its label shows the column it is currently matched to. Change it if the automatic match picked the wrong column, or pick one if none was matched. Account Name is required to continue; the rest are optional.
2. Under Custom fields, select any remaining columns from your file that you want kept as custom data on the account. A column already mapped to one of the fields above cannot also be picked here.
3. Any column from your file that is neither mapped to a field above nor selected under Custom fields is left out of the import entirely - it does not end up on the account. Add it as a custom field in this step if you want to keep it.
4. Click Continue, or Back to change the file.

3. Settings

1. Under Tags, pick existing tags or type a new one to create it. Every account in this import gets the tags you choose here.
2. Under Workflow, select the workflow to run on the imported accounts. A default is pre-filled from your account-upload setting; you can change it for this import or pick none. Default workflows settings opens the settings page where that default is managed. The chosen workflow starts automatically once the accounts are created.
3. Under If an account already exists, choose how to handle matches against accounts already in the workspace:
   • Skip it (Do not update existing account information) - the existing account is left untouched.
   • Update existing account information using data from your CSV. - the matching account is updated with the values from your file.
   • Create a new duplicate account - a separate account is created even if a match exists.
4. Turn on Add to Do Not Touch (DNT) to mark every imported account as one you do not want to work with right now. Accounts marked this way are excluded from the workflow run and can be filtered out of your actions. See Do Not Touch.
5. Turn on Override existing account owners if you want the owner on matching accounts replaced. With it on, the owner is set to the email in the Account Owner Email column, or to you (the person uploading) when no owner is listed. With it off, existing owners are kept.
6. Click Import. To leave without importing, click Close (available on any step).

A row with an empty Account Name is skipped. If two rows share the same name and domain, only the first is kept (unless you chose to create duplicates). Pair Parent Domain with Parent Account Name (or Child Domain with Child Account Name) to link accounts into a parent-child relationship as they import; a referenced parent or child that does not exist yet is created.

What happens next

After you click Import the dialog closes and you see a confirmation that the import has started and is processing. Importing runs in the background, so you can keep working. A banner on the Accounts page shows Currently importing: with the file name while it runs, and Open import reports takes you to the import’s progress and per-row outcome.

Imported accounts appear on the Accounts list. If you selected a workflow, its agents start running on each new account (Do Not Touch accounts are left out), and those agent runs show up in the Agent tasks feed. See Monitor the task feed to watch them.

An import moves through these states in import reports: In queue, In progress, Enriching, Completed, Partial (some rows succeeded, some did not), Cancelled (stopped before it finished), or Error. Open the report to see the per-row breakdown: Created, Updated, Duplicated, Skipped, and Failed. Large files take longer; check back rather than waiting on the page.

Related

• Update accounts from a CSV
• Import contacts from a CSV
• CSV import fields
• Monitor the task feed
• Do Not Touch