How to Export a SharePoint 2007 User List to Excel

We almost all faced this question from our users, “can you extract me the list of accounts we have in our site collection?”.

You can easily display the list of users by going in Site Actions > Site Settings > People And Groups, but there is no easy way under WSS 3.0, MOSS 2007, SharePoint Foundation and Server 2010 to export user list.

Here is the trick to export the list of users: