Importing Data

3 min read

Bring clients, services and leads in from a spreadsheet, and the rules each importer follows.

Bring clients, services and leads into Clientish from a spreadsheet, or move everything over from another tool.

Overview

This guide covers the three file importers and the rules they share.

Who Can Access

Agency AdminTeam Member

Team members need Import Clients, Import Services or Import Leads.

Step-by-Step Guide

  1. Download the template

    On Clients, Services or Leads, click Template. Use its column headings exactly. There is no step to match columns.

    Clients page buttons: Import, Template, From another tool, Export and Add Client
  2. Fill it in

    One row per client, service or lead. Up to 2,000 rows and 500 KB per file.

  3. Import

    Click Import and choose the file. For services, a window opens first with Download template and Choose file.

    Import services window with Download template and Choose file
  4. Read the result

    A message says how many were added and lists the rows that were skipped and why.

What Each Importer Does

ClientsServicesLeads
File typesCSV, XLS, XLSXCSV, XLS, XLSXCSV
RequiredFirst Name, Last Name and Email columns; First Name and Email filledNameAn email column
DuplicatesAn email already in your workspace is skippedNot checkedAn email already used by a lead, client or team member is skipped
Comes in asInactive, no welcome emailDraft unless a Status is givenStatus New, source Import

Good to Know

  • Imported clients can’t sign in until you turn on Account active.
  • Your plan limits apply. A services file that needs more room than you have is refused whole.
  • The services and leads templates include example rows. Delete them before importing, or they become real records.
  • Unknown service categories are created; unknown folders and team emails are ignored.

Frequently Asked Questions

“The file is missing required column(s)”⌄
Download the template and use its column headings.
More than 2,000 rows?⌄
Split the file and import each part.