Import Data via Excel Templates

Data can be imported throughout almost all modules and sections. It is really useful if you have a large amount of information to upload, or if you are transferring data from another database.

Excel templates can also be used as a way to enter data quickly without having to go in the application itself. The data can later be uploaded in a batch, for example once or twice a week. 

1) Data can be imported through our excel templates only. A template can be downloaded via 'Tools – Import Excel – Excel' template in the top right corner of every section, or in the link indicated in the 'Import data wizard'.

Each section has a different template to download. If the data to import are communication records, then the Excel template must be downloaded from the Tools in the Communication section.

2) The columns in the Excel file match fields in the application. Some are mandatory to fill and others are optional. A comment “This element is required” indicates when it is mandatory.

Columns that are optional can be deleted from the template if not used. Columns can also be moved and it will not affect the data import. 

3) Once the excel if completed with information, it can be uploaded to the same place where it was downloaded from Tools – Import Excel – Excel template. Click Upload to select the excel file and Confirm.

4) If everything was entered correctly, then wait for the upload to be completed. If there are some errors (typos, forgotten mandatory fields, etc.) the import data wizard will show the line in Excel where something needs to be corrected. Correct the information and upload the file again.

If you want to upload documents at the same time as youimport data, please consult our article 'Import documents along with your data'.

 

Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request