Export list of AGOL users into Excel?

3882
3
03-28-2018 04:49 PM
ChrisRyan3
New Contributor

Hi team,

We have an organisation with over 230 AGOL users. Is there an easy way to export the list of ArcGIS Online users with their user-level into Excel or another table format from the Administration page, so that their names can be checked against current staff lists?

I've checked a few forums but can't seem to find any answers.

Thanks,

Chris

3 Replies
KenDoman
Occasional Contributor II

Hello Chris,

If you're using Admin Tools for ArcGIS Online, we have a tool that does what you ask. Under the Users Tools, there is a tool in the far left column called Export Users to CSV. Comma Separated Values (CSV) is a format that can be opened by Excel or any other spreadsheet software available today.

When you use the Export Users to CSV tool, it first prompts you for the users you want to export (Hint: checking the checkbox at the top of the table will check all the users). Next, it prompts you for the fields to export. Fields include user names, first and last names, and the level. Finally, the tool will prompt you to confirm your selection. Upon confirmation, it will download the data and package it into a CSV file.

Admin Tools Export to CSV Field choices

Export Users to CSV is available in both our free and professional versions.

Hope this helps,

Ken

ChrisRyan3
New Contributor

Many thanks Ken,

I was able to use the Admin Tools to generate a csv list of all AGOL users.

It works well.

Kind regards,

Chris

0 Kudos
CRose
by
New Contributor III

There is now an option to export a report (in .csv format) of an organization's members or of its items. It is available under Organization > Status > Reports > Create report. See details in this post: View and report status—ArcGIS Online Help | Documentation