¿ªÔÆÌåÓý

  1. GroupManagersForum
  2. Topics

downloading members list #csv

 

¿ªÔÆÌåÓý

I¡¯ve just clicked on ¡°download¡± on the members page and see what looks like to me a page of gobbled-gook¡­ lol.

I realise that it a csv file and I have Excel (not that I know much about it), but I need to know how to get something that is printable and makes sense.

I have only a small membership so it is probably easier for me just to take a few screen captures of the membership pages and paste them in to Word.

Thanks for any help.

Win
 

On Tue, Jan 7, 2020 at 10:09 AM, WBennett wrote:

I¡¯ve just clicked on ¡°download¡± on the members page and see what looks like to me a page of gobbled-gook¡­ lol.

I realise that it a csv file and I have Excel (not that I know much about it), but I need to know how to get something that is printable and makes sense.

See?/g/GroupManagersForum/topic/69333373#26848

Bruce
 

On 07 Jan 2020 15:53, WBennett wrote:

I realise that it a csv file and I have Excel (not that I know much about it), but I need to know how to get something that is printable and makes sense.
A reliable way to open a CSV in Excel is to "import" the "data" from it. In Excel 2016, for example, go to the Data tab, and select "From Text/CSV".

If you try to open a CSV file in Excel directly, then Excel will make certain assumptions about it (for example, that the "C" in "CSV" is somehow an abbreviation for "tab").

Samuel
 

hi Samuel,
the ?C¡° is the abbreviation for ?Comma¡° - and Excel handles files with the ending .csv correctly if the columns are delimited by commas. But it also copes with Tabs and takes those as separators if it finds them I think. I just had to do both, using the import way.
When opening directly Commas work - haven¡¯t tried files with Tabs inside.
Thomas

Am 07.01.2020 um 16:16 schrieb Samuel Murray <samuelmurray@...>:

On 07 Jan 2020 15:53, WBennett wrote:

I realise that it a csv file and I have Excel (not that I know much about it), but I need to know how to get something that is printable and makes sense.
A reliable way to open a CSV in Excel is to "import" the "data" from it. In Excel 2016, for example, go to the Data tab, and select "From Text/CSV".

If you try to open a CSV file in Excel directly, then Excel will make certain assumptions about it (for example, that the "C" in "CSV" is somehow an abbreviation for "tab").

Samuel
 

On 07 Jan 2020 19:12, Thomas Gruber wrote:

the ?C¡° is the abbreviation for ?Comma¡° - and Excel handles files
with the ending .csv correctly if the columns are delimited by
commas.
Well... I've had some problems getting Excel to split by comma with
quite a number of CSV files lately. In my cases, Excel just puts everything from each line into the first column, and if there are tabs, it splits at the tab, despite the fact that it has a CSV file extension and the file is otherwise well-formed CSV. If you can get your Excel to open your CSV files correctly, then I'm glad for you.

This is why I was happy to discover the method of importing CSV files into an empty Excel file via the Data tab.

Samuel
 

On Tue, Jan 7, 2020 at 03:12 PM, Samuel Murray wrote:
Well... I've had some problems getting Excel to split by comma with
quite a number of CSV files lately.
Could be an issue with file associations. On my PC, anything with a CSV file extension is automatically recognized as an Excel file (i.e.: displays that icon) and opens as expected. If I change the extension to something else, I can still force comma-delimited by selecting "comma" instead of "tab" on the second dialog of the Text Import Wizard (see screenshot).



YMMV.

Bruce
 

There should be a dialog box where you can specify the divider.


On Tue, Jan 7, 2020, 12:12 Samuel Murray <samuelmurray@...> wrote:
On 07 Jan 2020 19:12, Thomas Gruber wrote:

> the ?C¡° is the abbreviation for ?Comma¡° - and Excel handles files
> with the ending .csv correctly if the columns are delimited by
> commas.

Well... I've had some problems getting Excel to split by comma with
quite a number of CSV files lately.? In my cases, Excel just puts
everything from each line into the first column, and if there are tabs,
it splits at the tab, despite the fact that it has a CSV file extension
and the file is otherwise well-formed CSV.? If you can get your Excel to
open your CSV files correctly, then I'm glad for you.

This is why I was happy to discover the method of importing CSV files
into an empty Excel file via the Data tab.

Samuel
 

In the latest versions of Excel (Office 365) you don¡¯t get that dialog box if you open the file directly (by double-clicking on the file itself in case of a CSV file). Only if you open Excel first, then import via the ?Data¡° tab. Then you can choose the divider.
Thomas

Am 07.01.2020 um 22:12 schrieb Ethan McKinney <ethan.mckinney@...>:

There should be a dialog box where you can specify the divider.
[excess quote trimmed by moderator]
 

Huh. I have Excel 365 (not sure how to check which build--they seem to hide that now), but I double-clicked a comma-delimited file and it opened perfectly. I opened it in Notepad confirm that it had commas, not tabs.

