Custom Questions Report

If you have created custom questions upon checkout and need to retrieve the answers, you will want to use the Registration Detail report (under Custom Reports), then in the Fields to Display drop-down select Custom Questions Answers (Fig 1).

If needed, once you have the report in Excel you can use Excel to Split the cells into new columns.

Fig.1 - Selecting Custom Question Answers in Custom Reports

Once you have downloaded your report, you can follow these instructions on how to split the answers into individual columns:

https://support.microsoft.com/en-us/office/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23

Here are instructions about using the line break as the delimiter:

Select Other from the Delimiters options and deselect all the rest of the options. In the input box to the right of Other press Ctrl + J to insert a line break as your delimiter.
Before this, be sure you have inserted the same number of blank columns to the right of the "Custom Questions Answers" column to avoid overwriting the data to the right of that column.

Last modified Jun 17, 2024