Skip to main content

Bulk creating contracts using a CSV

Create multiple contracts in one go using a CSV file

Written by Sharen Gill

In three straightforward steps, batch-create contracts in Juro and prepare them to be sent for signing.

Step 1️⃣ : Creating a Juro template


To start, you must build your Juro template and add the necessary smartfields and signatories.

To do this:

1. In Juro, add the relevant smartfields to your template: you can leave these empty for now.

The names of these fields should match the header columns of your CSV file (e.g. 'Effective Date'. You should also select the relevant smartfield type for the data.
​
For example, in the above example, you would use a calendar-type field.

2. In the SIGNATORIES tab, add the signature links for future signatories.
​

The internal signatory must be pre-assigned, as in the image below. For external signatories, click + Add new signatory and press Enter; this will generate a placeholder Signature link that you can use later on.

3. Publish your template.

Step 2️⃣ : Downloading Juro's sample CSV


To do this:

1. From your Workflows page, click Bulk actions → + Add bulk action.

On the New bulk actions page, click Choose a template.

2. Select the Juro template you created earlier. On the next page, click Sample: this exports Juro's bulk create template, which automatically contains your template's smartfields as columns.

Now it's time to fill in the exported CSV with information you'd like reflected in your Juro smartfields.

Step 3️⃣ : Filling in and uploading your CSV 📄


In Juro’s sample CSV template:

  • Each column corresponds to the smartfields in your template

  • Each row represents a document that will be uploaded

  • Each cell is the data that will be input into the smartfields

Document name

This is the name you’d like the document to have in Juro.
​
This shows as the file name initially, but you can update this.

Document owner

The email address of the person who will own this document in Juro.

Signing side #2

This names the first counterparty on the uploaded contract.

Approvers

The email address of any approvers you'd like to add to those already on your template (internal or external emails can be used).

Recipients

The email address of anyone you'd like to receive sent for signing, signed by anyone and fully signed notifications for a contract.

Populate the relevant cells and leave the ones you don't need empty. You can leave the signatory, approver and recipient email columns blank, as these are for documents you intend to share externally through Juro.

When you're ready, save your CSV file. Then:

1. Back in Juro, click Upload CSV and select the CSV template from your desktop.

Review the import for errors (some troubleshooting tips here).


Where an error is flagged, you can amend the CSV and click Re-import CSV to upload the updated CSV file.

2. Complete the upload by clicking Create X documents. You'll be directed back to the bulk actions page, where you can view the upload.

Clicking the Show documents link lets you see the list of all imported documents in a customised, upload-specific View.

Troubleshooting errors 🔨


CSV files are sensitive to the data input. Where its columns don't match the parameters of the linked Juro field, the platform will generate an error.

These errors show on the final upload page: scrolling across, you'll see an ! icon next to any problem cells/columns. When you hover over this, Juro shows a recommendation to fix the issue in the source CSV file.
​
Occasionally, you may see an error saying that your CSV doesn't match Juro's bulk upload requirements. To see a list of any errors, click the errors here link:


​Finally, here are some additional questions to help you to troubleshoot errors during the bulk upload process.

Are all of your cell inputs in the correct format?

A common error we see with CSVs relates to date and number fields. Any CSV inputs that don't match the format of the Date & Number Region field in your Workspace settings will trigger an error. Similarly, CSV columns linked to a Choice smartfield must have inputs that match exactly an option in the Juro smartfield.

Does the data in your File Name column match the file name exactly (including capitalisation and file extension)?

You should also check individual cells and the file name on your desktop for accidental spaces added at the beginning or end of the file name.

Do the relevant stakeholders have access to the Juro template you're using?

Internal signatories, approvers and contract owners* must be in a group with access to the template you're using.
​
​*If they don't, ownership is assigned to the user uploading the documents.

Any signatories set on your template will be removed from contracts uploaded with the FULLY SIGNED status. On the confirmation screen, these documents display a yellow question mark icon and are listed in a separate Notices tab.

Managing special characters 🔣


CSV files with special characters (e.g. !, @, #) must be saved as a UTF-8 file.
​

Managing special characters from Excel

Download your CSV samples to your desktop. Then:


​1. Beginning with a blank Excel workbook, go to the Data tab and select Get Data, then click From Text/CSV and select the Juro CSV sample.
​
​2. In the import dialog, set the File Origin to 65001: Unicode (UTF-8) so Excel reads the special characters correctly.
​
​3. Delimit your Excel file: Select Delimited > Next, check the Semicolon and Comma delimiters and click Finish.

​
​​4. In the Import Data pop-up, leave the default value unchanged and press OK.

Managing special characters from Numbers (Mac users)

Download your CSV samples to your desktop. Then:

1. Click File > Export to > CSV. From the Text Encoding dropdown, select Unicode (UTF-8).
​
​​2. Select Next and specify the file destination.

Managing special characters from Google Sheets

If Excel continues to cause issues with special characters:
​
​​1. Open the CSV in Google Sheets (which handles UTF-8 natively).


​​2. Make your edits and download as CSV via File > Download > Comma-separated values (.csv): Google Sheets always exports as UTF-8.


​​3. Re-upload to Juro.

The bulk creation process is the same across your Juro environment: simply repeat the above steps in the relevant workspace.

You can learn more about troubleshooting your CSV import in our dedicated article.

💁‍♀️ As always, our Support Team is happy to help you with anything further if needed. Start a chat with us right here by clicking the Intercom button in the bottom-right-hand corner of this page.

Alternatively, you can email us at support@juro.com 🚀

Did this answer your question?