Contents

Import and export clients as CSV

Import and export clients as CSV

Short answer: on My Clients, choose Import CSV to bring in the clients you already have, or Export to take your clients or confirmed document fields to another system.

Import a client list

  1. Export your list as a CSV file from Excel, Google Sheets, Numbers or your CRM.
  2. On My Clients, choose Import CSV. Pick the file, or paste the rows.
  3. Choose Check the file. hivi-x matches your column headers to client fields. Change any match that's wrong.
  4. Review the rows. Each one is Ready, Skipped (already on file, or repeated in the file) or Needs fixing (no name, an invalid email, a date of birth it can't read).
  5. Choose Import. Only ready rows are created. The result lists every row that wasn't imported and why.
ColumnNotes
Name, or first and last nameRequired
EmailOptional. Used to skip clients you already have.
PhoneUp to 20 characters
AddressUp to 500 characters
Date of birthYYYY-MM-DD, or a date with the month written out (March 15, 1984 / 15 mars 1984). A date like 03/04/1984 could be read two ways, so it's refused.
NotesUp to 5,000 characters
TagsSeparated by commas, semicolons or vertical bars
SourceReferral, website, open house and other lead sources
StatusInactive (or inactif, archived) imports as inactive; anything else as active

What importing never does

  • It never emails your clients or creates accounts for them. Nothing is sent to an imported client until you choose to send them something.
  • It never changes a client you already have. Matching emails are skipped, not overwritten.
  • It never goes past your plan's client limit. Starter allows 50 clients; Professional and Enterprise are unlimited. The preview shows how many rows fit.

Export

On My Clients, choose Export:

  • Clients (CSV): every client with name, email, phone, address, date of birth, status, source, tags, notes and when they were added. The columns match the import, so the file can go into another system, or back into hivi-x.
  • Confirmed document fields (CSV): the values you confirmed with Read fields, one row per field, with the client, checklist, item, file and document type. Unconfirmed values are never exported.

Exported files open in Excel with accents intact. Cells that a spreadsheet would treat as a formula are made safe.

Limits

  • 2,000 clients and 5 MB per import, and 20 imports per hour.
  • Clients only. Checklists, files and documents aren't imported.
  • No two-way sync. Webhooks send clients and checklist events out as they happen, and the hivi-x app for Zapier (invite-only while Zapier reviews it) can also add clients one at a time from another tool.

Related

Answers are general operational information only — not legal, tax, regulatory, clinical, privacy, immigration, or professional advice. Requirements vary by matter, client, and regulator.

Frequently asked questions

Can I import my existing client list?
Yes. Export the list from your spreadsheet or CRM as a CSV file, then on My Clients choose Import CSV. Check the preview and import. Up to 2,000 clients per file.
Will my clients get an email when I import them?
No. Importing doesn't email anyone or create accounts. Nothing is sent to an imported client until you choose to send them something.
What happens to clients I already have?
A row whose email matches a client you already have is skipped, and so is a repeat of an email earlier in the same file. Existing clients are never changed by an import.
Does the import count against my plan?
Yes. Imported clients count like clients you add by hand. On Starter (50 clients), the preview shows how many fit. Rows beyond the limit are listed as over the limit and not imported.
Which columns can I import?
Name (or first and last name), email, phone, address, date of birth, notes, tags, source and status. Only the name is required. English and French column names are recognised, and you can change any match.
My file came from French Excel and uses semicolons. Will it work?
Yes. Comma, semicolon and tab files all work, including Excel's older Windows encoding, so accented names come through intact.
Can I export my data?
Yes. Export on My Clients gives you a CSV of all your clients, or of the document fields you confirmed with Read fields. Unconfirmed values are never exported.

Organize client document intake with checklists

hivi-x helps Ontario professionals collect client documents with reusable checklists, secure Canadian hosting, and exportable PDF packages.

Import and export clients as CSV | hivi-x Docs