Is there a way to export attached photos to excel from my survey123 collected data?

CameronExplore

I am using Survey123 to collect data on fixed assets in the built environment. 

I am taking photographs of the assets, however when I export to excel the attached photos are not appearing in a column.

It would help to have the photos to accompany the data for someone else to look at the asset. 

I could download photos separately and insert them, but I have thousands to look through. 

Is there a way to have the photos exported as well to the Excel spreadsheet? 

ChristopherCounsell

Photos are stored as file attachments. You need to download them one at a time or export to file geodatabase and then extract them.

After that, you need to include them in your table. Photo names could work but you may encounter an issue if you don't have unique filenames, and you may need to construct a link to a network drive so users can 'click' to open them.

The fastest and easiest way to achieve this is by using python. For example here is a python notebook on the Survey123 developers page:

https://developers.arcgis.com/survey123/guide/export-survey-data-with-attachments/

Here is another article on batch exporting photos from a file geodatabase:

https://support.esri.com/en-us/knowledge-base/how-to-batch-export-attachments-from-a-feature-class-in-000017450

A Survey123 blog on working with photos:

https://community.esri.com/t5/arcgis-survey123-blog/working-with-your-survey123-photos/ba-p/898605

Another, longer and more detailed one. 

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-download-survey-data/ba-p/1141835

The community have added comments to the above which might help progress it a touch further.