Client records without Excel: import, export and search
If you have kept your client records in an Excel sheet, you don't have to enter your clients again one by one: save the sheet as a CSV file and import it in three steps.
Import in three steps
- 1
Pick the file
A comma-separated CSV file from your computer, tablet or phone.
- 2
Map the columns
You say which CSV column matches which field in the CRM.
- 3
Upload
The clients enter the database in one go.
For finding them again there is a filter row above the list: filter by who the client is assigned to, which tags and groups they carry, when they were added, whether they are a subcontractor, and search by client name or by the contact's name, email address and phone number. By default the list shows active clients only, and a filter brings up the inactive ones. Tags and assigned users can be changed right in the list, without opening the client.
You can also download your clients at any time: the Export button on the list packs a CSV file that opens in Excel and the files uploaded to your clients into a ZIP file, with a separate folder for each client. Besides the basic details, addresses and contacts, the CSV also contains the tags, client groups, assigned users and custom fields. Your data is not locked into the system.