User Guide Cancel

Create the CSV form used to Send in Bulk

Search
Adobe Sign

Adobe Sign

Open app

 

Adobe Acrobat Sign Guide

What's New

  1. Pre-Release Notes
  2. Release Notes
  3. Important Notifications

Get Started

  1. Quick start guide for administrators
  2. Quick start guide for users
  3. For Developers
  4. Video tutorial library
  5. FAQ

Administer

  1. Admin Console Overview
  2. User Management
    1. Add a User
    2. Add Users in Bulk
    3. Add Users from your Directory
    4. Add Users from MS Azure Active Directory
    5. Create function-focused users
      1. Technical accounts - API driven
      2. Service accounts - Manually driven
    6. Check for users with provisioning errors
    7. Change Name/Email Address
    8. Edit a user's group membership
    9. Edit a user's group membership through the group interface
    10. Promote a user to an admin role
    11. User Identity Types and SSO
    12. Switch User Identity
    13. Authenticate Users with MS Azure
    14. Authenticate Users with Google Federation
    15. Product Profiles
    16. Login Experience 
  3. Account/Group Settings
    1. Settings Overview
    2. Global Settings
      1. Account tier and ID
      2. Self Signing Workflows
      3. Send in Bulk
      4. Web Forms
      5. Custom Send Workflows
      6. Power Automate Workflows
      7. Library Documents
      8. Collect form data with agreements
      9. Limited Document Visibility
      10. Attach a PDF copy of the signed agreement 
      11. Include a link in the email
      12. Include an image in the email
      13. Files attached to email will be named as
      14. Attach audit reports to documents
      15. Merge multiple documents into one
      16. Download individual documents
      17. Upload a signed document
      18. Delegation for users in my account
      19. Allow external recipients to delegate
      20. Authority to sign
      21. Authority to send
      22. Power to add Electronic Seals
      23. Set a default time zone
      24. Set a default date format
      25. Users in Multiple Groups (UMG)
        1. Upgrade to use UMG
      26. Group Administrator Permissions
      27. Replace recipient
      28. Audit Report
        1. Overview
        2. Allow unauthenticated access on the transaction verification page
        3. Include reminders
        4. Include view events
        5. Include agreement page/attachment count
      29. In Product Messaging and Guidance
      30. Accessible PDFs
      31. New authoring experience
      32. Healthcare customer
    3. Account Setup
      1. Add logo
      2. Customize company Hostname/URL    
      3. Add company name
      4. Post agreement URL redirect
    4. Signature Preferences
      1. Well formatted signatures
      2. Allow recipients to sign by
      3. Signers can change their name
      4. Allow recipients to use their saved signature
      5. Custom Terms of Use and Consumer Disclosure
      6. Navigate recipients through form fields
      7. Decline to sign
      8. Allow Stamps workflows
      9. Require signers to provide their Title or Company
      10. Allow signers to print and place a written signature
      11. Show messages when e-signing
      12. Require signers to use a mobile device to create their signature
      13. Request IP address from signers
      14. Exclude company name and title from participation stamps
    5. Digital Signatures
      1. Overview
      2. Download and sign with Acrobat
      3. Sign with Cloud Signatures
      4. Include metadata for Identity Providers
      5. Restricted Cloud Signatures Providers
    6. Electronic Seals
    7. Digital Identity
      1. Digital Identity Gateway
      2. Identity Check policy
    8. Report Settings
      1. New report experience
      2. Classic report settings
    9. Security Settings
      1. Single Sign-on settings
      2. Remember-me settings
      3. Login password policy
      4. Login password strength
      5. Web session duration
      6. PDF encryption type
      7. API
      8. User and group info access
      9. Allowed IP Ranges
      10. Account Sharing
      11. Account sharing permissions
      12. Agreement sharing controls
      13. Signer identity verification
      14. Agreement signing password
      15. Document password strength
      16. Block signers by Geolocation
      17. Phone Authentication
      18. Knowledge-Based Authentication (KBA)
      19. Allow page extraction
      20. Document link expiration
      21. Upload a client certificate for webhooks/callbacks
      22. Timestamp
    10. Send settings
      1. Show Send page after login
      2. Require recipient name when sending
      3. Lock name values for known users
      4. Allowed recipient roles
      5. Recipient groups
      6. Required fields
      7. Attaching documents
      8. Field flattening
      9. Modify Agreements
      10. Agreement name
      11. Languages
      12. Private messages
      13. Allowed signature types
      14. Reminders
      15. Signed document password protection
      16. Send Agreement Notification through
      17. Signer identification options
        1. Overview
        2. Signing password
        3. One-Time Password via Email
        4. Acrobat Sign authentication
        5. Phone authentication
        6. Cloud-based digital signature
        7. Knowledge-based authentication
        8. Government ID
        9. Signer Identity reports
      18. Content Protection
      19. Enable Notarize transactions
      20. Document Expiration
      21. Preview, position signatures, and add fields
      22. Signing order
      23. Liquid mode
      24. Custom workflow controls
      25. Upload options for the e-sign page
      26. Post-sign confirmation URL redirect
    11. Message Templates
    12. Bio-Pharma Settings
      1. Overview
      2. Enforce identity authentication
      3. Signing reasons
    13. Workflow Integration
    14. Notarization Settings
    15. Payments Integration
    16. Signer Messaging
    17. SAML Settings
      1. SAML Configuration
      2. Install Microsoft Active Directory Federation Service
      3. Install Okta
      4. Install OneLogin
      5. Install Oracle Identity Federation
    18. Data Governance
    19. Time Stamp Settings
    20. External Archive
    21. Account Languages
    22. Email Settings
      1. Email header/footer images
      2. Permit individual user email footers
      3. Customize the Signature Requested email
      4. Customize the To and CC fields
      5. Enable Linkless Notifications
      6. Customize email templates
    23. Migrating from echosign.com to adobesign.com
    24. Configure Options for Recipients
  4. Guidance for regulatory requirements
    1. Accessibility
      1. Accessibility Compliance
      2. Create accessible forms with Acrobat desktop
      3. Create accessible AcroForms
    2. HIPAA
    3. GDPR
      1. GDPR Overview
      2. Redact a user
      3. Redact a user's agreements    
    4. 21 CFR part 11 and EudraLex Annex 11
      1. 21 CRF part 11 validation pack
      2. 21 CFR and EudraLex Annex 11 handbook
      3. Analysis of shared responsibilities
    5. Healthcare customers
    6. IVES support
    7. "Vaulting" agreements
    8. EU/UK considerations
      1. EU/UK Cross-border transactions and eIDAS
      2. HMLR requirements for deeds signed electronically
      3. The impact of Brexit on e-signature laws in the UK
  5. Download Agreements in Bulk
  6. Claim your domain 
  7. Report Abuse links

