Convert to Merge Template 

1. Open the file you'd like to convert into a Merge Template or create a blank spreadsheet.

2. Go to Tools > Merge Template

3. Click Proceed to complete the conversion.

Once the file is converted into a Merge Template it cannot be reversed.

Add source 

• Desktop

• URL

• Zoho Sheet

• Other services

Alternatively, you can also choose to add fields first and configure the respective source later.

How to add a source file for merge template 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Select the Click to add source option in the side pane.
   

3. In the Data source dialog, choose the desired source from the left pane.

4. To upload from your desktop, browse files, or drag and drop the desired file into the dialog.

5. In the case of CSV files, you can choose the appropriate delimiter, date format, and more before uploading.

6. For Zoho Sheet and other services (i.e. Zoho CRM, Zoho Forms and Zoho Creator), the files and modules from the respective service will be displayed for you to choose from.
   

7. You can further select the fields to import from the source file or service.

8. Once the fields are chosen, review the mapped headers and make changes if needed and click Map Fields.

Insert dynamic fields into the spreadsheet 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Select or edit the desired cell where you wish to add the field.

3. From the list of fields displayed in the side panel, drag and drop the desired field to the cells, or use the  sign alongside the respective fields.
   

Add, edit, or delete fields 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Click on the Manage option above the list of fields in the side pane, or the Create Field option below the list.

3. In the Manage Fields dialog, use the Create Field option to add a new field and map the respective header from the source.
   

4. Select any field or mapped header to make changes.

5. To delete a field, hover over the respective field and click on the  icon that appears beside it.

Filter values from chosen fields 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Click on the filter icon  near the source name in the top-right corner of the side pane.

3. In the Filter Records dialog, choose the desired field and criteria to filter.

4. Use the And and Or options to create multi-level filters.

5. You can choose to edit or delete the filters anytime.
   

 

Only the values based on the applied filter will be used in the merge actions.

Preview merge template 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Click on Preview

3. In the preview pane, choose the field based on which you'd like to view the merge template using the dropdown.

4. Click on the desired value from the list to view the merge template with the respective data record values.
   

Merge actions 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Under Merge Action in the side pane, choose the desired option based on your use case.

 

• Save as new spreadsheet(s) - Each data record will be saved to your WorkDrive account as a new Zoho Sheet file. Upon clicking Merge, you can select the file names, and the folder in which you wish to save the files. Click Merge to start creating the new spreadsheets.

• Email as attachment - Each data record will be sent as an email attachment to the selected recipients. Upon clicking Merge, you can enter the details for the emails to be sent. You can either choose to enter the email addresses manually or pick the desired source for the email addresses, messages, subject, etc using the  icon alongside each field. Zoho Sheet currently supports two file formats for attachment—XLSX and PDF which you can choose from. Click on Merge to start sending out the emails.

Credit Details 

View merge logs 

1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.

2. Click View Logs at the bottom of the side pane.
   

The logs dialog will display all the details regarding the past merges that have occurred in the spreadsheet including the spreadsheet name and the status of the merge.

Collaborator permissions for merge 

• All collaborators with the access to edit the spreadsheet can create a new merge, and modify an existing merge.

• Only those collaborators with access to the respective connected source data can run a merge in the spreadsheet. The merge actions will be performed in the respective collaborator's account.