Gerhard_Landauf
Nov 08, 2022Copper Contributor
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