Analyze results on the web
The easiest way to view your data is using the Survey123 website.
After signing in to the Survey123 website with your ArcGIS organization credentials, you can browse to the Analyze page of a survey to get a brief summary of your answers directly, without using any tools.
For each supported question in your survey, you'll see one section with different types of charts and optionally, a data table, which can reveal the trend of how your respondents answer the question.
Only Select One, Select Multiple, Integer, Decimal, Text, Date and Time questions are currently supported. Other questions will not appear on the page.
For Select One, Integer, and Decimal questions, charts (column, bar, and pie), a map view, and a data table will be available. For Select Multiple questions, only column and bar charts and a data table are generated. For Text questions, a wordcloud option is available. Date questions can be viewed as a histogram, and Time questions can be viewed as a line.
Additionally, you can hide and show each question on the page by using the Set Visibility dialog box to filter questions.
View all data online
On the Data page of the Survey123 website, you can also use the data table to view all collected records in your survey.
The data table lists the answers to all questions using one column for each question. If your survey uses repeat questions, the answers to those questions will reside in a separate table, or as attachments. Clicking a record will show related records and attachment files listed below the main table. If you check Show Individual Response, clicking a record will also show answers to all the questions for that record, to the right of the table. Within the Show Individual Response section you can also choose to Print Individual Response.
For spatial analysis, click Open in Map Viewer. You can also download the results.
The three scenarios where downloading your survey data is useful are as follows:
- Analysis in third-party tools—Stata, SPSS, SAS, Tableau, and Microsoft Excel are examples of the many tools available to analyze data. You can download data captured with Survey123 for ArcGIS in formats that these tools understand, such as CSV. You can also download your data in shapefile and file geodatabase formats if you want to use GIS tools compatible with these formats.
- Backup—Download the data you capture so you have an extra copy.
- Enterprise integration—Download your data so you can load it into your own database (Microsoft SQL Server, Oracle, and so on) or refine it before you bring it into your own enterprise system.
To download your data using the Survey123 website, complete the following steps:
- Sign in to the Survey123 website with your ArcGIS organization credentials.
- Under the title for your survey, click the Data button.
- Choose the output format you want to use (CSV, Excel, KML, shapefile, or file geodatabase) and download your data.
When referring to values from choice lists, CSV files and Excel spreadsheets store the name value rather than the label of the choice.
Downloading data manually as described above works well under general use. However, it is recommended that you use scripting when you download your survey data often. An example is when you pull data from ArcGIS daily, or hourly, into your own database for further analysis or QA/QC workflows.
The advantage of using a Python script is that you can run it at any time and get the latest data from your survey. You can also schedule your script to run at regular intervals.
This Python script demonstrates how you can download your Survey123 data into a local shapefile, file geodatabase, or CSV file. To run this script, do the following:
- Download the sample script onto a machine with ArcGIS Desktop 10.5.1.
- Edit with IDLE or a Python editor to configure your file parameters. The parameters that need to be set are as follows:
- featureService_ID—In ArcGIS Online or your own Portal for ArcGIS, browse to the details page of the feature service you want to download. Get the ID from the URL. It will look something like this: f4a06f02b1dd4b1f8904ed0d4e8713bd.
- output_format—Choose shapefile, file geodatabase, or CSV.
- download_folder—The output folder where you want the data to be saved.
- credentials—Typically the owner of the survey. In the script, replace the XXXXX and YYYYYY with your user name and password.
- portal_url—Optionally, you can define your own portal URL (if you're not using ArcGIS Online to host your surveys).