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" ?
Huum, I haven't tried your solution yet.
The CSV file will be processed by someone else, someone who is not very good at this kind of thing/manipulation...
For info, I have not added any encoders or anything else, this CSV file is exported as isit is from a website with a MySQL database in the background.
What I want is for this person to upload the CSV file as is it is to a SharePoint, and then for me to import it automatically via Power Query.
Could what you mentioned be done via Power Query (automatically)?
I would like there to be as little manual handling as possible, especially for the person who will have to extract the CSV file every time an update is needed.
No, unfortunately it can't. Notepad++ will be your easiest option.