LogoLogo
ClausesDatafieldsSpecial FunctionsStylingQ&AAPI
  • Welcome!
  • Getting started
    • What is Clause9?
    • Structuring your clause library
    • Structuring your clauses
    • Drafting modes in Clause9
    • Creating a questionnaire
    • Sample clauses
    • Videos
      • Concepts and datafields
      • Conditions
      • Q&As
      • Binders
      • Styling
      • Enumerations
      • Tables
      • Definitions
      • Snippets
      • Cross-references
      • Special functions
      • Examples of common clauses
      • Import clauses from MS Word
      • Grammatical conjugations
      • Action buttons
      • Alternative clauses
  • Assemble document
    • Document toolbar
    • Clause hierarchies
    • Focus Mode
    • Bulk generation of documents
    • Exporting documents
    • Assemble Document - FAQ
    • How to: Assemble Document
      • Insert images
  • Assemble Document Operations Panel
    • Operations panel
    • File pane
    • Edit pane
    • Document pane
    • Binder pane in the operations panel
    • Search pane
    • Browse pane
    • Terms pane
    • Data dashboard
    • Advanced pane
    • Styling pane
    • Miscellaneous pane
    • Visibility settings & actions menu
  • Binders
    • Binders: general
    • Styling cross-references to subdocuments
    • Global and local definition lists
    • Document and binder properties
    • Styling of a Binder versus subdocuments
    • (Un)locking documents in a binder
    • Binders - FAQ
    • How to: binders
      • Make a subdocument in a binder conditional
  • Clauses
    • Introduction to clauses
    • Clause structure
    • Grammar sheet
    • Writing conditions
    • Examples of conditions
    • Using codes instead of text fragments
    • Bold, italic and underline
    • Special codes
    • Enabled?
    • Links
    • Cross-references
    • Introduction to tables
    • Deviating table styling
    • Shrinking clauses
    • Action buttons
    • Enumerations
    • File position
    • Snippets
    • Parameters
    • Conjugations
    • Mixing data types
    • For-loops
    • Clause versioning
    • Abstract article references
    • Advanced multi-language features
    • Clauses - FAQ
    • How to: clauses
      • Create an ad-hoc clause
      • Create a library clause
      • Make a clause repeat
      • Make a paragraph within a clause conditional
      • Use a shortcut to refer to a concept
      • Insert a line break or page break
      • Creating a list with both predefined options and free input
      • Defining alternative clauses
      • Creating cross-references
      • Creating signature blocks
      • Creating advanced party introduction clauses
      • Automatically numbered annexes or schedules
      • Reuse any clause in a different context
      • Setting MS Word document properties
      • Add action buttons to clauses
      • Electronically signing documents
  • concepts
    • Introduction to concepts
    • Creating concepts
    • Concept labels
    • Links
    • Organising concepts
    • Concepts - FAQ
    • How to: concepts
      • Add predefines to a datafield
  • Datafields
    • Introduction to datafields
    • Types of datafields
    • Rules of thumb for using datafields
    • Data-expressions
    • Datafield aliases
    • Datafield labels
    • Datafield special tags
    • Datafield descriptions
    • Repeating list datafields
    • Datafield predefines
    • Datafields - FAQ
    • How to: datafields
      • Change datafield type
      • Change the datafield's name or alias
  • Definitions
    • Introduction to definitions
    • How to: definitions
      • How do definitions work?
      • Create a definition
  • Files
    • How files are organised
    • Browse files
    • File types
    • Custom styling
    • Legal comments
    • File description
    • Attributes
    • Reporting
    • File name
    • File category
    • Access rights
    • How to: files
      • Creating advanced folders
      • Naming your files
      • Shortcuts to folders or files
  • Q&A
    • About cards
    • Cards pane
    • About changes
    • Changes pane
    • Types of changes
    • Adding conditions
    • Question options
    • Copying & pasting answers
    • Comments, notes & documentation
    • Interactive Q&A inspection
    • Embedding questions into a document
    • “Changes” button
    • Batch create pane
    • Identifiers pane
    • Import pane
    • Edit clauses pane
    • Q&A options
    • Q&A - FAQ
    • How to: Q&A
      • Create predefined answers to a question
      • Add disclaimers
      • Create categories of questions
      • Modify the exported filename
      • Create a question to change the language of a document
      • Send a questionnaire to someone without a ClauseBase account
      • Create questions for repeating list datafields
      • Selecting legal entities & addresses
      • Create a questionnaire using "batch create"
      • Launch other Q&As
    • Leveraging ClauseBuddy Smart Templates in Clause9
  • Import
    • Introduction to importing clauses
    • Uploading clauses
    • Defined terms in Import mode
    • Datafields in Import mode
    • Cross-references in Import mode
    • Assigning folders
    • Conversion process
    • Exporting
    • Stashing intermediate results
    • Tips, tricks & limitations
  • Styling
    • Styling overview
    • Base styling
    • Numbering
    • Definitions styling
    • Enumerations styling
    • Locale styling
    • References styling
    • Page styling
    • Styling of a Binder versus subdocuments
    • Styling: tips and tricks
    • Advanced styling topics
    • Copying headers and footers from an MS Word file
    • How to: styling
      • Using custom fonts
      • Change bullet styling
  • Special functions
    • Introduction
    • Calculations
    • Concepts
    • Conditions
    • Conjugations
    • Content Control Elements
    • Datafields
    • Dates & durations
    • Languages
    • Lists
    • Numbers
    • References
    • Repeating (looping)
    • Special items
    • Text structure
    • Text modification
    • User
    • Q&A
  • Settings
    • Account
    • Preferences
    • Access bundles
    • Favourites
    • Saved searches
    • Saved datafields
    • Styles
    • Default styles
  • Admin
    • General
    • Users
    • User rights
    • Profiles
    • Groups
    • Styles
    • Default styles
    • Attribute models
    • Usage page
    • Custom homepage
    • Global placeholders
    • Access rights
    • How to: admin
      • Adding a new user
      • Disabling a user
      • Managing group memberships
  • Miscellaneous
    • Advanced tips & tricks
    • Typing special symbols on your keyboard
    • Shortcuts
    • Grammar style guide
    • Inserting MS Word files
    • Globo-panel
    • Creating high-quality documents
    • Excel calculations and lookups
  • Integrations
    • Overview
    • Spreadbases
    • E-signing documents
    • Drag & drop integrations
  • For developers
    • Clause9 API
    • Custom functions
    • Example custom functions
