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.
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 repeats, the answers to questions within those repeats will be available in another tab of the table view. The Layer List icon in the upper-right of the map view allows you to show or hide any tables in the feature service, while the drop-down menu in the upper right of the table view allows you to check whether or not selecting a record will also select related records. If you check Show Individual Response, clicking a record will also show answers to all the questions for that record, including attachments, to the right of the table. Within the Show Individual Response section you can also choose to Print Individual Response, as well as open the Settings menu to select whether or not to display related repeat records or the display size of any attached images.
The individual response panel also provides an Edit button, to allow the survey owner or users that have been given permission to edit their own features, to edit existing records. The survey owner can also edit responses in the data table by double-clicking on an individual field.
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:
- Open the Survey123 website. Sign in to your ArcGIS organizational account.
Using ArcGIS Online
Go to https://survey123.arcgis.com.
Using ArcGIS Enterprise
Go to https://survey123.arcgis.com/?portalUrl=https://host.domain.com/webadaptor/ (where host, domain, and webadaptor are replaced by information about your portal).
- 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).