This guide explains how AutoFill works in Dashpivot CSV exports and the difference between Standard and AutoFill export formats. The AutoFill option helps structure exported data by removing empty rows while retaining important static form data such as form ID and created date.
This is especially useful for users performing data analysis or reporting outside Dashpivot. This feature applies to Dashpivot templates in the register view.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: Standard, Pro, Premium, or Platinum
Permission: Team Member (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
Open the Register view of your template in Dashpivot.
Select the forms you want to export.
Click Export CSV.
Choose your preferred export format:
Standard CSV export which exports your form followed by any tables it contains. If the template includes tables that generate their own rows of data, there may be blank rows between one form and the next.
Autofill CSV export which takes all static data or data that is not in tables and fills those rows in your CSV until it reaches the next exported form. This removes empty rows and ensures static information (such as Form ID and Created Date) is repeated where required.
Download the exported CSV file.