Send, Sign, and Manage Agreements

  1. Recipient Options
    1. Cancel an email reminder
    2. Options on the e-signing page
      1. Overview of the e-sign page
      2. Open to read the agreement without fields
      3. Decline to sign an agreement
      4. Delegate signing authority
      5. Restart the agreement
      6. Download a PDF of the agreement
      7. View the agreement history
      8. View the agreement messages
      9. Convert from an electronic to a written signature
      10. Convert from a written to an electronic signature 
      11. Navigate the form fields
      12. Clear the data from the form fields
      13. E-sign page magnification and navigation
      14. Change the language used in the agreement tools and information
      15. Review the Legal Notices
      16. Adjust Acrobat Sign Cookie Preferences
  2. Send Agreements  
    1. Send page overview
    2. Send an agreement only to yourself
    3. Send an agreement to others
    4. Written Signatures
    5. Recipient signing order
    6. Send in Bulk
      1. Overview of the Send in Bulk feature
      2. Send in Bulk - manual recipients
      3. Send in Bulk - CSV upload
      4. Cancel a Send in Bulk transaction
      5. Add reminders to Send in Bulk
      6. Reporting for Send in Bulk
  3. Authoring fields into documents
    1. In-app authoring environment
      1. Automatic field detection
      2. Drag and drop fields using the authoring environment
      3. Assign form fields to recipients
      4. The Prefill role
      5. Apply fields with a reusable field template
      6. Transfer fields to a new library template
      7. Updated authoring environment when sending agreements
    2. Create forms with text tags
    3. Create forms using Acrobat (AcroForms)
      1. AcroForm creation
      2. Creating accessible PDFs
    4. Fields
      1. Field types
        1. Common field types
        2. In-line Images
        3. Stamp Images
      2. Field content appearance
      3. Field validations
      4. Masked fields values
      5. Setting show/hide conditions
      6. Calculated fields 
    5. Authoring FAQ
  4. Sign Agreements
    1. Sign agreements sent to you
    2. Fill & Sign
    3. Self-signing
  5. Manage Agreements
    1. Manage page overview
    2. Delegate agreements
    3. Replace Recipients
    4. Limit Document Visibility 
    5. Cancel an Agreement 
    6. Create new reminders
    7. Review reminders
    8. Cancel a reminder
    9. Access Power Automate flows
    10. More Actions...
      1. How search works
      2. View an agreement
      3. Create a template from an agreement
      4. Hide/Unhide agreements from view
      5. Upload a signed agreement
      6. Modify a sent agreement's files and fields
      7. Edit a recipient's authentication method
      8. Add or modify an expiration date
      9. Add a Note to the agreement
      10. Share an individual agreement
      11. Unshare an agreement
      12. Download an individual agreement
      13. Download the individual files of an agreement
      14. Download the Audit Report of an agreement
      15. Download the field content of an agreement
  6. Audit Report
  7. Reporting and Data exports
    1. Overview
    2. Grant users access to reporting
    3. Report charts
      1. Create a new report
      2. Agreement Reports
      3. Transaction Reports
      4. Settings Activity Report
      5. Edit a report
    4. Data Exports 
      1. Create a new data export
      2. Edit a data export
      3. Refresh the data export content
      4. Download the data export
    5. Rename a report/export
    6. Duplicate a report/export
    7. Schedule a report/export
    8. Delete a report/export
    9. Check Transaction Usage

Advanced Agreement Capabilities and Workflows

  1. Webforms 
    1. Create a web form
    2. Edit a web form
    3. Disable/Enable a web form
    4. Hide/Unhide a web form
    5. Find the URL or script code 
    6. Prefill web form fields with URL parameters
    7. Save a web form to complete later
    8. Resize a web form
  2. Reusable Templates (Library templates) 
    1. US Government forms in the Acrobat Sign library
    2. Create a library template
    3. Change a library template's name
    4. Change a library template's type
    5. Change a library template's permission level
    6. Copy, edit, and save a shared template
    7. Download the aggregate field data for a library template
  3. Transfer ownership of web forms and library templates
  4. Power Automate Workflows 
    1. Overview of the Power Automate integration and included entitlements
    2. Enable the Power Automate integration
    3. In-Context Actions on the Manage page
    4. Track Power Automate usage
    5. Create a new flow (Examples)
    6. Triggers used for flows
    7. Importing flows from outside Acrobat Sign
    8. Manage flows
    9. Edit flows
    10. Share flows
    11. Disable or Enable flows
    12. Delete flows
    13. Useful Templates
      1. Administrator only
        1. Save all completed documents to SharePoint
        2. Save all completed documents to OneDrive for Business
        3. Save all completed documents to Google Drive
        4. Save all completed documents to DropBox
        5. Save all completed documents to Box
      2. Agreement archival
        1. Save your completed documents to SharePoint
        2. Save your completed documents to One Drive for Business
        3. Save your completed documents to Google Drive
        4. Save your completed documents to DropBox
        5. Save your completed documents to Box
      3. Webform agreement archival
        1. Save completed web form documents to SharePoint Library
        2. Save completed web form documents to OneDrive for Business
        3. Save completed   documents to Google Drive
        4. Save completed web form documents to Box
      4. Agreement data extraction
        1. Extract form field data from your signed document and update Excel sheet
      5. Agreement notifications
        1. Send custom email notifications with your agreement contents and signed agreement
        2. Get your Adobe Acrobat Sign notifications in a Teams Channel
        3. Get your Adobe Acrobat Sign notifications in Slack
        4. Get your Adobe Acrobat Sign notifications in Webex
      6. Agreement generation
        1. Generate document from Power App form and Word template, send for signature
        2. Generate agreement from Word template in OneDrive, and get signature
        3. Generate agreement for selected Excel row, send for review and signature
  5. Custom Send workflows
    1. Custom Send Workflow Overview
    2. Creating a new Send Workflow
    3. Edit a Send Workflow
    4. Activate or Deactivate a Send Workflow
    5. Send an agreement with a Send Workflow
  6. Share users and agreements
    1. Share a user
    2. Share agreements

