Skip to main content

How to Bulk Create Forms on Dashpivot

Learn how to bulk create forms to quickly generate multiple records in Dashpivot

Written by Adriana De Souza

Use Bulk Create to generate up to 500 forms at once by uploading a CSV file. This saves time when you need to create a large number of similar records — for example, onboarding a fleet of assets or setting up a register of works. Bulk Create is available on Dashpivot Web only.

Prerequisites

Before you begin make sure you have the following:

  • Plan: Pro, Premium, Platinum, and Free Trial

  • Permission: Team Folder – Team Member (or higher)

  • Device Type: Computer

  • Subscription: Dashpivot

Step-by-Step Instructions

  1. Go into a Team folder and click Templates

  2. Select a template in your Team folder.

  3. Click Bulk Create.

  4. Click Download CSV template to see which fields can be filled in via CSV.

  5. Prepare your CSV file with the correct formatting. Each row in your CSV will create one form.

    Excel view of populated CSV:

  6. Upload your CSV.

  7. Click Create forms.

📁 File requirements

When preparing your CSV file to upload, ensure it meets these requirements:

  • File size: Maximum 5MB

  • Maximum rows: 500 rows per CSV upload (each row creates one form)

  • File format: Must be a CSV file (.csv only)

  • Header row: Must include a header row with column names that match field names in your form exactly

  • Unique column names: All column headers must be unique - no duplicates allowed

🗄️ Supported field types

Currently, forms with these field types can be bulk created:

  • Single Line Text

  • Single Date (Plain)

  • Single Date (Timezone Aware)

  • Expiry Date (Timezone Aware)

Note: Only forms with the supported field types listed above can be bulk created. Any fields inside logic fields are not supported

💻 Formatting requirements

Single Line Text:

  • Alphanumerical characters only

  • Maximum 1,000 characters per field

  • Example: "Transformer Unit 001"

📆 Date fields (Single Date, Expiry Date)

  • Format: DD/MM/YYYY

  • Example: 29/02/2024

  • Note: In Excel, go to Format Cells > Number and select correct formatting


💡 Pro Tips

  • Test with a small batch first: Try uploading 5-10 forms initially to ensure your CSV formatting is correct

  • Row limit: You can upload up to 500 rows per CSV. If you need to create more than 500 forms, split your data across multiple uploads.

  • Removing data: To remove data from a CSV row, Delete the entire row. Using Clear contents will NOT remove the row from upload

  • Tables not supported: Default tables and Prefilled tables cannot be populated via CSV upload. Single Text and Single Date fields within tables will not be filled in during bulk creation

  • Required fields: If you have a Timeline template that has required fields not supported by bulk create, you'll need to update those fields to unrequired

  • Empty cells: Empty cells will result in blank fields in the created forms

  • Existing forms: Existing forms will not be affected. Only new forms are created

FAQs

What happens if my CSV has more than 500 rows?
The upload will be rejected. Split your data into multiple files of 500 rows or fewer and upload them separately.

Can I bulk create forms on Dashpivot Mobile?
No — Bulk Create is only available on Dashpivot Web.

Why are some fields not filled in after a bulk create?
Only Single Line Text, Single Date, and Expiry Date fields are supported. Other field types — including tables, logic fields, and photos — are not populated during bulk create.

Can I use Bulk Create on a Home folder?
No — Bulk Create is only available in Team folders.

Did this answer your question?