Power BI

Needs Votes

Export to CSV: regional settings support

Vote (455)

Gianni Bergamo on 08 Sep 2016 23:21:24

Add the possibility to export to CSV with support for regional settings (decimal separator, column separator, etc.)

Comments (49)

Comments (49)

Felix Brenkel on 05 Jul 2020 23:23:25

RE: Export to CSV: regional settings support

I really need this option ! It would also be nice to have a direct export of table grids to Excel without CSV.

Petr Voplakal on 05 Jul 2020 23:10:22

RE: Export to CSV: regional settings support

It shoud be also in import of CSV also according to regional settings

Thomas Häger on 05 Jul 2020 23:09:33

RE: Export to CSV: regional settings support

This would certainly help many of our users. Has this been approved for a roadmap yet? Any input for when it might become available?

Power BI User on 05 Jul 2020 23:09:03

RE: Export to CSV: regional settings support

This feature is very important or could be implemented a delimiter parameter.

Power BI User on 05 Jul 2020 22:51:34

RE: Export to CSV: regional settings support

Or at least they could put the line sep= on top of the csv file as this post says:

sep=,
COLUMN1|COLUMN2
data,1|data2

https://superuser.com/questions/407082/easiest-way-to-open-csv-with-commas-in-excel

Power BI User on 05 Jul 2020 22:35:58

RE: Export to CSV: regional settings support

Definitely a must have. Something so simple and yet it has a major impact on user experience in countries that do not use comma separated CSV-files.

Abel Filho on 05 Jul 2020 22:32:52

RE: Export to CSV: regional settings support

It would have been very useful today... had to do it manually.

Eric Hutton on 05 Jul 2020 22:32:15

RE: Export to CSV: regional settings support

This should be expanded to simply allow for more export options in general, such as to xls format

Andreas A on 05 Jul 2020 22:30:02

RE: Export to CSV: regional settings support

Highly recommend! The current CSV export is unusable in our regional settings and therefore in a hindrance in getting PowerBI penetration for the whole enterprise.