I want to export the roles in salesforce to excel file or csv , is there anyway to do so, Any external tool is available for this exporting, could anyone fed some light on this.
Roles are exposed in the API as UserRole. You could use the DataLoader to run a SOQL query against this sObject and extract all the records to a CSV.
The FuseIT SFDC Explorer has an option to export SOQL query results as CSV.
It can export the SOQL query results as CSV. This will handle paging through all the query results for you.
Disclosure: I work for the company that makes this product. It is free to download and use.
- Exporting Data with the DataLoader.