How to Export Digital Form Responses with Questions and Answers

Learn how to export digital form questions and answers to Excel in SimplySub using the Forms Answers report and single-template filtering.

Updated 2026-11-22

Overview

SimplySub allows you to report on submitted digital forms, including the individual questions and answers recorded during inspections, safety checks, equipment evaluations, and other form submissions.

Using the Forms Answers report, you can select a specific form template, view its questions and responses in a data grid, filter results based on how questions were answered, and export the information into an Excel spreadsheet.

Important: To display individual form questions and their answers as report columns, you must select exactly one form template. Selecting multiple templates, or leaving the template selection empty, changes how the report displays results.

Step 1: Open the Forms Answers Report

  1. Log in to your SimplySub workspace.
  2. Navigate to the Reports section.
  3. Use the report search field to search for Forms.
  4. Open the Forms Answers report.

This report allows you to review digital form submissions and, when using a single template, analyze individual question responses.

Step 2: Select a Single Form Template

The Form Template filter determines whether the report displays individual questions and answers.

  1. Locate the Form Template filter.
  2. Select the specific digital form template you want to analyze.
  3. Make sure only one template is selected.
  4. Click Run Report.

For example, you might select a Heavy Equipment Pre-Inspection form template to review inspection submissions and their recorded answers.

When exactly one template is selected, SimplySub can display the questions from that template as individual columns in the report.

Step 3: Review Questions and Answers in the Report

After running the report with a single form template selected, the results include the individual questions defined in that template.

Each question appears as a column, allowing you to review the answers recorded for each form submission.

For example, an equipment inspection report might contain questions about pre-use inspections, equipment condition, or whether a particular inspection item passed or failed.

This makes it possible to compare responses across multiple submissions of the same form template without opening each form individually.

Step 4: Remove or Adjust Report Conditions

The report supports conditions that allow you to control which records appear in the results.

If you want to review all available submissions for your selected template without applying an additional condition:

  1. Review the conditions displayed in the report.
  2. Remove any conditions you do not want to apply.
  3. Click Run Report again to refresh the results.

Removing unnecessary conditions allows you to review a broader set of form submissions.

Step 5: Filter Form Submissions by Question Answers

One of the most useful features of the single-template report is the ability to filter submissions based on how individual questions were answered.

For example, you might want to identify all equipment inspections where a particular question was answered Fail.

  1. Select exactly one form template in the Form Template filter.
  2. Click Run Report to display the template's individual question columns.
  3. Add or configure a report condition using the specific question you want to evaluate.
  4. Set the condition to match the response you want to find, such as Pass or Fail.
  5. Run the report again to display matching submissions.

This allows you to identify submissions based on their recorded answers rather than reviewing every form manually.

Example: Finding Failed Equipment Inspections

Suppose your team completes a Heavy Equipment Pre-Inspection form every day.

You want to identify submissions where a particular inspection question was answered Fail.

Select the Heavy Equipment Pre-Inspection template, run the report, and apply a condition to the relevant question using the desired answer.

The report can then display submissions matching that condition, helping you focus on the inspection results that require review.

Step 6: Export Form Questions and Answers to Excel

Once the report displays the information you need, you can export the results into an Excel spreadsheet.

  1. Confirm that exactly one form template is selected.
  2. Run the report with your desired conditions.
  3. Review the displayed questions and answers.
  4. Click Export.
  5. Open the downloaded Excel spreadsheet.

The exported spreadsheet includes the individual question columns and their corresponding answers from the selected form template.

You can use this spreadsheet to review inspection results, compare responses, or perform additional analysis outside SimplySub.

Why Selecting Exactly One Form Template Matters

The Forms Answers report can display results differently depending on how many templates are selected.

One Form Template Selected

  • Displays questions from the selected template as individual report columns.
  • Shows the corresponding answers for submitted forms.
  • Allows you to filter results based on individual question responses.
  • Supports exporting those questions and answers to Excel.

No Form Template Selected

  • Returns form submissions across available templates.
  • Does not display every template's individual questions and answers as separate columns.
  • Provides a more general view of form submissions.

Multiple Form Templates Selected

  • Returns submissions associated with the selected templates.
  • Does not provide the same question-level column layout available with a single template.
  • Requires you to open individual forms to review their specific questions and answers.

Why? Different form templates can contain completely different questions. Because the report cannot combine the unique question structures of multiple templates into the same question-level data grid, this detailed view is only available when exactly one template is selected.

Helpful Tips

  • Choose one template: Always select exactly one form template when you need question-by-question reporting.
  • Remove unwanted conditions: If you want a broader view of submissions, remove unnecessary report conditions and run the report again.
  • Filter by specific answers: Use question-level conditions to identify responses such as Pass or Fail.
  • Export for additional analysis: Download the report to Excel when you need to review the question and answer data outside SimplySub.
  • Use descriptive form templates: Clearly named templates can make it easier to locate the correct form when running reports.

Frequently Asked Questions

How do I export individual digital form answers to Excel?

Open the Forms Answers report, select exactly one form template, click Run Report, and then select Export. The downloaded Excel spreadsheet includes the questions and recorded answers for that template.

Why aren't my form questions appearing as columns?

The most likely reason is that you have not selected exactly one form template. If no templates or multiple templates are selected, the report uses a general submission view without the individual question columns.

Can I export questions and answers from multiple form templates together?

Not in the same question-level data grid. Different templates contain different questions, so the detailed question and answer layout requires exactly one template to be selected.

Can I filter the report to show only failed inspections?

Yes. Select a single inspection form template, then configure a report condition using the relevant question and a response such as Fail. Run the report to display matching submissions.

What happens if I leave the Form Template filter empty?

The report returns a broader set of form submissions but does not display the individual questions and answers as separate columns. To see question-level details, select a single template and run the report again.

Can I remove report conditions?

Yes. You can remove conditions that you do not need and run the report again to review a broader set of submissions.

Need Help?

If you need assistance reporting on digital forms, filtering specific question answers, or exporting data to Excel, contact the SimplySub support team for guidance.