Export Opened in Excel Fails

[James]

Here is an example of what it looks like in Excel 2010 http://screencast.com/t/nknB4WSNN
It doesn’t properly list the correct columns.
Can this be fixed?

[Stefano]

It’s strange, te format is Excel compatible… anyway, select the first column, go to the “data” menu and choose “text to columns”. Set the separator to semicolon and the text delimiter to double quote.

How did you open it? Just double clicking on the file icon? On windows? Mac?

Stefano.

[James]

Ok yes after it downloads in chrome on Windows, just clicking the download to open the file.

Oddly enough I found a code fix for it: In users.php line 88 right below
header(‘Content-Disposition: attachment; filename=”newsletter-subscribers.csv”‘);
put this:
echo “sep=;\n”;
And that will force Microsoft excel to open it properly
Thanks,
Jim

[Author]

Posts