Integrate with other products

  1.  Acrobat Sign integrations overview 
  2. Acrobat Sign for Salesforce
  3. Acrobat Sign for Microsoft
    1. Acrobat Sign for Microsoft 365
    2. Acrobat Sign for Outlook
    3. Acrobat Sign for Word/PowerPoint
    4. Acrobat Sign for Teams
    5. Acrobat Sign for Microsoft PowerApps and Power Automate
    6. Acrobat Sign Connector for Microsoft Search
    7. Acrobat Sign for Microsoft Dynamics 
    8. Acrobat Sign for Microsoft SharePoint 
  4. Other Integrations
    1. Acrobat Sign for ServiceNow
    2. Acrobat Sign for HR ServiceNow
    3. Acrobat Sign for SAP SuccessFactors
    4. Acrobat Sign for Workday
    5. Acrobat Sign for NetSuite
    6. Acrobat Sign for VeevaVault
    7. Acrobat Sign for Coupa BSM Suite
  5. Partner managed integrations
  6. How to obtain an integration key

Acrobat Sign Developer

  1. REST APIs 
    1. Methods documentation
    2. SDK/Developer Guide
    3. API FAQ    
  2. Webhooks 
    1. Webhook overview
    2. Configure a new webhook
    3. View or edit a webhook
    4. Deactivate or reactivate a webhook
    5. Delete a webhook
    6. Two-way SSL certificates
    7. Webhooks in the API

Support and Troubleshooting

  1. Customer Support Resources 
  2. Enterprise Customer Success Resources 
Alert:

Using the Send in Bulk CSV upload option does not support in-app authoring of fields. All fields must be placed on the document template before uploading to the Send in Bulk interface.

Create the CSV file

A CSV file is best created using a spreadsheet application like Excel, Numbers, Google Sheets, etc. Most spreadsheets can export into a CSV format, which is required for the upload to succeed.

Spreadsheets present the data in an easily readable table format, where the rows (i.e., records) and columns (i.e., fields)  are easily discernable. When creating your CSV, each row represents one child agreement, and each column is one argument applied to the agreement (like the recipient email and personalized form fields).

Two things to consider before you start to build your CSV:

  • The Send in Bulk template allows the configuration of many agreement options, and if the CSV does not explicitly define a setting, the default value from the parent template is used. So if all agreements have the same Agreement name, don't include that column in your CSV file.
  • A value does not need to be placed in every field because a column exists. Empty fields are ignored, and the default from the parent Send in Bulk template is used. So there is no need to fill in every field in every record.

The CSV itself can be divided into three meaningful sections:

Note:

The new Send in Bulk environment does not currently support configuring the sender to sign first through the user interface.

Customers using a legacy CSV file in the new experience will not be able to insert the Sender as the first signer. A new CSV using the new formatting must be created with the sender defined as the first recipient for each child agreement.

At least one and up to 100 recipients can be included in each child agreement. 

Each recipient can be defined by five fields:

  • Recipient_X:Email
  • Recipient_X:Role
  • Recipient_X:Auth_Type
  • Recipient_X:Auth_Value
  • Recipient_X:Private_Message

Where _X is the recipient index number (Recipient_1, Recipient_2, etc) and the argument after the : is the value used by the system to construct the agreement.

Only the email address is required. All other values can be ignored or inherited from the parent template by omitting the column or leaving the field empty.

Example of a CSV file showing the six recipient columns

Note:

Defining recipient values like the recipient name, title, and company can be achieved using uniquely named column headers that map to the like-named fields in the document. See Defining custom fields for merging field data into the agreements below.

Column headers are case-sensitive and must match the field names exactly.

Field values:

:Email - This field accepts any string in an email format (x@y.zz). Values in the :Email field that don't comply with the email format trigger an error.

:Role - Accepts the standard Roles for agreements:

  • SIGNER
  • APPROVER
  • ACCEPTOR
  • FORM_FILLER
  • CERTIFIED_RECIPIENT

:Auth_Type - Accepts one of the below authentication methods. If an authentication method is defined that isn't enabled for the sending group, and error will be generated.

:Auth_Value - Only applicable to PHONE and PASSWORD authentications. No other Auth_Type should include an Auth_Value. Accepts a string that defines the value used to validate the authentication method (when applicable).:

  • PASSWORD authentication - A string that defines a value the recipient must enter to pass the authentication challenge.
  • PHONE authentication - A string of numbers that defines the recipient's phone number. The phone number will be used to communicate the code to the recipient.
    • The phone number must be formatted to have a hyphen between the country code and the phone number (e.g., 1-5555551212 and 91-9934765344)
    • The phone number format may include a plus at the beginning and hyphens within the number to produce a more human-readable string as desired. (e.g., +1-555-555-1212)

