Skip to content
Quenza
MCPNew: use this help center in Claude, ChatGPT or CursorConnect →

From a spreadsheet

2 min read

Move a client list from Excel, Google Sheets or Numbers into Quenza by preparing three columns and importing the file in one go.

Many practices start with a spreadsheet: one row per client, with their name, email address and a few notes. Quenza’s import reads that list directly, so every client is in your workspace in minutes. This page shows how to prepare the file; the import itself takes three clicks.

For example, Sarah Bennett kept her clients in a Google Sheet with columns for name, email, phone, start date and package. She copies the names and email addresses into Quenza’s template, imports it, and keeps the sheet as her archive.

Quenza imports three things per client, all required:

Column Example
email emma.clarke@example.com
first_name Emma
last_name Clarke

Other columns, such as phone numbers, dates or notes, are not imported. After the import you can add a client’s other details on their profile.

  1. In Quenza, go to Clients, click Bulk import and download the template as Excel (.xlsx) or CSV (.csv).
  2. Copy the email addresses, first names and last names from your spreadsheet into the template’s three columns, one client per row.
  3. Check the list before you import:
    • One name per column. If your sheet has the full name in one column, split it into first and last name. In Excel use Data → Text to Columns; in Google Sheets Data → Split text to columns.
    • Every row has an email address. Clients without one can’t be imported; add them by hand later as guestsGuestA client without a login. Guests get no invitation and cannot use the client portal or app, but Quenza emails them a direct link when you send an activity or share a note; you can convert them to an account later., see Add clients.
    • No duplicates. An email address can be used once in your workspace. Rows with an address that is already there are skipped.
    • Only current clients. Leave out people you no longer work with, emergency contacts and colleagues; every imported client counts toward your client limit.
  4. Save the file as Excel (.xlsx), or as CSV in UTF-8, so names with accents such as “Zoë” come through correctly. In Excel, choose CSV UTF-8 when you save.

You can also keep your own file: Quenza reads the columns by their names, so a sheet with the headers email, first_name and last_name works too, and other columns are ignored.

Go to Clients → Bulk import, upload the file and choose whether your clients get an invitation now or are added as guests. See Import clients for the details and what to do when rows fail.

Enlarged screenshot from this article