Forum Discussion

quinncallan's avatar
quinncallan
New Member
10 years ago

Unable to properly export special characters to .csv

Hi Guys   When i export a report from Power BI to excel it does not correctly export the special characters, e.g. Životná is exported as Životná   I have a feeling it is something to do with ex...
morph268's avatar
morph268
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

This is because Excel by default open a CSV file as text file.

 

As a workaround, you can do the following:

1. Open Excel
2. Import the data using Data-->Import External Data --> Import Data
3. Select the file type of "csv" and browse to your file 
4. Change the Delimiter to comma
5. Select where to import to and Finish
6. You can go ahead and remove separator instruction.

 

https://help.tune.com/marketing-console/how-to-import-a-unicode-csv-to-excel/

 

 

 

morph268's avatar
morph268
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

and of course you can save-as XLSX after the import; so you don't have to keep repeating yourself