¿ªÔÆÌåÓý

  1. GroupManagersForum
  2. Topics

Downloading the membership list

 

Hi All,

I just tried to download our membership list but all it did was open a page in my browser with a long list of names email addys.

How do we get the CSV ?into a proper file??

--
-LeeAnne

?Archivist
 

On 2 May 2017 at 5:36, LeeAnne Bloye wrote:

I just tried to download our membership list but all it did was open a
page in my browser with a long list of names email addys. How do we get
the CSV ?into a proper file?
The download gives you a proper CSV file (comma-separated values).

All you have to do is command your browser to File > Save As, and create
a name & location.

--
Jim
Poston@...

<< Black holes are where God divided by zero. >>
 

LeeAnne,

I just tried to download our membership list but all it did was open
a page in my browser with a long list of names email addys.

How do we get the CSV into a proper file?
I usually copy that whole page (Ctrl+A, Ctrl+C) and paste it into a blank worksheet in Excel. But that's because I'm usually going to do some examination/analysis of it.

If you just want to keep the file for your records, you should be able to use the Save Page As feature in your browser to write the page to a file on your computer.

Shal
 

You guys rock! ?Thanks sooo much.?
--
-LeeAnne

?Archivist
 

LeeAnne

To get a .CSV of Members.

go Home|Admin|Members

See in the main part of the screen a list of members which can be sorted by:

Display Name ??? Email ??? Delivery ??? Joined

Select which members you want by Checkbox on left. (looks like if left All Unchecked they all download.)?

Then click on the Download button up at the top of the screen: ? Member, Bulk Removal, Download.

A new window opens of /g/my-site/memberlist.csv.? Do a File|Save ;

or you could Select the contents,? Copy and then Paste into a spreadsheet or a text document.

OK,

Tony
 

I can get to the stage where I have generated the CSV file and have the CSV file pasted into a blank worksheet in Excel, but Excel is not recognizing the comma to put each value in a separate cell.? With several hundred members, surely it isn't necessary to manually separate each one.? I am trying to get a membership list that I can sort by name of individual (last name would be nice) rather than alphabetically by email address.

I do not know if this problem is due to having some setting wrong in groups.io, or my inexperience with Excel, or a combination thereof.

I am generating the CSV file from the member tab under the administrative menu.? Should I be generating the membership list (by owner or moderator) from the main group directory?

Thanks,
Bill
 

Bill . . .

On Sun, 28 Apr 2019 08:20:17 -0700, "arkrail2001 via Groups.Io"
<arkrail@...> wrote:

I can get to the stage where I have generated the CSV file and have the CSV file pasted into a blank worksheet in Excel,
I've never used a CSV file from groups.io but I have from other
sources. What I've done is save the file as CSV and then open it
locally on my PC In Excel. I don't copy and paste anything, so that
may be where it's going awry on you.

Donald




----------------------------------------------------


Join the Icom group, a general Icom discussion group on Groups.io:
/g/ICOM (just launched)
Gerald Boutin
 

Bill,

If you paste itnto Excel, it cannot know that it was a csv file to begin with and doesn't do it's thing on the info.

If you save it as a csv file and then use Explorer to open the file with Excel, all should go as expected automagically.

On the other hand, going back to what you already have pasted into Excel, you can force the Excel parsing function.

Select all of the rows and do the following:
Data tab,? Text to Columns, Delimited, Next, Check "Comma", Finish

--
Gerald

1 - 8 of 8