How can I get a list of all the members of my group which has Handle, Name and Rating of each member available like in spreadsheet. I have been searching for this but am obviously missing something.

I need this sorted on rating to better plan team matches.

You can't.  All you can do is list the members 10-to-a-page to get the handle (login name) - but real name and rating are not provided.

The usefulness of such a feature has been discussed: member-search---how-to-improve-it

Thanks.

I've thought of a method that will work.

1. Create a dummy Team Match against a dummy opponent [group].

2. (Making sure that AutoStart is set to 'NO')

3. Get all members of your group to sign up for it.

4. All members of your group will now be listed in rating order.

 No, you only ever create ONE team match. Any new member has to join it. The match never gets played. The ratings shown are always the current ones.

For a dummy team to play against, you will have to beg another group (or first create a dummy group yourself and accept this dummy challenge) to join a match that never was. You can't play against your own group.

The whole thing can be resolved if chess.com provides a report that is basic for arranging better matches.

Here's a DUMMY GROUP you can challenge.

Suggested features don't usually get implemented quickly. This is a workround that will not suit everybody.

Thanks Artfizz.

The technique works surprisingly well.

Yes, as long as members heed to the request of joining dummy match. In spite of few reminders quite a few active members don't. Well, that's why it's a work around, not the real thing...

Thanks again though. Am using for two groups (as you would be aware).

Is it because they are not interested in joining team matches - or are they just being uncooperative?

Uncooperative would be putting it a bit too strongly. Some of them may be thinking they have already joined (as they are also part of the other group where I am using your technique). Maybe some are shy - and don't want their fluctuating rating to have such high visibility...?