How to create and use Merge Templates in Zoho Sheet

Using Merge Templates in spreadsheets

Merge Templates in Zoho Sheet allows you to create spreadsheets with dynamic data fields with data fetched from external sources, and save the data records as files in Zoho Sheet or share them via email to respective stakeholders.

Convert to Merge Template 

In order to start adding merge fields to your spreadsheet, it has to be converted into a Merge Template.
 
To get started:
  1. Open the file you'd like to convert into a Merge Template or create a blank spreadsheet.
  1. Go to Tools > Merge Template
  1. Click Proceed to complete the conversion.


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

Add source 

Once the file is converted into a Merge Template, the next step is to choose the desired source for the data to be fetched from. Zoho Sheet currently supports the following sources:
  • Desktop
  • URL
  • Zoho Sheet
  • Other services
 
NotesAlternatively, you can also choose to add fields first and configure the respective source later.
 

How to add a source file for merge template 

To add a source file from your device:
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. Select the Click to add source option in the side pane.

  1. In the Data source dialog, choose the desired source from the left pane.
  1. To upload from your desktop, browse files, or drag and drop the desired file into the dialog.
  1. In the case of CSV files, you can choose the appropriate delimiter, date format, and more before uploading.
  1. 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.

  1. You can further select the fields to import from the source file or service.
  1. Once the fields are chosen, review the mapped headers and make changes if needed and click Map Fields.
 

Insert dynamic fields into the spreadsheet 

To add the dynamic merge fields into your spreadsheet, make sure you have added a source before moving to the following steps:
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. Select or edit the desired cell where you wish to add the field.
  1. 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 

To add, edit, or delete fields in your spreadsheet:
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. Click on the Manage option above the list of fields in the side pane, or the Create Field option below the list.
  1. In the Manage Fields dialog, use the Create Field option to add a new field and map the respective header from the source.

  1. Select any field or mapped header to make changes.
  1. To delete a field, hover over the respective field and click on the  icon that appears beside it.
 

Filter values from chosen fields 

You can choose to filter a certain range of values from the selected fields as the data source.
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. Click on the filter icon  near the source name in the top-right corner of the side pane.
  1. In the Filter Records dialog, choose the desired field and criteria to filter.
  1. Use the And and Or options to create multi-level filters.
  1. You can choose to edit or delete the filters anytime.


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

Preview merge template 

Before proceeding with the merge action, you can get a preview of the merge templates with the desired fields.
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. Click on Preview
  1. In the preview pane, choose the field based on which you'd like to view the merge template using the dropdown.
  1. Click on the desired value from the list to view the merge template with the respective data record values.




Merge actions 

Once the merge fields have been mapped, you can choose the desired action to perform with the dynamic data records.
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. 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 

Zoho Sheet provides free and paid users with respective credit limits for performing merge actions. All users having access to the paid version of Zoho WorkDrive will be eligible to the paid credit limits. The limits provided are for the whole organization.
 
For free users:
Monthly credits for file save merge: 200
Maximum credits usable per day: 200
Monthly credits for email merge: 200
Maximum credits usable per day: 20
 
For paid users:
Monthly credits for file save merge: 1000
Maximum credits usable per day: 1000
Monthly credits for email merge: 1000
Maximum credits usable per day: 200
 
Credits required for each action:
Save as spreadsheet(s): 1 credit per record
Email as attachment (XLSX format): 1 credit per record
Email as attachment (PDF format): 1 credit per record
 

View merge logs 

Zoho Sheet provides you with the details of every merge that happens inside the spreadsheet. This helps you keep track of the merges performed by you and the collaborators in the current spreadsheet.
  1. Go to Tools > Merge Template or use the Merge Template icon  in the right pane.
  1. 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.
Notes
Only the organization admin can enable/disable merge template for their users, access the plan details, and proceed with renewal or upgrade from the admin dashboard.

For any further queries, contact us at support@zohosheet.com.

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                            Manage your brands on social media

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                               
                                                                

                                                              Videos

                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                Zoho Sheet Resources

                                                                 

                                                                    Zoho Forms Resources


                                                                      Secure your business
                                                                      communication with Zoho Mail


                                                                      Mail on the move with
                                                                      Zoho Mail mobile application

                                                                        Stay on top of your schedule
                                                                        at all times


                                                                        Carry your calendar with you
                                                                        Anytime, anywhere




                                                                              Zoho Sign Resources

                                                                                Sign, Paperless!

                                                                                Sign and send business documents on the go!

                                                                                Get Started Now




                                                                                        Zoho TeamInbox Resources





                                                                                                  Zoho DataPrep Demo

                                                                                                  Get a personalized demo or POC

                                                                                                  REGISTER NOW


                                                                                                    Design. Discuss. Deliver.

                                                                                                    Create visually engaging stories with Zoho Show.

                                                                                                    Get Started Now









                                                                                                                        • Related Articles

                                                                                                                        • Link data across spreadsheets quickly

                                                                                                                          What is IMPORTRANGE, and when to use it? One of the impressive things about spreadsheets, as opposed to other applications for computation or data storage, is being able to refer to the value of one cell in whichever cell you want, even as part of a ...
                                                                                                                        • Create spreadsheets from templates

                                                                                                                          To create a new spreadsheet from templates, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Simply tap to open the desired template from the default template gallery. You can immediately start editing the ...
                                                                                                                        • Create a new spreadsheet using Templates

                                                                                                                          Public Templates Public templates are pre-built ones that you can choose from. To view the list of Public Templates and select one for your spreadsheet: Select Templates from the file listing page. Select Public Templates from the options. Tap any ...
                                                                                                                        • Access a list of my recent spreadsheets

                                                                                                                          Access your recent spreadsheets easily without having to search through the entire collection of spreadsheets used. Click on the File menu. From the drop down, hover over Open. A list of your recent spreadsheets will be displayed. Click on the one ...
                                                                                                                        • Merge cells

                                                                                                                          To merge cells in your spreadsheet: Select the desired range of cells you wish to merge. Go to the Home menu and tap Select any desired merging option from the available options.
                                                                                                                          Wherever you are is as good as
                                                                                                                          your workplace

                                                                                                                            Resources

                                                                                                                            Videos

                                                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                            eBooks

                                                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                            Webinars

                                                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                            CRM Tips

                                                                                                                            Make the most of Zoho CRM with these useful tips.



                                                                                                                              Zoho Show Resources