cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sbejawa Frequent Visitor
Frequent Visitor

comma separation issue when exported to Excel(CSV)

Hello,

 

For the currency column, I'm having problems when exporting to excel. 

In report view data is appearing with comma separation like (123,456.00).

But when i export it to excel(csv) is it coming like 123456.00

How to fix this issue? any help will be much appreciated.

 

thanks,

Srini

 

4 REPLIES 4
Anonymous
Not applicable

Re: comma separation issue when exported to Excel(CSV)

Data format and the actual underlying data are going to be distinct when working with that underlying data. If you need that format in Excel, you'll have to use the equivalent comma-separator feature in Excel to format the value after you export the data.

Microsoft v-huizhn-msft
Microsoft

Re: comma separation issue when exported to Excel(CSV)

Hi @sbejawa,

As I tested, I set data type as currency format, I export it to csv file, it has not the comma seperation, please see the screenshots below. When I set as $ English(unite status), it can works fine.

1.PNGshown in Power BI desktop2.PNGexport to CSV file 1.PNG

I test it in October version, what's your Power BI desktop version? Please update the latest version and check if it works fine.

Best Regards,
Angelia

sbejawa Frequent Visitor
Frequent Visitor

Re: comma separation issue when exported to Excel(CSV)

@v-huizhn-msft

 

Thanks for the reply. I don't see comma separator in the excel file that you attachment. 

And i want to format with rupees currency format.

with $ currency sysmbol i am able get comma separator in csv.

But when i use english(India) currency format , i am not able get comma separator. And i downloaded latest version of PowerBI.

 

thanks,

Srini

 

 

Microsoft v-huizhn-msft
Microsoft

Re: comma separation issue when exported to Excel(CSV)

Hi @sbejawa,

Sorry to mislead you, I edit my reply. I reproduce your scenario. After research, I find it's related to computer operation system, your os is english(us)? My local computer is english(us) version. You'd better change it in excel, please refer to this solution to change the formate in excel.

reference: https://superuser.com/questions/928536/how-do-you-format-numbers-in-excel-for-indian-currency-rupees

Best Regards,
Angelia

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors