Gerhard_Landauf's avatar
Gerhard_Landauf
Copper Contributor
Nov 08, 2022
Status:
New

Excel: add csv export filter, allowing to set field and decimal separator for international users !

Currently Excel writing csv files according to the user locale.
Examples:
For US-EN locale: field separator = comma, decimal separator is dot (.)
For DE locale (German) and various other: field separator = semicolon, decimal separator is comma (,)
This produces conflicts and even wrong values, when imported by Microsoft SQL Server, as it only allows correct processing of csv with US-EN convention (see above).
Steps to reproduce:
(1) Export a table in MS Excel on DE locale

(2) Example csv would be like:

Sam Smith;6,44;1800,1;charged


(3) When imported to MS SQL Server the decimal separator of both values is set wrongly !
(4) When the same csv is imported with US-EN convention, like:

Sam Smith,6.44,1800.1,charged

then values in MS SQL Server are correct
Current official recommendation by Microsoft to international users is: Change locale of application to EN-US, then export table as csv, afterwards change back to your native locale again.
This is a very unprofessional workaround and inacceptable for international users !

Feature Request:

Please allow selection of field separator and decimal separator via save menu, when saving a table as csv !

No CommentsBe the first to comment