View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0018481 | phpList 3 application | Subscriber Export | public | 12-01-17 16:26 | 18-02-19 10:33 |
| Reporter | samtuke | ||||
| Priority | low | Severity | feature | Reproducibility | N/A |
| Status | assigned | Resolution | open | ||
| Product Version | 3.2.6 | ||||
| Target Version | 3.5.0 | Fixed in Version | |||
| Summary | 0018481: Add support for Microsoft Excel CSV files | ||||
| Description | Some 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 | ||||
| Tags | No tags attached. | ||||
|
|
Initial testing with Microsoft Excel 2010 indicates that the default delimiter used is comma. |
|
|
With this setting some exports, but not all, will use comma as separator define("EXPORT_EXCEL",1); |
|
|
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. |
|
|
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 |
