How do I export data from Gruntify into Excel?
Exporting data is a two-step process, covered tutorials in the Administration section of this Help Center.
- Define the fields you want to export as a CSV report. See the Report Templates tutorial.
- Export the report. See the Export Reports tutorial.
Why do I get multiple CSV's when I export my data?
Gruntify allows you to add or remove fields from a form. But then the data collected in the past may not fit the new form properly. Where would you see the values used in the past for the fields that were removed? Leaving the new fields blank isn't right either. For example, if the new field was a Mandatory Yes/No answer to "Is there sprinklers fitted?" you can't just assume either a yes or no answer for older data that doesn't have an answer.
To avoid this problem, Gruntify makes a new version of your form and automatically matches the data to the form used when the data was collected.
When you export the data to a CSV, we create one file for each form version applicable to the data. This avoids showing empty columns (for the added fields) or missing values (for the removed fields).