Switch to Quenza
From a spreadsheet
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.
What Quenza needs
Section titled “What Quenza needs”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.
Prepare the file
Section titled “Prepare the file”- In Quenza, go to Clients, click Bulk import and download the template as Excel (.xlsx) or CSV (.csv).
- Copy the email addresses, first names and last names from your spreadsheet into the template’s three columns, one client per row.
- 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.
- 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.
Import the file
Section titled “Import the file”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.
Next steps
Section titled “Next steps”- Put clients who work together in groups.
- Rebuild the worksheets you send as activities.
- Follow the rest of Plan your switch.
Was this article helpful?
Thanks for letting us know.
Thank you. We read every answer and use it to improve this article.