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

  1. Select your name at the bottom of the sidebar.
  2. Select Data Import.
  3. On the Clients card, select Download template. The file clients_template.xlsx downloads.
  4. Fill in one client per row from row 3: name, email, phone, companyName, address, status, notes.
  5. Save the file.
  6. 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.