Powered by GitBook
On this page
  • Bulk creation in Assemble Document mode
  • Bulk creation in Q&A mode
  • Some ground rules
  • Predefined values
  • Datafield types
Export as PDF
  1. Assemble document

Bulk generation of documents

PreviousFocus ModeNextExporting documents

Last updated 1 year ago

Clause9 allows you to generate a large amount of documents based on a single intelligent template created in either Assemble Document or Q&A mode.

To do so, you can request Clause9 to generate an Excel sheet containing all the questions (or, if in Assemble Documents, the datafields) present in the document template. Each row in that Excel sheet represents a separate document being generated.

Be aware that, even though Excel certainly provides an easy way to quickly fill out large amounts of information, it is a fairly primitive way to complete forms — as anyone who had to fill in administrative forms in Excel would know. Generating documents in Clause9's Q&A within a browser should be preferred whenever possible, because there are dozens of facilities offered in this browser mode that Excel simply cannot match.

By way of example: it is notoriously difficult to enter multiple lines in an Excel cell. Make sure to read the guidance below to see how to effectively fill out this information so that Clause9 can interpret it.

Note that this is an advanced functionality that needs to be enabled for you to use it. Contact your administrator if you do not see the “bulk” button in the datafields menu.

Bulk creation in Assemble Document mode

To download this Excel sheet directly from Clause9, open the document you want to bulk generate and navigate to the datafields menu. From there, click “bulk” on the right-hand side of the screen and then click “Excel with datafields for bulk generation”.

This will trigger the download of an Excel sheet. Once you have filled the Excel sheet out with all the necessary information, click “Excel to generate document in bulk” to upload it to Clause9 and receive a ZIP file containing the separate documents in the format (PDF or DOCX) of your choice.

Bulk creation in Q&A mode

In Q&A mode, a Bulk export button will be visible in the rightmost button of the export dropdown button in the toolbar.

