View Issue Details

IDProjectCategoryView StatusLast Update
0018481phpList 3 applicationSubscriber Exportpublic18-06-18 13:21
Reportersamtuke 
PrioritylowSeverityfeatureReproducibilityN/A
Status assignedResolutionopen 
Product Version3.2.6 
Target Version3.4.0Fixed in Version 
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.

Activities

samtuke

13-01-17 09:21

administrator   ~0058613

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

duncanc

14-01-17 12:42

developer   ~0058622

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

define("EXPORT_EXCEL",1);

samtuke

16-01-17 10:50

administrator   ~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.

samtuke

28-05-18 08:43

administrator   ~0060645

Better yet, replace the existing 'Export' buttons with muti-option dropdown buttons, including the two export options (CSV, or Excel CSV). E.g. https://getbootstrap.com/docs/4.0/components/dropdowns/#single-button-dropdowns