nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export Survey123 Data to Excel

FatmaŞenol

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

Encuentra más publicaciones etiquetadas con

Accepted answers

AdrianWelsh

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?

All comments

Lake_Worth_BeachAdmin

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!

JamesTedrick

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.

Lake_Worth_BeachAdmin

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.

AdrianWelsh

Joe,

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

Lake_Worth_BeachAdmin

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.

AdrianWelsh

I'm glad it worked for you!

FatmaŞenol

Hello Adrian,

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

Regards.

-Omur Saygin, PhD.

FatmaŞenol

Adrian,

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

asap.

Regards

AdrianWelsh

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?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.