Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

Export to Excel - UTF-8

Hi   Our end users are complaining that when they export data from PowerBI and open it in Excel, the text with cyrillic letters is not readable. This is due to the fact that the export is in UTF-8 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Have the users try this:

 

  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. In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
  5. Change the Delimiter to comma
  6. Select where to import to and Finish
Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

Hi Greg_Deckler and thanks for the reply.

 

The default application for opening csv files is set to MS Excel. Because of this the exported data file is opened directly with Excel and the cyrrilic letters are shown as gibberish.

 

I was thinking of setting the default csv application to Notepad, then the users could copy the text lines (all but the first), open Excel and from Paste->Use Text Import Wizzard paste the text into the sheet. Unfortunately I am sure the users will not like it.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    Yeah, understood, either way it is fairly complex for the user versus "double-click the file". Not sure of a way around it short of writing VBA code of some sort.

    • sofi's avatar
      sofi
      New Member
      10 years ago

      Hi, we have bag that describe below:

      We get the first row the letters [sep=,] its prevent us to open file in excel as you instructed us.

      Thanks