Export Items, Groups & Users from ArcGIS Online to CSV

Screen Shot 2015-01-28 at 6.37.45 AMDid you know? That with the recent release of Admin Tools for ArcGIS Online it is possible to export any filtered or browsed list within the application to CSV? This functionality is available and simple but somewhat overshadowed by the abundance of powerful features found in the application. So here I would like to highlight why this is useful, where you can find the tool 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 and use it for auditing purposes. 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.

Below is a screenshot of the application showing the steps for Exporting to CSV.

Neill Jobe is the Founder & CEO of GEO Jobe. Follow him on Twitter: @neilljobe

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.