The file icon is Excel CSV and file type is "Microsoft Excel Comma Separated Values File."

Mysterious.

On Tue, Jan 7, 2020, 13:58 Thomas Gruber <computerhusky@...> wrote:
In the latest versions of Excel (Office 365) you don¡¯t get that dialog box if you open the file directly (by double-clicking on the file itself in case of a CSV file). Only if you open Excel first, then import via the ?Data¡° tab. Then you can choose the divider.
Thomas

Am 07.01.2020 um 22:12 schrieb Ethan McKinney <ethan.mckinney@...>:

There should be a dialog box where you can specify the divider.
[excess quote trimmed by moderator]
 

There is a nice "Text to Columns" wizard in Excel 2010 and beyond.

Go ahead and open the file and let it load each line into column A.

Then, in the ribbon, select Data-->Text to Columns.

Then, select whether the data is Fixed Width or Delimited (could be tabs, commas, spaces, or the character of your choice, or a combination of these). You can also specify the string delimiter, usually the default which is double quote ("). Commas, tabs, or other separators within a pair of quotes will be ignored, per the definition of CSV.

The display on this dialog opens on the first line of data, but often the first line is column titles. Scroll the display down a line or two, into the data, before making changes to get a better view of what will happen.

You will see Excel's guess. You can move the column breaks around, or add or delete them. You can also specify the format (general, text, date...), and you specify which columns may be deleted.

Larry
Gerald Boutin
 

On Tue, Jan 7, 2020 at 04:12 PM, Samuel Murray wrote:
On 07 Jan 2020 19:12, Thomas Gruber wrote:

the ?C¡° is the abbreviation for ?Comma¡° - and Excel handles files
with the ending .csv correctly if the columns are delimited by
commas.
Well... I've had some problems getting Excel to split by comma with
quite a number of CSV files lately. In my cases, Excel just puts
everything from each line into the first column, and if there are tabs,
it splits at the tab, despite the fact that it has a CSV file extension
and the file is otherwise well-formed CSV. If you can get your Excel to
open your CSV files correctly, then I'm glad for you.

This is why I was happy to discover the method of importing CSV files
into an empty Excel file via the Data tab.

Samuel
Samuel.

What you are seeing is Excel trying to be smart and save you time by automatically doing the text to column conversion for you.

Once Excel has imported a csv file the first time, it remembers the settings that you used to convert "text to columns". There are more details how to make it stop doing this at the URL below. By the way, I generally don't bother with that solution and just do what you do, which is to paste text into the spreadsheet.


?
--
Gerald
 

On 08 Jan 2020 05:11, Gerald Boutin wrote:

By the way, I generally don't bother with that solution and just do what you do, which is to paste text into the spreadsheet.
My solution does not involve pasting into the spreadsheet (although I seem to recall someone else made such a suggestion).

My solution is to open a blank worksheet and (in Excel 2016) use Data > Get & Transform Data > Get Data > From File > From Text/CSV. In Excel 2003, it's Data > Import External Data > External Data.

Samuel
Gerald Boutin
 

On Wed, Jan 8, 2020 at 04:20 AM, Samuel Murray wrote:
On 08 Jan 2020 05:11, Gerald Boutin wrote:

By the way, I
generally don't bother with that solution and just do what you do, which
is to paste text into the spreadsheet.
My solution does not involve pasting into the spreadsheet (although I
seem to recall someone else made such a suggestion).

My solution is to open a blank worksheet and (in Excel 2016) use Data >
Get & Transform Data > Get Data > From File > From Text/CSV. In Excel
2003, it's Data > Import External Data > External Data.

Samuel
Samuel,

My apologies. I missed your explanation while I was skimming earlier posts.?Excel certainly has many ways to skin a cat. I've been using Excel since Office 97 and gotten used to how some things were done back then.

--
Gerald
 

With all the info provided I have managed to bring in the members list, get it in to columns, deleted the columns I didn¡¯t want. Now how do I get the list sorted by date joined? I¡¯m using Excel 2016.

Thanks in advance

Win

?

?
 

¿ªÔÆÌåÓý

Hi Win,
this is slightly OT for the forum I think - feel free to contact me under my normal email address:
computerhusky AT

Short summary: select the column you want to use for sorting, open the the ribbon (the are with the lot of icons) under the ?Home¡° menu, click on ?Sort & Filter¡° (right hand side of the sheet), click on ?Sort A to Z¡°. or for more sophisticated sorting click on Custom Sort then select the sort columns you want.
Thomas


Am 09.01.2020 um 14:43 schrieb WBennett <del13piero@...>:

With all the info provided I have managed to bring in the members list, get it in to columns, deleted the columns I didn¡¯t want. Now how do I get the list sorted by date joined? I¡¯m using Excel 2016.
Thanks in advance
Win

?

?

1 - 15 of 15