Help‎ > ‎

Exporting



All exports apart from html format exports can be saved to your computer or Google Drive™ or shown in a text box on-screen. For html format exports just choose the save or print options on your browser.

You can also import your data back into Set YOUR own TESTS for sharing, organisation and other reasons which you can read about on the importing page.

You don't need an account to export data. For example you could ask a third party to create questions using Set YOUR own TESTS and send them to you in a library. The third party does not need an account to create some questions, export them and send them to you.

To export libraries and tests

For libraries and tests you can export:
  • Raw data in xml format which can be loaded back into Set YOUR own TESTS
  • Question and answer sheet in text file format (no photos).
  • Print your Test or Library in Question and answer sheet format with photos.
  • Create a Google Form in your own Google Drive

Go to the libraries tab list or the test tab list and if you have any libraries or tests then you will see them listed and there is a button against each which says Export and Print. Click the one you want to export.

screenshot export data button

A dialog box will open showing the export options. Choose the option you require. If it is a download option then a text file will be downloaded and your browser will probably save it in your downloads folder. For Google Drive™ options then please see the dedicated section below.


showing the export dialog

To export data that you will want to import back again (for example if you already have your maximum Tests or Libraries loaded) then choose either Download as data (xml) or Save to Google Drive™ as data (xml) or Show data (xml) in a text box.

For the Create a Google Form™ option a Google Apps Script will do the work and you will need to authenticate and grant permission for the script. More information for the script is at the Setyourowntests to Forms bridge documentation

To export publications

For publications you can export:
  • Report on respondents and scores
  • CSV file containing the questions and responses
  • Individual respondent report in html format showing answers in detail

To export publications you need to first open the publication from the publication tab list. Just click on the publication name.

screenshot my publications list


When the publication opens then choose the Export button from the buttons...

screenshot of buttons on publication page


showing the drop down filter list

There are two possible formats from using the Export button: reports and CSV file.
Reports will show the respondents in your filtered list (on the publication panel). Use the drop down box to change the contents of the filtered list.


CSV exports will show all respondents - you can filter them in your spreadsheet. CSV means "Comma Separated Values"; files in CSV format are text files which can be opened by speadsheet programs. You can then format and filter in your spreadsheet program and then save as a spreadsheet. If you export to Google Drive™ then you can choose to open the .csv file with Google Sheets.
When you click the Export button a dialog will open to let you choose the required export option... Choose the option you require. If it is a download option then a text file will be downloaded and your browser will probably save it in your downloads folder. For Google Drive™ options then please see the dedicated section below.


showing export dialog


Another export is the individual respondent report. To access this the respondent must have completed the questions. This is not available for Fun Quizzes because the respondents are not listed for that type of publication.

Just choose the "Show results" option on the respondent menu on the left end of the respondent row in the the respondents list. The respondent's answers will be detailed and exactly how the answers were marked and open as html in another tab on your browser.

screenshot respondent row panel


An example of an individual respondent report can be found on the individual respondent report page.



Exporting to Google Drive™

When exporting to Google Drive™ first of all your export will be formatted and this may take a few seconds.

After that the Save to Google Drive™ button will appear. This is a widget supplied by Google. You should hover the mouse over it to see your current Google account login. Please note this does not require you be using a Google login to access Set YOUR own TESTS. Anyone with a Google account will be able to save to Google Drive™ so long as you are using Chrome browser. Other browsers might work but only Chrome can be guaranteed to be compatible with this Google feature.
showing the save to Drive button

After you click the Save button (Save to Google Drive™ button) another window will open which will let you confirm that you want to save and also allow you to choose the target Drive folder. Set YOUR own TESTS has no access to your Google Drive™. Set YOUR own TESTS grants permission for Google to access Set YOUR own TESTS to get your export - not the other way around.
Comments