- This guide will show you how to use the “Import” function within Durell, to import clients from an Excel spreadsheet.
- Please note, the spreadsheet must be saved in ‘.xls’ format
- Review and cleanse your data before importing. Are there any cells that need work, like taking letters out of phone number fields, taking special characters out of email address fields, etc?
- To begin, from the front screen of Durell, click on “Setup”. On the next screen, double click “Import” from the list on the right hand side
- A new window will appear. Select the top option for importing from an Excel spreadsheet, then locate the file that contains your import data, by clicking on the “Browse” button
- Locate your file, then click “Open” to add the file to the import window
You will see the file path for the import data added to the import window. Select the address set you are looking to import the data into and then click on the “Connect” button to display the import data in the “Preview” window
- The column headers from your spreadsheet will appear in the grey top row. All that is left is to link your columns to fields in Durell. Do this by selecting a Durell field from the yellow drop down boxes. You can see I have already selected “Search Name” and “Phone (mobile)”.
- Once all columns have been assigned a Durell field, click on “Import”
Related Articles
Address Records
Durell organises “Address Records” into “Address Sets”. These address sets are used to separate out different types of contacts, so you can keep your individual clients separate from your business clients who will be separate from your suppliers or ...
Creating a New Address Set
To create a new data set, starting from Durell’s Document Viewer… Click ‘New’ Click ‘Spreadsheet’ Click the “New” button in the “Setup Standard Data Field Set” dialogue Enter a name for your new set and click the “OK” button, for example, “New Set”. ...
Toolbar Explained
Most screens you go into in Durell will have our toolbar across the top. This toolbar is a broker’s main navigation around Durell. The icons: Exit Door Goes back a screen/to the main menu The Signpost This icon is the options button and gives you ...