Did you know? That with the recent release of Admin Tools for ArcGIS Online Pro it is possible to export any filtered or browsed list within ArcGIS Online to CSV, make mass changes to those records and then upload those changes back into ArcGIS Online? This functionality is available and simple but somewhat overshadowed by the abundance of powerful features found in the application. So in this post I would like to highlight why this is useful, where you can find the tools within the application and how it actually works.
Exporting information to CSV can be very useful for administrators of ArcGIS Online organizations who have hundreds or even thousands of items, groups and users and need the ability to filter this information by certain attributes, export that information to csv, use it for auditing purposes and make mass system wide changes . It can also prove quite useful for planning out administrative activities before executing them within the Admin Tools for ArcGIS Online application.
Example Scenario – If an ArcGIS Online Account has suffered from inconsistent management practices, and some logins have been generated without good attention to specific parameters. It can be a very hard thing to manage especially if there are hundreds of logins. Only 10 can be seen at a time within ArcGIS Online so a CSV with as much attribute data as possible would be great for being able to plan a strategy for taking care of the problem.
The “Export to CSV” command can be found in the bottom left corner of most all the Query Filter tools within the application. In some cases, where the list of items is very long, you may need to scroll to the end of the list to expose the export to CSV command. From here, you still have the filtering capabilities to pair down the list however you like by Title, Group, Owner, Tag, etc. You also have the ability to choose what attribute fields of the items you would like to view. The export will actually export all attributes available. At this point, clicking on the Export to CSV command will export the filtered list you have created to a csv file. This file can then be opened in applications such as Excel edited and then uploaded back into ArcGIS Online using the Upload CSV tool within Admin Tools for ArcGIS Online Pro.
Below is a video explaining how this functionality works.