Documentation

Importing and exporting leads

Bring many leads into Esqase at once from a CSV file, or take your leads out as a CSV or JSON file, or as a Meta customer list for your ads. Both run in the background, so you can keep working while Esqase does the job, and Esqase tells you when it is done.

Before you begin

  • Where to find them. On the Leads page, open the ... (More lead options) menu next to New lead. It holds Import leads, Export leads, Recent imports and exports, and Manage sources.
  • Importing needs Create access for both leads and contacts, because each imported lead gets a new contact. Adding a source your firm does not have yet also needs Create access for sources.
  • Exporting needs View access for leads. A Meta customer list also needs Update access for Roles. See Exporting leads to Meta Ads.
  • Firm owners can do both.

Import leads

Download the template

  1. On the Leads page, open the ... menu and click Import leads.
  2. In the Import leads dialog, click Download template.

The template has one column per lead field, then one column for each of your firm's lead custom fields, and example rows that use your own sources, stages, and practice areas. Replace the examples with your leads.

ColumnWhat to enter
Contact typePerson or Company. Leave it empty for a person.
First name, Middle name, Last nameA person needs a first or last name.
Company nameNeeded for a company.
Email, PhoneThe prospect's contact details.
SourceA source name. A name your firm does not have is added, if you can add sources.
StageA stage name from your pipeline.
Practice areaA practice area name.
Matter typesMatter type names from that practice area, separated by semicolons.
Assigned toMember email addresses, separated by semicolons.
ValueLowest, Low, Medium, High, or Highest.
Estimated valueA number of zero or more, with up to two decimals.
PrivateYes or No.
StatusActive, Hired, or Not hired. Defaults to Active.

An empty cell is filled from your firm's lead template, and then from the usual default: the first stage, you as the assignee, Medium value, and not private. See Lead template.

Upload your file

  1. Drag your CSV onto Drag and drop a CSV, or click to choose, or click the area to pick it. One file holds up to 50,000 rows, one row per lead.
  2. Esqase shows Checking your file... while it reads every row.
  3. If your columns do not match the template, the dialog asks you to Match the columns in your file to lead fields. See Match your columns.
  4. Review the summary: the number ready to import, the number with issues (skipped), Examples of rows that will be skipped, and any New sources to add.
  5. Click Import followed by the number of leads ready. Esqase shows Uploading file... and then Importing leads... with a running count.

"You can close this. We'll notify you when the import finishes." Closing the dialog does not stop the import.

Match your columns

A file from another system rarely uses the same headings. When any heading does not match, Esqase shows a table with Column in your file, Lead field, and an Example value from your file.

  1. For each column, pick the Lead field it holds, or Skip to leave it out. Esqase suggests a match for common headings such as "E-mail", "Mobile", or "Surname".
  2. A single Full name column works for people: Esqase splits it at the last space into first and last name.
  3. You must match at least one column to First name, Last name, Full name, or Company name.
  4. Click Continue to check the file. To change the matching later, click Change column matching on the summary.

When the import finishes

  • If the dialog is still open, it shows Import complete with the number of leads imported and skipped, or Import failed with the reason.
  • You get an Import finished notification, for example "240 of 250 leads imported (10 skipped)", which opens the Leads page.
  • When rows were skipped, click Download skipped rows for a file of those rows with the reason for each. Fix them and import that file.

Imported leads arrive quietly: nobody is notified about each new lead, and the lead template's reminders, workflow, and form are not added. Import only adds new leads; it never updates leads you already have.

Common reasons a row is skipped

  • A person row has no first or last name, or a company row has no company name.
  • A stage, practice area, or matter type name does not match your firm's.
  • Assigned to names an email address that is not a member of your firm.
  • A source does not exist and you cannot add sources ("Source ... does not exist").
  • A required custom field is empty.

Export leads

  1. On the Leads page, open the ... menu and click Export leads.
  2. Step 1 of 2: Choose columns:
    • Format: CSV, JSON, or Meta customer list. A Meta customer list is a file you upload to Meta Ads Manager to build an ad audience from people whose Advertising consent reads Consent given; it has its own single step, described in Exporting leads to Meta Ads. The rest of this section covers CSV and JSON.
    • Status: tick the leads to include: Intake, Hired, Not hired, and Archived. The first three are ticked to start with.
    • Include private leads (firm owners only): tick it to export every private lead.
    • Columns: tick the columns you want, grouped as Lead, Contact, Intake, and Custom fields. Each group's checkbox selects or clears all of its columns.
  3. Click Next.
  4. Step 2 of 2: Order columns: drag the columns into the order you want in the file. The Preview shows example rows as your file will look. Click Back to change your choices.
  5. Click Export. You see Export started.

"We'll prepare the file in the background and email you a download link. You need to be signed in to download it. The link expires in 7 days."

The columns you can choose:

  • Lead: Lead ID, Status, Stage, Value, Estimated value, Private, Origin, Created at, Created by, Updated at, Updated by, and Template.
  • Contact: Contact type, First name, Middle name, Last name, Company name, Email, and Phone.
  • Intake: Practice area, Matter types, Sources, Assigned to, and Converted matter.
  • Custom fields: every lead custom field your firm has.

Note: Private leads are left out of an export unless you are assigned to them. A firm owner who ticks Include private leads gets all of them.

Download your export

When the file is ready, Esqase emails you Your Esqase export is ready with a Download export button, and sends you an Export ready notification. Both open the export's page in Esqase.

  1. Open the link and sign in if asked.
  2. The page shows the export's status (Preparing, Ready, Failed, or Expired), the File, Format, Rows, Created, and Expires dates.
  3. Click Download.

While the file is being prepared, the page says so and checks again on its own, so you can leave it open or come back later.

Only the member who started an export and the firm owner can open its page. Anyone else sees Export not available. A Meta customer list also needs the right to export customer lists when you open it: if the member lost Update access for Roles, or the firm has since accepted the business associate agreement, its page shows Export not available too. See Exporting leads to Meta Ads. If the export belongs to another of your firms, the page offers Open in that firm, which switches your active firm.

Important: The download link stops working 7 days after the export finishes, and the file is deleted. Start a new export from the Leads page if you need it again.

An export holds up to 100,000 leads. A larger one fails with a message asking you to narrow the filters, and you get an Export failed notification.

Recent imports and exports

Open the ... menu on the Leads page and click Recent imports and exports.

  • Recent imports lists your last 10 imports of each kind, on the Leads, Contacts, and Matters tabs, with each file's status (Waiting, Importing, Completed, Completed with skipped rows, or Failed), the rows imported, and when. Download skipped rows appears where rows were skipped.
  • Click Recent exports for your last 10 exports, each with its status, rows, and expiry date; a customer list also reads Meta customer list. Click Open to go to an export's page.

Let the AI Assistant import or export for you

You can ask the AI Assistant to do this work. Attach a CSV to the conversation and ask it to import the leads, contacts, or matters in it. The assistant reads the file's headings and a few rows, works out how they match Esqase's fields even when they differ from the template, and asks you to confirm before it starts. You can also ask it to export your leads as CSV or JSON, with the columns and statuses you name, and to tell you how an import or export is going. The work runs in the background exactly as it does from the dialogs. A Meta customer list can only be started from the Export leads dialog. See AI Assistant.