When you choose Bulk export, the following dialog box will be presented:

In this dialog box, you can download the Excel file. Once completed, you can then re-upload it, either by clicking on or dragging over the Choose file button. (The Choose file button may look different in each browser.)

Some ground rules

When you create the Excel sheet, you will see that Clause9 alphabetically orders the information that needs to be filled out based on (1) the alphabetical order of the concepts to which the individual datafields belong and (2) the order of the datafields in each concept.

You are free to play around with this structure — e.g. assign different fonts or colors —, provided you follow the ground rules below:

  • You can remove row 1 containing the concept (or card) to which the questions or datafields belong.

  • Row 2 (containing the question titles or datafield names) should however always be present, either as the first or as the second row. You are allowed to rephrase it — however, for currency-based datafields, the cell should somewhere mention the currency between parentheses (e.g., “(EUR)” or “(USD)”).

  • You will notice in the screenshot that row 3 is hidden. That row should not be removed or altered, as it contains the internal datafield number, that will be used by the software to match input with each datafield.

  • You can change the order of the columns in any way you like (the datafields of a concept should not necessarily stay together, as they are matched on the basis of the hidden datafield number in hidden row 3).

  • You can include a second Excel worksheet in the document explaining how the information should be filled out. However, the first worksheet should always contain the datafields themselves, so make sure any additional information is included in the second or subsequent worksheet.

  • You can remove certain columns (i.e.: datafields) if you do not want them to be filled out. This will cause that information to simply be omitted from the final documents, but does not prevent the documents from being generated.

  • You can add comments to a cell to assist users in filling out the Excel sheet. These will have no effect on the final output from Clause9.

  • You can add an optional filename in the very last column (coloured in black & white); if such filename is not included, a default one (using an incrementing number) will be added by the software . Do not add the filename extension (.PDF or .DOCX), because that extension will be automatically generated.

Predefined values

For text, number and currency fields/questions, the software will present the user the predefined values at the bottom of row 2 in the Excel file. (For example, in the screenshot above, predefined values Belgian, Dutch and French are mentioned in column A.)

If no predefines are defined at the level of the question (or if the export is done from Assemble Document), the predefined values of the datafield within the concepts will be taken.

Datafield types

Datafield type

How to fill out cells containing this datafield

Text

A simple text value should be included here.

Note that if this text datafield is used to enable or disable conditional text, you should inform your users of the selection of values that should be filled out here. The predefined values for this datafield are a good place to start.

True/false

The word “true”/”yes” or “false”/”no” (its capitalisation does not matter) should be filled out here. Note that this is language-sensitive so that you may also fill the equivalent in your own language out. (However, English is always accepted.) For example:

French: “vrai”/”oui” or “faux”/”non” Dutch: “juist”/”ja” or “fout”/”nee” German: “wahr”/”ja” or “falsch”/”nein” Lithuanian: “teisingai”/”taip” or “neteisingai”/”ne”

Number

A number should be filled here. For example: “3” (but not “three”).

Date

A date can be filled out here in any (Excel-legible) format you prefer. For example: “1 October 2021” or “2021-10-01”. Excel will automatically configure the appropriate date notation format based on your input.

Duration

Here you should fill out a number along with the duration value of your choice. For example: 3 months, 5 years, etc. Note that this is language-sensitive so that you may also fill the equivalent in your own language out.

As a reminder, Clause9 uses 5 duration values to choose from: years, quarters, months, weeks, and days.

Floating point number

A number with any amount of numbers after the comma can be filled out here. Excel will automatically configure the appropriate notation format based on your input.

Currency

A number should be filled out here. You can can configure the cell settings directly in Excel to choose the currency you would like to apply (e.g. USD, EUR, GBP, etc.)

List of texts

A simple text value should be included here. Note that you can fill out multiple text values (as is the nature of the list of texts datafield) by separating each answer with a line break (using Alt + Enter (Windows) or Cmd + Enter (Mac)).

Repeating list

Not supported (ignored).

Tip: you can “promote” the Bulk export button, so that it is shown more prominently in the Q&A toolbar. You can do so by “Promote Bulk Export” button to true. Example:

setting the Global Placeholder
Example of an Excel sheet for bulk generation