Forum Discussion

andersbegde's avatar
andersbegde
Copper Contributor
Nov 11, 2020
Solved

Importing XML into ExCel with PowerQuery, encoding not working.

Hi! I have a pretty big XML file, in which the encoding is UTF-8. There's a lot of occurences of special characters (æ,ø,å), which after import only shows up as as questionmark "boxes".   Usual...
excel
power bi
  • andersbegde's avatar
    andersbegde
    Nov 11, 2020

    andersbegde SergeiBaklan NikolinoDE 

     

    I've tried NikolinoDE 's solution and it works.

    What I did step by step was:

     

    1. Open the file in Notepad++

    2. Hit the "Encoding" tab and select "Convert to UTF-8-BOM".

    3. Save as separate file (doesn't matter I guess but I wanted to keep the other as backup).

    4. Open excel and import it normally via Data->Import From File (XML).

     

    Worked exactly as expected.

     

    Thanks for the replies both NikolinoDE and SergeiBaklan 

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Nov 11, 2020

andersbegde 

Not sure, since I'm not the big **bleep** in XML (to put it mildly). But I remembered that someone converted the csv file into text editor and then imported it into Excel and then it worked. but all of this without guarantee. As I said, I know that I don't know anything.

 

Hope I was able to help you.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

Resources