How to Customise Data Tables

There are two ways to generate Data Tables directly witihin Surveygoo: (1) Standard Data Tables (2) Custom Data Tables.
Both table formats are read in Microsoft Excel. It is also possible to export your data as a CSV file or SPSS file.
Standard Data Tables
Standard Data Tables uses a standard format which includes any pre-set demographic questions in the Key Breaks (sometimes known as Banners or Data Columns), such as age, gender and region. More on Standard Data Tables>
Custom Data Tables
Custom Data Tables allow the option of additional Key Breaks to be included in the Standard Breaks. Additional Key Breaks are selected from the main questionnaire and will appear as columns in the same way as age, gender and region breaks.
Additional Key Breaks can be set from the following question types:
  • Choice (Single Choice)
  • Choice (Multiple Choice)
  • Drop Down
  • Emoticon
Step 1: Access Reports Page
1) Click on the My Surveys tab, at the top of the Dashboard page
Stacks Image 16642
Stacks Image 16677
2) Look for the relevant survey in the My Surveys page, and then click on the View Report icon
Step 2: Configure Custom Data Tables
At the top of the Survey Reports page are the reporting options available for your subscription.
survey reports surveygoo
Stacks Image 16700
1) Click on the Custom Data Tables (Excel)  link, and the Custom Data Tables page will be displayed
Stacks Image 5712
 Each additional Key Break needs to be inserted into the Custom Data Tables.
Stacks Image 16729
2) Click on the Add New Custom Data Table link
The New Custom Data Table pop up box is now displayed.
Stacks Image 16758
3) To set Key Breaks, click on the relevant page number, and the questions from the page will be displayed
Stacks Image 16787
4) Next, click on the question you want to be added to the Custom Data Tables
The answer code options for the question will now be displayed.
Stacks Image 16818
5) Tick all the answer codes to be added to the Custom Data Tables. Its possible to select one, several or all the answer codes
Stacks Image 16847
6) Click on the Done button when you are ready
Step 3: Review and Add Other Key Breaks
Having configured the required Key Breaks to be included in the Custom Data Tables, you can either export the tables or add other Key Breaks.

All current Key Breaks which have been configured will be displayed in the Custom Data Table page.
Stacks Image 16876
You can review and edit individual breaks by clicking on the pencil icon, or delete the Key Break by clicking on the red cross icon.
Stacks Image 16899
Step 4: Download Tables
Stacks Image 16928
When you have configured the required Key Breaks, download the Custom Data Tables. The Custom Data Table link is located in the top right hand corner of the Custom Data Table page.
Click on the link and wait for the tables to download. Make sure you keep your browser open while the file downloads.

Mac Users
The filename will be a number (e.g. 446) corresponding to the number reference of the survey. To read the tables, manually type a .xls extension at the end of the filename, then double click on the file to open it, or open the file directly from Excel. Note .xlsx extensions do not work if you have Excel 2011 for Mac.

PC Users
For PC users, the filename automatically includes the .xls extension used to read Excel files. Double click on the file or open it in Excel. 
Tables can now be reviewed. The new Key Breaks will appear in columns on the right after the Default Standard Breaks (e.g. age, gender and region). Each answer code for the question will be displayed separately. So for example, Q3 has a column entry for the "More than once a week" answer code as well as "Once a week", etc.
Stacks Image 5867

Surveygoo Books Available on Amazon and iBooks Store

Stacks Image 31384
Visit Amazon to buy | More info on Book
Stacks Image 31389
Visit iBooks Store to download Free

Start Using Our Survey Tool Now!

See Price Plans