topic Export Survey123 Data to Excel in ArcGIS Survey123 Questions

Export Survey123 Data to Excel

FatmaŞenol — Fri, 23 Sep 2016 22:12:43 GMT

Hello,

I want to export Survey123 data to excel to analyze and create charts in different styles. It's possible to view data and analyze in ArcGIS Online and I find `Analyze` tool is quite impressive. However, Excel offers more advanced data analysis functions.

I tried to export data as a CSV file but when I open it in excel, I see the actual field names not alias as I expected. But the resulting table might be confusing for some users. Is there way to overcome this limitation ?

Regards

- Omur Saygin, PhD

Re: Export Survey123 Data to Excel

AdrianWelsh — Sat, 24 Sep 2016 06:28:19 GMT

Omur,

Could you just export your collected data to a file geodatabase and then in ArcGIS export your table to Excel?

First, in AGOL

Then in Desktop:

Table To Excel—Conversion toolbox | ArcGIS for Desktop

Or does that leave you with the same issue?

Re: Export Survey123 Data to Excel

FatmaŞenol — Sat, 24 Sep 2016 06:49:09 GMT

Adrian,

Thank you for your feedback. I will try the method you suggested and get back to you

asap.

Regards

Re: Export Survey123 Data to Excel

FatmaŞenol — Sat, 24 Sep 2016 16:59:29 GMT

Hello Adrian,

Your suggestion successfully worked out for me. Thank you for your help

Regards.

-Omur Saygin, PhD.

Re: Export Survey123 Data to Excel

AdrianWelsh — Sat, 24 Sep 2016 19:00:34 GMT

I'm glad it worked for you!

Re: Export Survey123 Data to Excel

Lake_Worth_BeachAdmin — Thu, 10 Aug 2017 13:34:21 GMT

It works but I need field managers to be able to export these tables on their own (and they do not have access to ArcGIS software). I need them to be able to export to excel files and download locally/email to themselves.

Re: Export Survey123 Data to Excel

AdrianWelsh — Fri, 11 Aug 2017 05:42:59 GMT

Joe,

Could there be a login that they would use for ArcGIS Online to where they could do their own exporting?

Re: Export Survey123 Data to Excel

Lake_Worth_BeachAdmin — Fri, 11 Aug 2017 13:07:04 GMT

Yes but that wont export the image attachments, in order to do that they need arcmap or catalog correct? Otherwise in AGOL they would have to click on each individual feature and download the images manually... they will not like this.

Re: Export Survey123 Data to Excel

JamesTedrick — Fri, 11 Aug 2017 17:48:43 GMT

Hi Joe,

Now that ArcGIS Online supports exporting to Excel, we will be working to bring that capability into Survey123 (Survey123 relies on the ArcGIS Online feature).

You're correct aha the only format that exports images along with the survey data is the File Geodatabase, as that's the only format that persists the attachment relationship. Aside from that, I've done some work on scripts that bulk download the images (see MapPhotos/ExportAttachments.py at master · tedrick/MapPhotos · GitHub ); this uses the new ArcGIS Python API (as opposed to the arcpy) and doesn't require a Desktop license. I don't think it's quite what would work well in your situation, though it may point to a script that could fit your needs (to begin with, it seems like you would want to provide a custom query to narrow the features to download images from.

One of the big stumbling blocks is that once out of the attachment relationship, we don't have information necessarily to relate the image back to the feature. If you have an opinion or desired design, I'd be happy to hear it.

Re: Export Survey123 Data to Excel

Lake_Worth_BeachAdmin — Tue, 15 Aug 2017 15:18:06 GMT

That makes sense with the attachments. Basically for these forms sometimes we will need to print individual reports which I will use the the print template you guys now offer which will include the images which is nice.

However currently you can only select one row(report) at a time, if you we could select multiple reports (date range) and use the print template function that would be helpful as well.

Survey123 is great and optimizing our workflows which i greatly appreciate, you guys are doing an awesome job!

Re: Export Survey123 Data to Excel

JamesTedrick — Tue, 15 Aug 2017 19:50:29 GMT

Hi Joe,

Yes, we want to enhance the report capability to be able to do bulk reports based on a selection or filter of records.

Re: Export Survey123 Data to Excel

Lake_Worth_BeachAdmin — Thu, 17 Aug 2017 19:15:40 GMT

Rough timeline on when that will be deployed?

Re: Export Survey123 Data to Excel

JamesTedrick — Thu, 17 Aug 2017 20:46:30 GMT

It would be best to say it is on the medium-isa roadmap. As part of supporting this, there's a fair amount of improvements that underly making this feature work well.