Create client records in bulk
Article applies to:
- ShareFile Employee users
ShareFile Admins and Employees can create multiple client records and their primary contacts at once within the client hub by uploading a populated data template. This workflow saves time when you need to set up multiple clients at the same time.
Prerequisites:
Employee user must have acess to the client hub.
Employee user must have the necessary permissions to create or manage clients.
A spreadsheet application (such as Microsoft Excel) to edit the downloadable template
To create bulk clients:
-
Navigate to the client hub: From the main ShareFile dashboard, select client hub from the left-hand navigation menu.
-
Initiate the import: Click the Create client button in the top right corner and select Import from Excel file from the dropdown menu.
-
Choose the import type: Select whether you're importing Individuals or Companies.
Note:
Use the provided templates (company-client-import-template.xlsx for companies, individual-client-import-template.xlsx for individuals) to ensure your data imports correctly. You can import up to 100 clients per file.
-
Prepare your data:
- Download the appropriate template and open it in Excel
- Fill in your client information using the template structure. Required columns typically include: Client Name (for Company type), Client Type (Individual or Company), Contact First/Last Name, and Contact Email
-
Upload the file: In the ShareFile interface, click Browse to select your file or drag and drop it into the designated area.
-
Map your data: Click Next to proceed to the mapping step.
- Column header row: Specify which row contains your headers (usually row 1)
- Column mapping: Ensure the ShareFile fields (such as Client name and Client type) match the correct columns from your Excel file
Note:
If you're using the official ShareFile template, the mappings should align automatically.
-
Review and import: Click Next to go to the review step.
- Verify that the client names, types, and contact details appear correctly in the preview
- Click Import when everything looks accurate
-
Confirm success: A progress indicator appears while the import processes. Once complete, you'll see a list of successfully imported clients.
- Click Close to return to the client hub
- Click View to open a specific client record
-
Configure your clients: Navigate to each newly created client to assign team members, set up Projects, Tax engagements, or connect files and folders.