How to export members to Excel

I have exported my members to Excel using .csv. The file will also contain text delimiters in the form of " " ".
Then I try to import it into Excel specifying "comma" as field/column separator and "  "  " as text delimiter.
My Excel uses " ; " as separator. I have not found a working method for this data transfer.
- The problems I encounter are that the text delimiters seem improperly placed.
- And that all commas, even those that should be placed within text delimiters, are used as  field/column delimiters.

Thus, a typical export works more or less as expected up until the column "gids" where the embedded "comma"s are all interpreted as "New Column".
The next problem column is "params" where all embedded commas are again interpreted as "New Column".
Further on, all my own "Comment Fields" that happen to include commas are again split into several columns.

This is very annoying and complicates all exports (and any attempts to import too).

Is there some good work-around for this problem?
Or could the exporting algorithms be modified somehow?
  I.e. allow me to specify the field separator as ";" instead of ","?
Or could a new export mode (Export to .xls) be created?

Kind regards / Ake



 

When opening the exported CSV you'll need to set the following.

1. Character set: UTF-8
2. Separated by Comma
3. Format quoted fields as text
4. " as string delimiter

Yes, krileon,

I did all that. My problem is still as described.
I suggest that a new export solution is implemented.

Regards / Ake2017

The CSV opens fine in LibreOffice and Google Sheets. We also provide JSON and XML export. I believe your settings maybe incorrect somewhere. Below are screenshots of it exporting fine and opening fine.

Open
 

CSV
 

Plain Text
 

Well, it does not open fine in -my- LibreOffice.
I verified my Opening settings, they are similar to yours (but Swedish instead of English).
And the result is as I have written before, that the GID column is split into several columns.

However, when I open my exported csv file in the text editor it shows the GID column differently from your file.
I see ...0,""[""""2"""", """"11""""]"",2015... (GID in the middle) -- whereas you see ...0,"[""2"", ""3""]",2012...

So, it seems that my exported file is different from yours. And that may explain why my embedded comma results in a new column.
So why is that? (My CB is ver 2.11.0 and my Joomla is 5.4.1)

Please be sure you've the latest build release installed. The export/import improvements aren't in a stable release yet (2.11.1).

forge.joomlapolis.com/issues/9733