View Issue Details

IDProjectCategoryView StatusLast Update
0018481phpList 3 applicationSubscriber Exportpublic18-02-19 10:33
ReportersamtukeAssigned To 
Status assignedResolutionopen 
Product Version3.2.6 
Target Version3.5.0 
Summary0018481: Add support for Microsoft Excel CSV files
DescriptionSome versions of Microsoft Office do not support the CSV file formatting currently used by phpList. Excel 2010 does not provide options for changing delimiters; it simply opens them incorrectly formatted automatically.

Add the option to export data to the Microsoft-supported flavour of CSV files. E.g. use ; instead of tab as the default delimiter
TagsNo tags attached.



13-01-17 09:21

manager   ~0058613

Initial testing with Microsoft Excel 2010 indicates that the default delimiter used is comma.


14-01-17 12:42

updater   ~0058622

With this setting some exports, but not all, will use comma as separator



16-01-17 10:50

manager   ~0058630

That's helpful, thanks. To describe this feature in more detail: add a second d export button next to the existing 'export to csv' buttons on all relevant pages so that exporting to excel is always an option in the web UI, rather than an either/or choice in the phpList config file.


28-05-18 08:43

manager   ~0060645

Better yet, replace the existing 'Export' buttons with muti-option dropdown buttons, including the two export options (CSV, or Excel CSV). E.g.