Before you start
- You need User Management to open Data Import, and the right to add clients.
- "Who you sell to. Used in enquiries, projects, quotations, and invoices."
Steps
- Select your name at the bottom of the sidebar.
- Select Data Import.
- On the Clients card, select Download template. The file clients_template.xlsx downloads.
- Fill in one client per row from row 3: name, email, phone, companyName, address, status, notes.
- Save the file.
- On the Clients card, select Bulk upload and choose the file.
Result
A message shows how many clients were created, and the card's badge changes to "Done" with the number of records. Select Open Clients to see them.
Next: Import open enquiries from Excel.
If something is different
- "Bulk upload failed": nothing was imported. Fix the rows and upload again. See Bulk upload failed with errors in my Excel file.
- You run AMC contracts: import clients before contracts. "Best imported after Clients."
- From the Clients page: on CRM › Clients, Download Template gives clients_bulk_upload_template.xlsx, and Bulk Upload takes an .xlsx or .xls file under 500 KB. Both need Add on Customers. Row errors open "Bulk Upload Failed: [number] Error(s) Found". "File must be under 500 KB (use fewer rows to avoid timeout)" or "Upload timed out. Try a smaller file or fewer rows.": split the file.
