How to import or update clients using the Excel import tool.

You can import/create or update clients in bulk using the Excel import tool, follow these steps:

  1. Firstly note you need to be a superuser to use the import tool.
  2. Download the spreadsheet. Which one you need depends on what you are doing:
    • Importing new clients: click on the Config menu, then Import Clients, and click Download spreadsheet (xls). This is an empty spreadsheet.
    • Updating existing clients: click on the Config menu, then System Options. Click on the Export Client Data tab, then click Download Microsoft Excel spreadsheet (xls). This is the same spreadsheet, filled with your existing client data. It can take several minutes to create.
  3. This will download the spreadsheet to your device, note that the spreadsheet is an Excel file (not a csv file) and you should keep the file in this format for the import to work.
  4. Enter data into the spreadsheet and save the changes. The Import Clients page has a link to the Import Guidance Document, an interactive guide. We recommend you read it to make sure you can make full use of the import capabilities.
  5. Click on the Config menu, then Import Clients (if you are not already there). Click on the I have completed the spreadsheet. Continue to next step button.
  6. Click on the Select completed spreadsheet button, find the file on your device and click open.
  7. Assuming the system detects new clients or changes to existing clients you will see a preview of the data (for UK users this will not currently show data that will be obtained from Companies House). If you wish to make changes click Cancel otherwise you can click Confirm spreadsheet import. At this point data will be imported into the system.
  8. You will then see the data that has been imported, for UK users now including data obtained from Companies House. You can optionally click on Create jobs to bulk create jobs, this is recommended where you have imported dates to trigger fields that will give rise to past auto creation dates.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us