Here we explain how you can import existing address data into Wice CRM in just a few steps. You need to have them available in an Excel file - of course you can also import several files one after the other, check for duplicates or update existing data.
To be able to import addresses in general you need access to the administration!
Click in the menu bar on More and then on Administration and then under Toolbox on Data import.
Under Excel click on Select file and select the file with the address data you want to import. Please note that the import file must be in xlsx format - files in xls format are not supported.
When the upload is finished - this may take a moment, depending on the file size - click Next…
In the next step you can select the desired table, if your file contains more than one table - the number of contained rows will also be displayed.
Now the columns contained in the file are listed and you can specify for each column in which field in Wice CRM the contents should be imported.
Of course you have to assign only the columns you want to take over - the others will then not be taken into account.
If you want to update existing addresses with your import, then activate the checkbox “Update existing addresses” and if you activate this checkbox whether you want to leave the existing user groups of these addresses unchanged or update them. In the last case you have to activate the checkbox.
You can also define the fields on the basis of which the duplicate check should be performed - both for the organizations/companies and the persons.
Set the criteria here - then you can select whether you want to import all records or just a few rows. This is especially recommended if you want to update existing data to check that everything works as expected or if your data contains a lot of records.
When all preparations and settings are done, just click on Start import and off you go!
The import will now be queued and run in the background. This can take some time - when the import is finished you can see this at the respective status and you can check in the log how the data was transferred or the duplicate check was successful.