Home Forums Newsletter Plugin Support Export Opened in Excel Fails

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #11584
    James
    Participant

    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?

    #11589
    Stefano
    Keymaster

    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.

    #11591
    James
    Participant

    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

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.