# 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.

Source: https://quenza.com/help/switch-to-quenza/from-a-spreadsheet/

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](https://quenza.com/help/clients/import-clients/) 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

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

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 guests, see [Add clients](https://quenza.com/help/clients/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](https://quenza.com/help/billing/client-limits/).
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.

## 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](https://quenza.com/help/clients/import-clients/) for the details and what to do when rows fail.

## Next steps

- Put clients who work together in [groups](https://quenza.com/help/clients/groups/).
- Rebuild the worksheets you send as [activities](https://quenza.com/help/content/build-an-activity/).
- Follow the rest of [Plan your switch](https://quenza.com/help/switch-to-quenza/plan-your-switch/).
