Computer Help and Discussion For Moderators
How to save a member list to an Excel or .csv file.
To save a Yahoo Member list to an Excel file, first click Members and then Export.
The page will show all of the members, listed in alphabetical order. Click Select All from your browser menu and the click Copy. Open notepad and select paste. The members list is now in notepad. Click save as and use the option 'Save as' and the option 'all files'. Type the name you choose like this format: mymembers.csv
Now while still in notepad, click Replace under the Edit menu.
Replace What (type ') Replace with ( ) Without the ( )and press Replace all.
This will remove all of the ' marks so you can do effective sorts in Excel.
Save the document as a .csv file being sure to select the all file types and open in Excel or your Open Office spreadsheet.
Now you can format the column widths to show all the information and you can also delete the columns with no data.
If you are using Excel 2007, you can use Linda's conditional formating
tool to highlight different text fields to make custom sorts.
http://personal-computer-tutor.com/condformat2007.htm
For other Excel versions use this tutorial instead.
http://personal-computer-tutor.com/conditionalformatting.htm
To search for a member in a group, click Members and then Export. You will get a plain text file listed in alpha order.
While on your members listing, on your browser menu click Edit/ find in this page. In the Find field, type '@blogger.com' without the quotes.