Forum Discussion
Import correctly CSV into power query
I can import the file using this MCode:
= Csv.Document(File.Contents("Z:\test.csv"),[Delimiter=";", Encoding=1201, QuoteStyle=QuoteStyle.Csv])
Or do I miss something?
Victory it works, so what differ between what I did and what you did is the encoding number you used "1201"
Could you explain me how you selected this "encoding system" ?
I can import the file using this MCode:
= Csv.Document(File.Contents("Z:\test.csv"),[Delimiter=";", Encoding=1201, QuoteStyle=QuoteStyle.Csv])
Or do I miss something?
Nono it works with this encoding code 1201 but my question is how did you select this code ? because in the list proposed by power query you have lot of possibility and I always selected :
1252 (my regions) or 65001(and i suppose a kind of global code)