Export result data
The export feature is an optional add-on and is not enabled by default. Enabling this feature may require a different type of license and could incur an additional charge. Please contact support@behaviorquant.com for details.
Step 1: Log in to the BQ Portal
If you are not already logged in, click here to sign in with your credentials.
Step 2: Export data
Click the export icon in the navigation bar to download your participants’ data in a .csv format.
Open the export file
To view the .csv file in a neatly formatted way, use a tool like Microsoft Excel.
In some cases, Excel may not format the data properly and display everything in a single column (column A), as shown in the screenshot below.
To fix this, select all the data in column A by clicking on column A.
Next, go to the Data menu in the Excel toolbar and select Text to Columns.
This will open a new dialog window.
In the dialog window, select Delimited and click Next.
On the next screen, deselect Tab and select Comma, then click Next.
On the next screen, click Finish.
You now have a clear view of your exported data.
Next, in the Ecxel menu bar, navigate to the Data menu. Select the “Text to Columns” option.
This will open a new dialog window.
In the dialog window, select “Delimited” and click next.
In the following screen, deselect the “Tab” and select the “Comma” checkbox. Click next.
In the following page, do not change any settings and click finish.
You should now have a clearly structured view of your exported data.
