---
description: >-
  Bulk creation is handy when you have the same document template, where a few
  parameters change for each signer.
---

# Bulk creation of documents

Whether you need thousands of customers to accept updated terms or hundreds of employees to sign off on a new employee handbook, bulk creation provides a seamless solution for companies of any size.

{% embed url="https://www.youtube.com/watch?t=13s&v=25hNc-OD0_o" %}

### How to bulk create documents for signing in Agrello?

To better understand how you can bulk create documents from the template, let's go through an example where changes to the Employee Code of Conduct document are sent to employees for signature.

‍**The process consists of three steps:**

1. Preparation of the document template and the Excel spreadsheet with the data.
2. Creating a document template in Agrello
3. Bulk creating the documents from the template

#### Preparation

‍First, the template document must be prepared in Microsoft Word and the fields that are employee-specific can be marked as dynamic fields using **\{{curly\_brackets\}}**.

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2Fs14ol6c1nnzrK6IKtP6q%2F68b2b2d8-d08b-419a-9bbc-e123b54c4197.png?alt=media&#x26;token=9b347a53-e8ac-4850-99de-2967b74939a3" alt=""><figcaption></figcaption></figure>

‍

Dynamically filled fields must be entered in Word with curly brackets, for example **\{{employee\_name\}}**. To avoid errors, you mustn't use punctuation or spaces in the text enclosed in parentheses.

Next, we prepare an Excel file with a list of all employees and the data to be included in the document. A separate row must be created for each employee and a column for each dynamic field.

‍The table must contain the e-mail address of the employee to whom the invitation to sign should be sent.

#### <img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FkDFQwkFWXMWlK6244DWi%2F6452523f-edae-48d8-9a70-91c26b53e26e.png?alt=media&#x26;token=af6107f2-5f2c-4608-a855-7e84ab96a60b" alt="" data-size="original">

#### &#x20;Creating a document template in Agrello

**1. Upload document template**

‍In Agrello you can easily create a document template. You need to select the **"Template"** option in the **"Create New"** menu and then simply upload the prepared Word file.

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FiyjkY3zSYsUnLzMX9rdw%2Fcbed325b-81b8-4386-a45e-f408a022e90d.png?alt=media&#x26;token=58e8097a-a6d5-44b8-8144-ebfd8fd52cbc" alt=""><figcaption></figcaption></figure>

Anyone can create an Agrello account by themselves and for free. With a free account, you can create three documents per month. So, for automating larger quantities, a paid account is required.

**2. Placing signature fields**

Once you have uploaded the document template, place the signature fields. In the document template preview add the signature fields to the correct place - scroll to the page where the signature should be and click on the **“Signature field”** button on the left pane. Place the field in to correct position and click on **“Save field”.**

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FphKtKu3tqXls71EkeQqf%2Fc745d9b4-78ba-4de6-bbcb-315dc56851b6.png?alt=media&#x26;token=60832b6f-fcb2-474f-8fd8-02e7aa62fdf3" alt=""><figcaption></figcaption></figure>

#### Bulk creating documents from the template

Now you are ready to connect the Excel file and the Word template to create multiple documents for signing at once.

When you are still in the document template view click on the **“Use template”** button and choose **“Bulk create documents”.**

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FskcrT15i3iXRzbrMp3Ya%2F3d8d47ff-a600-4f23-b71b-ff4b376b5e5f.png?alt=media&#x26;token=42e93953-e37d-4c78-b7e1-e8ce849a5021" alt=""><figcaption></figcaption></figure>

This will open a bulk creation wizard.

**Step 1. Upload Excel**

Choose the Excel file with your employee records.

Note that our system allows importing 1000 rows from a single file.

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2Fzqs2DnhmABRtWeNyyMYL%2F0c8eff9a-da4b-4516-9226-d3530d26f71c.png?alt=media&#x26;token=ea42a78e-604d-4ed6-987b-7fc271924b78" alt=""><figcaption></figcaption></figure>

**Step 2. Map the signature fields**

In step 2 you need to define from which Excel column we will find the employee email.

Select the correct column and click Continue.

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FuVNwZtKcgVpt99dcygna%2F0b95a648-61ed-4260-8da9-caf94731b4cd.png?alt=media&#x26;token=14d39b82-9197-40f8-a4b4-927a44fd26ee" alt=""><figcaption></figcaption></figure>

**Step 3. Fill in the data fields**

In this step, you need to map available data fields in the template to the columns in Excel. This example only has one data field to be mapped - Employee name.

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FAWDykgXm9chQiqwa6krg%2F5513d3a2-a698-4cd8-a9be-7e65fbfedc0d.png?alt=media&#x26;token=3c89607d-f573-419c-8ca6-969e6cf5ccac" alt=""><figcaption></figcaption></figure>

Click **Continue** to proceed.



**Step 4. Document naming and destination**

In the final step, we define the dynamic name of each document and destination Space in Agrello. The dynamic document name is composed of the template name + one of the data columns. For example _Employee Code of Conduct - Jarmo Tuisk._

<figure><img src="https://2931725216-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyec8PpbkRWjBYStjkAcr%2Fuploads%2FAMk66BF5xooS8Y4IXQpW%2Fbb2bfef3-3fe8-42b6-a929-c6872602fb14.png?alt=media&#x26;token=3bcadf94-6aee-4a10-9488-d5c69df8affa" alt=""><figcaption></figcaption></figure>

Once that is done, click **Submit**.

Depending on the number of rows in Excel the document creation process can take from a few seconds up to a couple of minutes. So if you do not see the documents immediately, wait a bit and then refresh the space screen.

All the documents are created as **Drafts** and you can safely review them before sending them off to counte&#x72;**-**&#x70;arties.&#x20;

Once sent, you can track the process and completion of your documents in your document space Progress view.&#x20;

You can also send reminders to any party or signee who has not taken the required action on a document.
