I see this from the help page:

How Can I Download My Member List And Message Archive?

On Groups.io, navigate to your group. To download your complete member list, click on the Members tab under the Admin tab in the sidebar. From there you will be able to download your member list.


But I don't understand what happens when I do that.? I click download and then a new tab webpage opens with the data all separated with commas.? What I really want is a CSV file that I can open via Excel with everything separated out into columns.? I'm only familiar with doing it that way.? Will someone help instruct me with the steps to opening this up in Excel.? I tried to copy the data that came up on the webpage, made it a txt file, then tried to open it via Excel using any and all delimiters, but nothing worked.

What's the right way of doing this?

OK, figured it out on my own.? No help needed.

开云体育

Would you be so kind as to share details of how you achieved a CSV format file?

On Mon, Dec 30, 2019 at 12:41 PM, txercoupemuseum.org wrote:

Would you be so kind as to share details of how you achieved a CSV format file?

What's displayed on the screen is actually the csv information, so it just needs to be saved as text.? Once the information is on the screen, I right-click, select Save Page As..., make sure the Type selected is Text Document, and save it with the CSV extension.

Duane
--
Help: /static/help
GMF's Wiki: /g/GroupManagersForum/wiki
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions

If there are others having this issue, this is what I did (I'm using a really old version of Firefox 48.0.2 with an iMac):

1.? Go to Members section on left panel.
2.? On the blue button on top, toggle to choose Members.
3.? Click Download.? A new screen appears with a list of the members in a not-so-friendly format.
4.? Right click on that page and choose Save Page As... and click save.
5.? This saves as a .CSV file and you can open it directly and it'll open via Excel and the columns are already separated out.
6.? You can save it as .xlsx after opening.

I hope this helped.

It is much easier to use the "Save Link As ..." function to save the member list. On Firefox you right-mouse click on the Download button and select the "Save Link As .." option. Other browsers may work slightly differently, but I would suspect they all have this ability. This directly saves the CSV format file without having to display and then save the page. It eliminates a step or two and is much cleaner and easier way to do this. I like to download a backup member list each month and it only takes a few moments to do all my lists.

Jonathan

ELM,

But I don't understand what happens when I do that. I click download
and then a new tab webpage opens with the data all separated with
commas.

What I usually do at that point is select all, copy (Ctrl+A Ctrl+C), then switch to Excel and paste (Ctrl+V) it into cell A1 of a sheet. Then use Text to Columns (Data menu) to split the data.

What I really want is a CSV file that I can open via Excel with
everything separated out into columns.

I see you've already figured that out. Normally I'm only interested in keeping the .xlsx file, not the .csv, which is why I use copy/paste.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list