Forum Discussion
Solved
Import correctly CSV into power query
Hello everyone, I am contacting you because I am having trouble importing a CSV file into Power Query, but without success... I can't seem to find the right method to do this. What drives me even c...
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" ?
And for additionnal info here a screenshot of the CSV file transformed automatically by excel in a clean way :
And what I have with power query :
We can see that CR LF are assimiled as a new raw 😞 even with the QuoteStyle = QuoteStyle.Csv parameter
Please note that csv file will be hosted on a online SharePoint
Thanks again