¿ªÔÆÌåÓý

  1. GroupManagersForum
  2. Messages
Single Messages Topics Expanded Polls

Re: downloading members list #csv

 

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
Join [email protected] to automatically receive all group messages.