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-i...

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-da...

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

[CameronExplore]

Thanks for the advice, Christopher. I shall check these articles out.

Cheers!

[DougBrowning]

Get the ArcGIS for Excel extension for Excel.  Then you can just connect to the service directly live time.  No need to export at all.

Better yet build a modern Dashboard.  We have some super slick data and photo review dashboards that are way faster and less work then Excel (and are easy to make).  Excel is a very old school way to review data and not efficient.  

[CameronExplore]

Thanks for the advice Doug. I haven't heard of dashboards before. I have just looked it up, and they look really useful. 

Cheers!

[DuncanC]

The best options have already been covered, the only idea I have to add is you can use report templates to export them to word instead of excel.