CSV export uses comma as delimiter. Possible to change? #1594
Labels
0. Needs triage
Pending approval or rejection. This issue is pending approval.
enhancement
New feature or request
Is your feature request related to a problem? Please describe.
Export to CSV automatically uses comma as delimiter, which is pretty much always the worst idea of all.
A table entry simply needs to allow text input and a user entering a common sentence, which, by normal grammatically means, now and then requires to enter a comma.
The export of such data is immediately unsubale when exported to CSV.
I looked around in the Tables app, if there is any setting to change that to say semicolon, which is a lot more robust, but couldn't find one.
Even better would be a possibility for export to .xlsx , which immediately eliminates all potential delimiter related issues...
Edit:
I just figured, that Microsoft Excel uses the quotes surrounding a sentence with a comma to ensure all fits into one cell.
However, other office suites, like Onlyoffice, does not do that and therefore fails on import.
Describe the solution you'd like
A way to modify the delimiter character for CSV export.
Either globally or per user.
Even better would be export to Excel format .xlsx
Describe alternatives you've considered
There isn't any, which was obvious to me.
Additional context
No response
The text was updated successfully, but these errors were encountered: