We are currently creating survey templates using xlsx forms, submitting data in the field using Survey123 Connect, navigating to the Survey123 web platform to export the results to Excel, then modifying the Excel spreadsheet to fit the format we need. We are also using a python code to download the photos into one folder and another software to relabel the photos.
I would like to simplify this process.
I know that to relabel the photos I need the arcpy module from ArcGIS Pro so I'm in the process of getting that approved by my boss. So that takes care of the photo labeling work.
However, I would like to write some code to download the survey data in an excel document and automatically modify the columns and cells.
If it's possible, how would I go about doing that?