Skip to main content

Importing Your Clients into Socket

How to import your client list into Socket from the template, what each column holds, how re-importing updates existing clients, and what to do if the upload is refused.

Written by Si Evans

Importing your clients

Open the import: Go to Clients in the main menu, then select Import at the top right of the page.

Can't see the Import button? It's hidden when a CRM integration such as XPM or Karbon is connected. Your clients sync across from the CRM as you create proposals, so there's no list to import.

Download the template: The Import Clients window opens. Select Download Template to get a spreadsheet with the correct column headings.

Fill in your clients: Open the downloaded template and fill in your client details under the column headings, either by copying them from another system or typing them in.

Upload the file: Back in the Import Clients window, select Select File and choose the file you just saved. It can be a CSV or XLSX file. Socket processes the file and adds the clients to your account.

The template columns

The template has these columns:

  • Client Code: only present when client codes are turned on for your practice, and then it's the first column.

  • Client Name

  • Company Number: Australian practices see ABN here instead.

  • Entity Type: pick from the list in the cell.

  • Status: pick from the list in the cell, which includes Ad Hoc.

  • Financial Year End: a date in YYYY-MM-DD format.

  • Primary Contact Name, Primary Contact Email and Primary Contact Phone

  • Secondary Contact Name, Secondary Contact Email and Secondary Contact Phone

  • Owner Email and Manager Email: a team member's email address, which sets the client's owner and manager. An email that doesn't match anyone on your team stops the import with one error listing the rows to fix.

Updating clients you've already imported

You can import a file again to update clients already in Socket. A different Owner Email changes the owner, a blank Status leaves the client's current status as it is, and closed clients stay closed.

If the upload is refused

If Socket finds a problem with the file, it shows We found issues with the content of your file with each error, how many rows it affects, and the row numbers, so you can fix the file and upload it again.

A spreadsheet with cells that hold formulas, such as lookups to another tab or workbook, is refused with one message naming the columns affected. To fix it, select everything in the sheet, copy, then Paste Special > Values so the cells hold plain text, and upload again. CSV files aren't affected.

A row whose Client Code already belongs to a client with a different name is refused with "Client Code X belongs to Y, not Z. Correct the code, or rename the client in Socket first." A code shared by several clients is refused too.

Did this answer your question?