Exporting result data
Step 1: Log into BQ
If you are currently not logged in, click here and log in with your credentials.
Step 2: Navigate to the export feature
Use the top navigation bar to navigate to the export page.
To export data:
Select your product of choice
Select a language for the labels used in the .csv file.
Then, click the Export Data button to generate and download the .csv file.
Opening the .csv file in Microsoft Excel
You can view the .csv file in a various software programs including Microsoft Excel.
Depending on your settings, Excel may not immediately show a clearly structured view of the exported data, for example:
Instead of displaying the data in separate columns, all data are crammed into column A.
To resolve this, first select all rows of column A by clicking on column A.
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.