What
This is a guide to creating a personal Excel template for the main data entities stored within Mercury. It's a great way to customise the output of your Mercury CRM data, according to your own personal or teams' requirements. Once created, the template is accessible in the relevant entity under the Personal Excel Templates heading. You can quickly generate an Excel spreadsheet tailored to display Mercury data on-demand.
NOTE: The instructions in this article can only be carried out by your organisation's System Administrator.
Where
Settings > Advanced Settings > Templates > Document Templates
How - Downloading data to an Excel template
1. Open Settings and select Advanced Settings:
2. Select Templates > Document templates
3. Select + New > Download Excel Template
4. Select an Entity and a View. Optionally, Edit columns beforehand. Once complete, click Download.
How - Uploading data from an Excel Template
1. As per the numbered sequence in the image below:
Select the Entity to upload the Excel template data.
Click the ellipsis on the right-hand side of the ribbon menu.
Select Excel Templates.
2. Select Upload Template:
3. Then:
Choose File.
Click Upload File.
How - Opening or downloading the template
1. Select the required Entity
2. Click the ellipsis on the right-hand side of the ribbon menu
3. Select Excel Templates
4. The template should now be visible under the Personal Excel Templates heading:
5. When clicking into the Excel template that you've created, you will be given the option to Open the Template in Excel Online or Download the Template:
Important additional notes
Only when the Associated Entity of a template corresponds to the relevant Entity, will the template be visible under the Personal Excel Templates heading. So for example, if the template's Associated Entity = Placement, then the template will be visible under Personal Excel Templates heading when selecting the Placement entity. This is also true for Vacancies, Shortlists and Contacts.
However, the Activities entity is a little different. The parent entity is Activity, but this can then be broken down into the types of Activity > Phone Call, Email, Task, Appointment, etc. So to create an Excel template for a type of Activity (e.g Phone Calls) you should create a template with the Associated Entity of Activity. Then, when you wish to only report on a type of Activity, change the view in the Activities Entity in Mercury to the Activity that you want to report on (i.e. All Phone Calls view), find the template under the Personal Excel Template heading, and download it.