I'm trying to export a CSV of my members using Solspace User.
It works fine, except that when I open the CSV in Excel, it actually shows the quotes around the values. I know that obviously my template has quotes around each value, but some addresses have commas in them - without the quotes, it throws off the CSV.
My template looks like this: (I've added whitespace for readability).
{exp:ifelse parse="inward"}
{if group_id == 1 OR group_id == 6}
{exp:http_header content_type="text/csv"}
email, screen_name, address,
{exp:user:users limit="100000"}
"{email}", "{screen_name}", "{address}",
{/exp:user:users}
{if:else}
{redirect="404"}
{/if}
{/exp:ifelse}
Has anyone tried to do this sort of thing? Am I missing something obvious?
When opening in Excel, it looks like:
email | screen_name | address
------------------+--------------+------------------------
[email protected] | "John Smith" | "123 Street, Somewhere"
When using Finder's Quick Look, it looks just fine (no quotes).
I'm not sure if this is a general CSV issue, an issue with EE or an Excel thing.
Any help would be appreciated.
Edit
Actually, the first column doesn't show the quotes, but the rest do. Which I really don't understand.