:Private_Message - A string of up to 1000 characters delivered to the recipient as a private message in their email body and on the e-signing page.

CC_X:Email - The email of an agreement participant who is CC'd to the agreement and only views the agreement once completed. Like the Recipient, the X value is a number that starts with 1 and increments up if you have multiple CC'd parties. e.g., IF you have three CC'd parties you would need to configure three columns: CC_1:EMAIL, CC_2:EMAIL, CC_3:EMAIL

These columns relate to the Agreement details and Agreement settings sections of the Send in Bulk configuration UI. When configuring the Send in Bulk transaction in the Acrobat Sign interface, you are setting the default values to be used if there isn't a value explicitly defined in these columns. There are five distinct fields:

  • Locale - This defines the language (localization) applied to the recipient's experience. The email and e-signing page elements that are part of the Acrobat Sign template are localized only. Custom content added by the sender is not translated. The available values are:
  • Basque (Spain) - eu_ES 
  • Bokmål (Norwegian) - nb_NO 
  • Catalan (Spain) - ca_ES
  • Chinese - zh_CN 
  • Chinese (Taiwan) - zh_TW 
  • Croatian - hr_HR
  • Czech - cs_CZ
  • Danish - da_DK 
  • Dutch - nl_NL 
  • Finnish - fi_FI 
  • French - fr_FR
  • German - de_DE
  • Hebrew - iw_IL 
  • Hungarian - hu_HU
  • Icelandic - is_IS 
  • Indonesia - in_ID 
  • Italian - it_IT 
  • Japanese - ja_JP 
  • Korean - ko_KR 
  • Malay - ms_MY
  • Norwegian - no_NO 
  • Nynorsk (Norwegian) - nn_NO 
  • Polish - pl_PL 
  • Portuguese - pt_PT 
  • Portuguese (Brazil) - pt_BR 
  • Romanian - ro_RO
  • Russian - ru_RU 
  • Slovak - sk_SK 
  • Slovenian - sl_SI 
  • Spanish - es_ES
  • Swedish - sv_SE 
  • Thai - th_TH
  • Turkish - tr_TR 
  • Ukrainian - uk_UA
  • UK English - en_GB
  • US English - en_US 
  • Vietnamese - vi_VN
  • Agreement_Name  - The Agreement name value that is inserted into the recipient email and provided on the Manage page.
  • Expires - This field defines the number of days before the agreement will be automatically canceled.
  • Agreement_Message - Defines the global message inserted into the recipient's email body.
  • Order - This field describes the recipient flow:
    • A string of recipients with only commas delimiting each recipient is identified as a sequential signature flow.
    • All recipients within parentheses (Recipient_1,Recipient_2), are identified as being in a parallel signature flow. All members are notified at the same time, and all must sign.
    • You can freely mix these methods in any  order to create a hybrid signature flow:
      e.g., Recipient_1,Recipient_2,(Recipient_3,Recipient_4,Recipient_5),Recipient_6,(Recipient_7,Recipient_8),Recipient_9
The CSV file with the agreement related columns visible

Adding custom field mapping to the Send in Bulk transaction begins with understanding the field name in the template you upload. The CSV file must use the document template's field name as the column header name.

For example, if you have a field in the document template named Investment, the column header in the CSV must be Investment.

If you intend to fill a field named StreetAddress , the column header in the CSV must be StreetAddress. 

Column headers are case-sensitive and must match the field names exactly.

An example CSV file with two custom field columns added

Caution:

There are six reserved words that cannot be used as custom field names:

  • Name
  • Title
  • Company
  • Email
  • Date
  • Role
Caution:

The CSV file may not have a comma or blank space at the end of any row or at the end of the CSV file.

Having a comma or blank space at the end of a row or at the end of the file will trigger an error message: "Error reading the CSV file provided."

Example of a CSV file highlighting trailing commas and a blank line at the end of the file.

 Adobe

Get help faster and easier

New user?

Quick links

View all your plans Manage your plans
View quick links
Hide quick links
Adobe MAX 2024

Adobe MAX
The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now

Adobe MAX

The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now
Adobe MAX 2024

Adobe MAX
The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now

Adobe MAX

The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now

Legal Notices    |    Online Privacy Policy